BT-24: Ch.2: Excel 2016 L1
What error code will display in a cell when an argument parameter does not meet a function's requirements?
#NUM!
Which of the following characters does Excel use to represent the mathematical operator for multiplication?
*
Which of the following characters does Excel use to represent the mathematical operator for division?
/
Which of the following contains a mixed cell reference?
=A12*C$2
The function that returns the arithmetic mean of the arguments is called
AVERAGE.
The Function Library group on the Formulas tab contains each of the following function categories except
Biological.
Use the _____ function to count the numeric values in a range.
COUNT
Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
Editing; Home
When writing a formula by pointing at the desired cell references, complete the formula by pressing the _____ key.
Enter
Instead of typing dollar signs to indicate absolute cell references, you can press the _____ function key repeatedly to cycle through the various combinations of cell references.
F4
Update a workbook that contains the NOW or TODAY function by pressing this function key.
F9
Use this function key to update a NOW or TODAY function.
F9
Display formulas in a worksheet by clicking the Show Formulas button in this group on the Formulas tab.
Formula Auditing
Which function(s) would you use to find which employee has used the most vacation days and which has used the least?
MAX and MIN
The _____ function returns the current date and time in a date-and-time format.
NOW
When writing a formula by pointing, how do you end the formula?
Press the Enter key.
Use this keyboard command to display the Insert Function dialog box.
Shift + F3
What does it mean for a formula to have relative cell references?
The cell references change when the formula is copied to a new cell.
To display all formulas in the worksheet (rather than their results) press Ctrl +
` (grave accent).
What symbol is used to identify an absolute cell reference?
a dollar sign ($)
This cell reference refers to a cell in a specific location.
absolute cell reference
When writing your own formula, always begin the formula with
an equals sign (=).
What type of cell values will the AVERAGE function ignore and not use in its calculation?
blank cells
The AVERAGE function will ignore cells containing text and
blank cells.
To copy a formula to other cells using the Fill button, begin by selecting the
cell containing the formula as well as the cells to which the formula will be copied.
In the formula =SUM(A4:A17), the cell range (A4:A17) is an example of a(n)
cell reference argument.
A cell reference can be any of the following except
circular.
An absolute cell reference _____ change when copied to another cell.
does not
The Trace Error button displays with a(n) _____ inside a diamond.
exclamation point
A built-in formula, such as =SUM, is called a(n)
function
In the formula =SUM(A10:A15), the =SUM portion is referred to as the
function.
How many functions can Excel perform?
more than 300
When a formula contains two or more operators, Excel uses a specific order of operations to determine the sequence in which the operations are executed. Which of the following is the correct order of operations?
negations, percentages, exponentiations, multiplications, divisions, additions, subtractions
If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.
parentheses
When a value calculated by a formula is inserted in a cell, this process is referred to as
returning the result.
The Trace Error button is a type of
smart tag
What is the general term for a pop-up button like the Trace Error button?
smart tag
By default, what displays in the Select a function list box in the Insert Function dialog box?
the most recently used functions
To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a
thin black cross.
To use the Formula AutoComplete feature, click the desired cell, type the equals sign, and then
type the first letter of the desired function.
