EL1 C2 Flashcards
When the Trace Error button appears, what is displayed in the upper left corner of the active cell?
a small, dark green triangle
What type of cell values will the AVERAGE function ignore and not use in its calculation?
blank cells
When writing a formula by pointing, this displays at the left side of the Status bar.
Point
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
What symbol is used to indicate an absolute cell reference?
$
Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?
F4
What will happen if you press Ctrl + ` (grave accent)?
the worksheet will display formulas instead of results
What does the error code #N/A mean?
an argument parameter has been left out of a function
Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box…?
insert function
Which of the following is not one of the categories of functions offered by Excel?
scientific
What does the MIN function return?
the minimum function in a range
A built-in formula, such as =SUM, is called a(n)…?
function
The process of calculating a formula and inserting the value in a cell is referred to as…
returning the result
Which of the following formulas shows an example of a mixed cell reference?
=$A$3+B$3
Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called…
arguments
What does the COUNT function count?
the number of numeric values in a range
Which of the following is not a common mistake made while inputting data in a formula?
writing a formula by pointing rather than typing the formula
If one of the cells in a range of cells you use as an argument for an AVERAGE function contains text instead of numbers, what will Excel do?
ignore the text and calculate the average
Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
editing
HOME
What does it mean for a formula to have a mixed cell reference?
it has a cell reference in which one component (row or column) is relative, while the other is absolute
Use this keyboard command to display the Insert Function dialog box.
Shift + F3
An Insert Function button can be found on the FORMULAS tab and…
the formula bar
When writing your own formulas, you must begin each formula with…
an equals sign =
The Trace Error button is a type of…
smart tag
Excel’s functions are grouped into _____ categories.
13
Use this function key to update a NOW or TODAY function.
F9
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
How many functions can Excel perform?
more than 300
Which of the following is not one of the types of cell references discussed in Chapter 2?
dynamic
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?
the formula will change to =SUM(A3:C3)
The function that returns the arithmetic mean of the arguments is called…
average
The multiple layers of parentheses in a formula are called…
nested parentheses
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
At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.
Number1
In the Insert Function dialog box, what displays in the Select a function list box?
the most recently used functions
An absolute cell reference _____ change when copied to another cell.
does not
If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?
MAX
When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?
a temporary moving border is placed around the cell
What happens to formulas with relative cell references when they are copied using the fill handle?
a relative version of the formula is copied into the selected cell(s)
Use this keyboard command to display formulas in a worksheet.
Ctrl + `
In Excel’s order of operations, which type of operation happens first?
negations
This function returns the current date in a date format.
=TODAY()
In terms of an Excel formula, what is a constant?
a value entered directly into a formula
Indicate what the following formula will do: =B2/C2.
it will divide the contents of cell B2 by the contents of cell C2
What error code will display in a cell when a function name is not entered correctly into a formula?
NAME?
Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.
formula auditing
FORMULAS
After typing a formula into a cell, you can finish by pressing any of the following keys except…
spacebar
The Trace Error button allows you to do each of the following except…
delete the formula containing the error
When writing a formula by pointing, how do you end the formula?
press the enter key