Excel 5

Which of the following symbols specifies an absolute reference? & % $ @

$

Which of the following symbols can you use to override the order of operations? * @ " " ( )

()

Which of following operators is used to multiply in Excel? * / ^ X

*

Which following operator is used to divide in Excel? / * ^ @

/

What is the answer to the following calculation: (4+6)*2-10/2. 5 3 15 -30

15

How many arguments does a typical IF statement use to evaluate conditions? 1 2 3 4

3

Which of the following operators is used to start a formula in Excel? * / = $

=

You are constructing an IF statement that evaluates whether cell C9 is greater than 150. Which logical operator would you use? = < > <>

>

Which of the following is the best example of a mixed cell reference? A2 $A$2 A2:B5 A$2

A$2

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? AVERAGE COUNT IF 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? Worksheet Mixed Relative Absolute

Absolute

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

Arithmetic operators

Describe the benefits of using a named range. _________________________

As a reference in a formula

The COUNTBLANK function counts the number of ____________________________cells in a range.

Blank

The ___________________________ function counts all the numeric values in a specified range.

Count

The ____________________________function counts all the nonblank entries in a range.

Counta

The COUNTBLANK function counts the following value types: Empty Cells Empty Text Strings Errors Numeric Constants

Empty cells, Empty text strings

Which of the following are not evaluated in the MAX or MIN functions? Cells with number values Empty cells Ranges with number values Text values in the specified range

Empty cells, Text values in the specified range

Which keyboard shortcut can you use to toggle relative, absolute, and mixed references? F1 F4 F6 F8

F4

Consider the following formula: =IF(C20>=25,C20*5,). What happens to a false result if you remove the last comma in the IF statement? 0 is displayed. Error is displayed. FALSE is displayed. C20*5 is displayed.

FALSE is displayed.

A cell that contains zero (0) is evaluated as a blank. True/False

False

The COUNT function will not count negative numbers when evaluating a range of values. True/False

False

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

Function

Describe what happens with the following IF statement; =IF(A10>100, "Great!", "Not good").

If A10 is greater than 100, then return the word "Great!", otherwise "Not good"

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

Insert Function

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

MAX

The COUNT function counts the following value types: Empty cells Numeric Constants Numeric Cell Ranges Numeric Cell References

Numeric constants, Numeric cell ranges, numeric cell references

PEMDAS is the acronym for _________________________.

Parenthesis, exponents, multiplication, division, addition, subtraction

A formula is used in an Excel workbook to ________________.

Perform mathematical operations such as add, subtract, multiply, or divide data.

Which function is used to add specified values? AVERAGE COUNT MAX SUM

SUM

Which of the following is a valid named range? A7 Sales_Data Sales Data Sales\Data

Sales_Data

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

Show Forumlas

The COUNT functions are in which of the Function Library categories? Date & Time Financial Math & Trig Statistical

Statistical

An IF function can contain additional calculations as arguments. True/False

True

Like a standard formula, a function begins with an equal sign (=). True/False

True

The formula =6*2/3 produces the same result as =6*(2/3). True/False

True

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

Worksheet

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

You can use the Name Box or the Define Name command in the Formulas tab