Which keyboard shortcut turns on Edit mode?
  • [F2]
  • label
  • absolute
  • edit
You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.
  • templates
  • create what-if data scenarios
  • arrow
  • $
In the formula =D1+C1/F3, which calculation will be performed first?
  • the number of decimal places in the rounded number
  • C1/F3
  • arrow
  • function
To move one screen to the left press ____.
  • [Alt] [Page Up]
  • =($A6+$A$7)*0.20
  • fill handle
  • = (equals sign)
A(n) ____ is an entry in a cell that contains text such as "2016 Sales" or "Travel Expenses."
  • function
  • scroll bars
  • templates
  • label
In the formula =ROUND(D4:F4,0), what does the zero indicate?
  • budgets, balance sheets, time cardsall of the above
  • the number of decimal places in the rounded number
  • the clipboard automatically deletes the oldest item on the clipboard
  • C1/F3
The Excel operator for division is ____.
  • [Alt] [Page Up]
  • /
  • $
  • formula
Excel recognizes an entry as a value if it is a number or it begins with ____.
  • $ , + , = All of the above
  • the data remains in its original location
  • preserve the relationship to the formula location
  • typing the function argument
You can use predesigned, formatted files called ____ to create new worksheets quickly.
  • templates
  • scroll bars
  • fill handle
  • arrow
The entry in cell B15 is =SUM(B5:B14) which is a ____.
  • formula bar
  • formula
  • workbook
  • label
You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.
  • zoom
  • scroll bars
  • arrow
  • show
You can use ____ to move around in a document that is too large to fit on the screen at once.
  • fill handle
  • scroll bars
  • absolute
  • [Ctrl][Home]
Excel templates include which of these common documents?
  • budgets, balance sheets, time cardsall of the above
  • the number of decimal places in the rounded number
  • preserve the relationship to the formula location
  • $ , + , = All of the above
In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?
  • portrait
  • sheet tabs
  • (G15-G14)
  • the number of decimal places in the rounded number
The name Peter is entered in cell BThis is a ____.
  • excel template
  • .xlsx
  • formula
  • label
The Excel operator for exponent is ____.
  • /
  • functions
  • ^
  • label
Which of the following is a complex formula?
  • [F2]
  • = (equals sign)
  • =(B4/B8)*10
  • worksheet
To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells.
  • zoom
  • show
  • edit
  • HOME
Functions can be entered for formulas using all of the following methods except ____.
  • Arithmetic
  • = (equals sign)
  • typing the function argument
  • the data remains in its original location
Which formula contains a mixed cell reference?
  • absolute
  • (G15-G14)
  • formula bar
  • =($A6+$A$7)*0.20
Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?
  • [F4]
  • [F2]
  • show
  • data
____ operators perform mathematical calculations such as adding and subtracting.
  • Arithmetic
  • sheet tabs
  • worksheet
  • function
To quickly jump to the first cell in a worksheet press ____.
  • worksheet
  • [Ctrl][Home]
  • [Alt] [Page Up]
  • scroll bars
Which method of entering a function requires the user to know the name and initial characters of a function?
  • create what-if data scenarios
  • manually typing the function
  • pasting cell selectors
  • the data remains in its original location
In Excel, a worksheet is contained in a file called a ____.
  • [Ctrl][Home]
  • function
  • formula
  • workbook
Which of the following is NOT a Paste list arrow option?
  • =($A6+$A$7)*0.20
  • manually typing the function
  • just starting to type
  • pasting cell selectors
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
  • the data remains in its original location
  • fill handle
  • typing the function argument
  • create what-if data scenarios
Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.
  • data
  • budgets, balance sheets, time cardsall of the above
  • [F4]
  • edit
The COUNTA function is used to count the number of cells in a range that contain which type of data?
  • cell references are automatically adjusted
  • preserve the relationship to the formula location
  • numbers, dates, formulas all of the above
  • the data remains in its original location
You can use the ____ key(s) on the keyboard to navigate a worksheet.
  • arrow
  • edit
  • zoom
  • scroll bars
An Excel user should use a relative cell reference when it is important to ____.
  • worksheet
  • templates
  • cell references are automatically adjusted
  • preserve the relationship to the formula location
To display gridlines on a worksheet, click the Gridlines check box in the _____ group on the View tab.​
  • HOME
  • zoom
  • show
  • data
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
  • 5
  • ^
  • spreadsheet
  • show
The Undo button allows you to reverse up to ____ previous actions, one at a time.
  • scale to fit
  • .xlsx
  • 100
  • zoom
A(n) ____ is a built-in formula that uses arguments to calculate information.
  • functions
  • label
  • function
  • portrait
You can edit the contents of the active cell by ____.
  • create what-if data scenarios
  • arrow
  • pasting cell selectors
  • just starting to type
The ____ option helps fit the data on a single page without making changes to individual margins.
  • Arithmetic
  • scale to fit
  • formula bar
  • excel template
You can change, or ____, the contents of an active cell at any time.
  • data
  • portrait
  • edit
  • C1/F3
When cells are copied using Excel's copy function, what happens to the data in the copied cells?
  • the number of decimal places in the rounded number
  • sheet tabs
  • cell references are automatically adjusted
  • the data remains in its original location
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
  • the number of decimal places in the rounded number
  • cell references are automatically adjusted
  • the clipboard automatically deletes the oldest item on the clipboard
  • the data remains in its original location
All functions begin with the formula prefix ____.
  • =($A6+$A$7)*0.20
  • functions
  • underscore ( _ )
  • = (equals sign)
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
  • scale to fit
  • function
  • worksheet
  • sheet tabs
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0