Excel Module 5 Review

Which of the following symbols specifies an absolute reference? Select the correct option. % & $ @

$

What operator is used to multiply in Excel?

*

What is the operator used to divide in Excel?

/

What is the answer to the following calculation: (4+6)*2-10/2

15

You want to add a range of cells and then divide by the number of cell entries. Which function can help you with this task? Select the correct option. AVERAGE COUNT IF MAX

AVERAGE

You want to add a range of cells and then divide by the number of cell entries. Which function can help you with this task? Select the correct option. e. AVERAGE f. COUNT g. IF h. MAX

AVERAGE

If you do not want a cell reference to change when you copy or move it, you need to make a(n) _________________________cell reference in a formula.

Absolute

Review the following formula: =$C$2*A7. This formula uses which of the following reference types? Select the correct option. Absolute Relative Mixed Worksheet

Absolute

Which of the following operators is used to start a formula in Excel? A,) * B.) / C,) = D,) $

C,) =

Which of the following symbols can you use to override the order of operations? A.) " " B.)@ C.) ( ) D.) *

C.) ( )

The ____________________________ command helps you search and select a function to be used in a worksheet.

Ctrl + G

Which of the following are not evaluated in the MAX or MIN functions? Select all that apply. Cells with number values Ranges with number values Empty cells

Empty Cells

Which keyboard shortcut can you use to toggle relative, absolute, and mixed references? Select the correct option. F1 F4 F6 F8

F4

Describe two methods you can use to create a named range. _________________________

Formulas --> define name Name Box

You need to determine the largest value in a range of numbers. Which function should you use? Select the correct option. MIN SUM COUNT MAX

MAX

You need to determine the largest value in a range of numbers. Which function should you use? Select the correct option. m. MIN n. SUM o. COUNT p. MAX

MAX

The +, -, *, and / are all examples of _______________.

Operators

PEMDAS is the acronym for _______________

Order of Operations (Parenthesis, Exponents, Multiplication, Division, Addition, Subtraction)

Which function is used to add specified values? Select the correct option. AVERAGE SUM COUNT MAX

SUM

Which function is used to add specified values? Select the correct option. AVERAGE SUM COUNT MAX

SUM

Which of the following is a valid named range? Select the correct option. A7 Sales_Data Sales Data Sales\Data

Sales_Data

To display formulas in the worksheet, you can select the _______________ command in the ribbon.

Show Formulas

Like a standard formula, a function begins with an equal sign (=). True or False? Select the correct option. True False

True

Like a standard formula, a function begins with an equal sign (=). True or False? Select the correct option. True False

True

=Sales!C10+A7. This formula uses which of the following reference types? Select the correct option. Absolute Relative Named Worksheet

Worksheet

Describe the benefits of using a named range. _________________________

You can use the name instead of cell references

Which of the following is the best example of a mixed cell reference? Select the correct option. a. A2 b. $A$2 c. A2:B5 d. A$2

d. A$2

You need to determine the largest value in a range of numbers. Which function should you use? Select the correct option. aa. MIN bb. SUM cc. COUNT dd. MAX

dd. MAX

A _________________ is a predefined formula used for specific purposes and calculations.

function

Which of the following are not evaluated in the MAX or MIN functions? Select all that apply. i. Cells with number values j. Ranges with number values k. Empty cells l. Text values in the specified range

k. Empty cells l. Text values in the specified range

A formula is used in an Excel workbook to.

operate on values in a range of cells or a cell.

Like a standard formula, a function begins with an equal sign (=). True or False? Select the correct option. q. True r. False

q. True

You want to add a range of cells and then divide by the number of cell entries. Which function can help you with this task? Select the correct option. s. AVERAGE t. COUNT u. IF v. MAX

s. AVERAGE

Which of the following are not evaluated in the MAX or MIN functions? Select all that apply. w. Cells with number values x. Ranges with number values y. Empty cells z. Text values in the specified range

y. Empty cells z. Text values in the specified range