# Quiz 5- Excel Modules 1 And 2

## Unlock all answers in this set

question
The Excel operator for division is ____.
/
question
____ operators perform mathematical calculations such as adding and subtracting.
Arithmetic
question
To quickly jump to the first cell in a worksheet press ____.
[Ctrl][Home]
question
While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​
formula bar
question
The name Peter is entered in cell B4. This is a ____.
label
question
A named range must begin with a letter or a(n) _____.​
underscore ( _ )
question
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?
100
question
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
sheet tabs
question
The entry in cell B15 is =SUM(B5:B14) which is a ____.
formula
question
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
5
question
You can edit the contents of the active cell by ____.
just starting to type
question
The _____ sheet button allows you to add worksheets to a workbook.​
new
question
The Excel operator for exponent is ____.
^
question
In Excel, the electronic spreadsheet you work in is called a ____.
worksheet
question
Possible paper orientations for printing a worksheet are landscape and ____.
portrait
question
In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.
value
question
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
question
The Undo button allows you to reverse up to ____ previous actions, one at a time.
100
question
To display gridlines on a worksheet, click the Gridlines check box in the _____ group on the View tab.​
show
question
A(n) ____ is a built-in formula that uses arguments to calculate information.
function
question
Excel recognizes an entry as a value if it is a number or it begins with ____.
\$ , + , = All of the above
question
You can use ____ to move around in a document that is too large to fit on the screen at once.
scroll bars
question
In Excel, a worksheet is contained in a file called a ____.
workbook
question
You can use the ____ key(s) on the keyboard to navigate a worksheet.
arrow
question
You can use predesigned, formatted files called ____ to create new worksheets quickly.
templates
question
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.
\$
question
An Excel user should use a relative cell reference when it is important to ____.
preserve the relationship to the formula location
question
Which method of entering a function requires the user to know the name and initial characters of a function?
manually typing the function
question
To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.
fill handle
question
Which of the following is a complex formula?
=(B4/B8)*10
question
Which of the following is NOT a Paste list arrow option?
pasting cell selectors
question
Which type of cell reference preserves the exact cell address in a formula?
absolute
question
How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?
=(C12+C13)*F4
question
Which tab and group will allow the insertion of rows and columns in a worksheet?
Home tab, Cells group
question
In the formula =(G15-G14)*\$M\$3/4, which mathematical operation is performed first?
(G15-G14)
question
When cells are copied using Excel's copy function, what happens to the data in the copied cells?
the data remains in its original location
question
All functions begin with the formula prefix ____.
= (equals sign)
question
The default file extension for an Excel 2016 workbook is ____.
.xlsx
question
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
question
In the formula =ROUND(D4:F4,0), what does the zero indicate?
the number of decimal places in the rounded number
question
Functions can be entered for formulas using all of the following methods except ____.
typing the function argument
question
Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.
data
question
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
the clipboard automatically deletes the oldest item on the clipboard
question
The COUNTA function is used to count the number of cells in a range that contain which type of data?
numbers, dates, formulas all of the above
question
The file extension .xltx indicates what type of Excel file?
excel template
question
In the formula =D1+C1/F3, which calculation will be performed first?
C1/F3
question
In Excel, MAX and AVERAGE are examples of ____.
functions
question
Which keyboard shortcut turns on Edit mode?
[F2]
question
A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.
relative
question
Excel templates include which of these common documents?
budgets, balance sheets, time cards all of the above
question
You can change, or ____, the contents of an active cell at any time.
edit
question
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
create what-if data scenarios
question
To move one screen to the left press ____.
[Alt] [Page Up]
question
The ____ option helps fit the data on a single page without making changes to individual margins.
scale to fit
question
A(n) ____ is an entry in a cell that contains text such as "2016 Sales" or "Travel Expenses."
label
question
You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.