EL1 C2

Question 1

When the Trace Error button appears, what is displayed in the upper left corner of the active cell?

Answer 1

a small, dark green triangle

Question 2

What type of cell values will the AVERAGE function ignore and not use in its calculation?

Answer 2

blank cells

Question 3

When writing a formula by pointing, this displays at the left side of the Status bar.

Answer 3

Point

Question 4

To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a…

Answer 4

thin black cross

Question 5

What symbol is used to indicate an absolute cell reference?

Answer 5

$

Question 6

Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?

Answer 6

F4

Question 7

What will happen if you press Ctrl + ` (grave accent)?

Answer 7

the worksheet will display formulas instead of results

Question 8

What does the error code #N/A mean?

Answer 8

an argument parameter has been left out of a function

Question 9

Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box…?

Answer 9

insert function

Question 10

Which of the following is not one of the categories of functions offered by Excel?

Answer 10

scientific

Question 11

What does the MIN function return?

Answer 11

the minimum function in a range

Question 12

A built-in formula, such as =SUM, is called a(n)…?

Answer 12

function

Question 13

The process of calculating a formula and inserting the value in a cell is referred to as…

Answer 13

returning the result

Question 14

Which of the following formulas shows an example of a mixed cell reference?

Answer 14

=$A$3+B$3

Question 15

Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called…

Answer 15

arguments

Question 16

What does the COUNT function count?

Answer 16

the number of numeric values in a range

Question 17

Which of the following is not a common mistake made while inputting data in a formula?

Answer 17

writing a formula by pointing rather than typing the formula

Question 18

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?

Answer 18

ignore the text and calculate the average

Question 19

Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.

Answer 19

editing
HOME

Question 20

What does it mean for a formula to have a mixed cell reference?

Answer 20

it has a cell reference in which one component (row or column) is relative, while the other is absolute

Question 21

Use this keyboard command to display the Insert Function dialog box.

Answer 21

Shift + F3

Question 22

An Insert Function button can be found on the FORMULAS tab and…

Answer 22

the formula bar

Question 23

When writing your own formulas, you must begin each formula with…

Answer 23

an equals sign =

Question 24

The Trace Error button is a type of…

Answer 24

smart tag

Question 25

Excel’s functions are grouped into _____ categories.

Answer 25

13

Question 26

Use this function key to update a NOW or TODAY function.

Answer 26

F9

Question 27

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.

Answer 27

parentheses

Question 28

How many functions can Excel perform?

Answer 28

more than 300

Question 29

Which of the following is not one of the types of cell references discussed in Chapter 2?

Answer 29

dynamic

Question 30

If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?

Answer 30

the formula will change to =SUM(A3:C3)

Question 31

The function that returns the arithmetic mean of the arguments is called...

Answer 31

average

Question 32

The multiple layers of parentheses in a formula are called...

Answer 32

nested parentheses

Question 33

What does it mean for a formula to have relative cell references?

Answer 33

the cell references change when the formula is copied to a new cell

Question 34

At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.

Answer 34

Number1

Question 35

In the Insert Function dialog box, what displays in the Select a function list box?

Answer 35

the most recently used functions

Question 36

An absolute cell reference _____ change when copied to another cell.

Answer 36

does not

Question 37

If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?

Answer 37

MAX

Question 38

When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?

Answer 38

a temporary moving border is placed around the cell

Question 39

What happens to formulas with relative cell references when they are copied using the fill handle?

Answer 39

a relative version of the formula is copied into the selected cell(s)

Question 40

Use this keyboard command to display formulas in a worksheet.

Answer 40

Ctrl + `

Question 41

In Excel’s order of operations, which type of operation happens first?

Answer 41

negations

Question 42

This function returns the current date in a date format.

Answer 42

=TODAY()

Question 43

In terms of an Excel formula, what is a constant?

Answer 43

a value entered directly into a formula

Question 44

Indicate what the following formula will do: =B2/C2.

Answer 44

it will divide the contents of cell B2 by the contents of cell C2

Question 45

What error code will display in a cell when a function name is not entered correctly into a formula?

Answer 45

#NAME?

Question 46

Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.

Answer 46

formula auditing FORMULAS

Question 47

After typing a formula into a cell, you can finish by pressing any of the following keys except...

Answer 47

spacebar

Question 48

The Trace Error button allows you to do each of the following except...

Answer 48

delete the formula containing the error

Question 49

When writing a formula by pointing, how do you end the formula?

Answer 49

press the enter key