Exam 5: Excel Lesson 3: Using Formulas and Functions

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

The OR function is in which function category?

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

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(n) ____________________ is a set of instructions used to perform calculations on values in a worksheet.

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

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

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

A mixed reference contains both relative and absolute cell references.

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

Which of the following arithmetic operators indicates multiplication?

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

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

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

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

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

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

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

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

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.