# Module 2 Study Guide

## Unlock all answers in this set

question
Functions
In Excel, MAX and AVERAGE are examples of _____.
question
(\$A6+\$A\$7)*0.20
Which formula contains a mixed cell reference?
question
All of the above
The COUNTA function is used to count the number of cells in a range that contain which type of data?
question
(G15-G14)
In the formula =(G15-G14)*\$M\$3/4, which mathematical operation is performed first?
question
HOME
To insert cells, click the Insert list arrow in the Cells group on the _____ tab, then click Insert Cells.
question
The clipboard automatically deletes the oldest item on the clipboard
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
question
[F4]
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?
question
= (equal sign)
All functions begin with the formula prefix ____.
question
The data remains in its original location
When cells are copied using Excel's copy function, what happens to the data in the copied cells?
question
Manually typing the function
Which method of entering a function requires the user to know the name and initial characters of a function?
question
The number of decimal places in the rounded number
In the formula =ROUND(D4:F4,0), what does the zero indicate?
question
=(C12+C13)*F4
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?
question
Relative
A ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.
question
All of the above
Excel templates include which of these common documents?
question
[F2]
Which keyboard shortcut turns on edit mode?
question
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
question
=(B4/B8)*10
Which of the following is a complex formula?
question
Typing the function argument
Functions can be entered for formulas using all of the following methods except ____.
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
Pasting cell selectors
Which of the following is NOT a Paste list arrow option?
question
Data