Deck 5: Excel Lesson 3: Using Formulas and Functions

Question 1

A(n) constant refers to the text, numbers, or cell references on which a function is to be performed.

Answer 1

False

Question 2

When you click the Error Checking button, Excel checks for common errors in your worksheet and displays the Error Checking dialog box with options for resolving the error.

Answer 2

True

Question 3

Excel provides the user with built-in formulas, called functions , that enable you to perform complex calculations easily.

Answer 3

True

Question 4

You can click the Expand button to reduce the size of the Function Arguments dialog box temporarily.

Question 5

A mixed reference contains both relative and absolute cell references.

Question 6

____ are numbers entered directly into a formula that do not change.

A) Operators
B) Constants
C) Functions
D) Arguments

Question 7

If you want to change the order of operations, you use parentheses to group expressions in your formula.

Question 8

A cell with an error displays a triangle in the lower-right corner.

Question 9

An Excel formula must begin with the equal sign (=) .

Question 10

When you point to the fill handle on a selected cell, the pointer turns to a black cross that you can click and drag.

Question 11

A forward slash (/) is the arithmetic operator used for subtraction.

Question 12

When you click the Sum button arrow, a menu of the most common financial functions is displayed.

Question 13

Using ____, you can compare two values to obtain a logical value, either TRUE or FALSE.

A) the order of operations
B) comparison operators
C) arithmetic operators
D) mixed references

Question 14

In a formula, when Excel performs calculations in the normal algebraic precedence, which calculation is executed first?

A) multiplication
B) addition or subraction
C) exponentiation
D) division

Question 15

You can use a combination of constants and cell references in a formula.

Question 16

When a cell is active, you can see the formula in the cell .

Question 17

A constant is a sign or symbol that indicates what calculation is to be performed.

Question 18

Which of the following arithmetic operators indicates multiplication?

A) * (asterisk)
B) / (forward slash)
C) % (percent sign)
D) ^ (caret)

Question 19

Excel uses a color-coded method to identify the ____ used in a formula.

A) syntax
B) arithmetic operators
C) arguments
D) cell references

Question 20

Every function requires an argument.

Question 21

When a formula contains more than one arithmetic operator, the ____________________ is the specific sequence used to calculate the value of the formula.

Question 22

A(n) ____________________ is a set of instructions used to perform calculations on values in a worksheet.

Question 23

Which function returns the smallest value in a set of values?

A) Average
B) Count Numbers
C) Max
D) Min

Question 24

FIGURE EX 3-1 In Figure EX 3-1 above, the formula in cell B11 contains a relative reference to ____.

A) column B
B) row 9
C) row 10
D) all of the above

Question 25

In the function =SUM(B8:B11), which is the argument?

A) =
B) SUM
C) B8:B11
D) none of the above

Question 26

Case EX 3-1 Armando is using Excel to create a budget for an upcoming business trip and needs to quickly copy data, formulas, and formatting in the worksheet. Armando can choose to copy only the formatting by choosing that option on the ____ button menu.

A) Fill Formatting
B) Copy Formatting
C) Auto Fill Options
D) Auto Fill Formatting

Question 27

Case EX 3-2 Bernadette has created a worksheet containing sales figures for the past year. She needs to extract information about the data that she can use in a presentation. If Bernadette wanted to find out which region had the largest number of sales, she would use which statistical function?

A) Average
B) Count Numbers
C) Max
D) Min

Question 28

Which of the following means the reference to a cell changes in relation to the location of the formula?

A) cell reference
B) relative reference
C) absolute reference
D) mixed reference

Question 29

The fill handle is a little ____ in the lower-right corner of the selected cell.

A) green triangle
B) red cross
C) black square
D) blue arrow

Question 30

To quickly switch between displaying values and formulas in a worksheet, use the keyboard shortcut ____.

A) Ctrl+d
B) Ctrl+`
C) F4
D) F11

Question 31

The OR function is in which function category?

A) Logical
B) Text
C) Date & Time
D) Statistical

Question 32

When you select a function in the Insert Function dialog box or from the Ribbon, Excel opens the ____ dialog box.

A) Function Syntax
B) Function Results
C) Function Arguments
D) Function Description

Question 33

FIGURE EX 3-1 In Figure EX 3-1 above, when the formula in cell B11 is copied to cell C13, ____.

A) the relative column references change and the absolute row references do not
B) the relative column references do not change and the absolute row references do
C) the absolute column references change and the relative row references do not
D) the absolute column references do not change and the relative row references do

Question 34

Case EX 3-2 Bernadette has created a worksheet containing sales figures for the past year. She needs to extract information about the data that she can use in a presentation. To total a range of cells for the month of January, Bernadette could use the Sum button on the ____ tab in the Editing group.

A) Home
B) Formulas
C) Data
D) Review

Question 35

You can enter a formula by pressing the Enter key or clicking the Enter button on the ____.

A) Formula tab on the Ribbon
B) taskbar
C) formula bar
D) all of the above

Question 36

Which error value could you correct by widening the column containing the cell?

A) #DIV/0!
B) #####
C) #NUM!
D) #VALUE!

Question 37

A function must follow a set of established rules, called ____.

A) order of operations
B) syntax
C) arguments
D) relative reference

Question 38

The Insert Function dialog box is displayed when you click the Insert Function button in the Function Library group on the ____ tab of the Ribbon.

A) Home
B) Insert
C) Formulas
D) View

Question 39

Case EX 3-1 Armando is using Excel to create a budget for an upcoming business trip and needs to quickly copy data, formulas, and formatting in the worksheet. To copy a formula across a row, Armando can drag the ____ of the cell containing the formula.

A) top border
B) fill handle
C) comparison operator
D) row header

Question 40

Which function returns the number of cells in a range that contains numbers?

A) PMT
B) DATE
C) SQRT
D) COUNT

Question 42

Excel indicates when a formula you have entered results in an error by displaying a(n) ____________________.

Question 43

____________________ is a feature that you can use to automatically fill in worksheet data in any direction.

Question 44

A(n) ____________________ is a permanent reference to a cell and does not change in relation to the location of the formula.

Question 45

What kinds of things should you be aware of when you move or copy a formula? How can you check your worksheet to see if any errors have occurred after moving or copying formulas? Does checking a worksheet for errors guarantee that it is error-free?