Excel 5:Using Formulas & Functions

Which of the symbols specifies an absolute reference?

$

Which of the following characters can be used to override the order of operations?

()

Which of the following operations is used to multiply in Excel

*

Examples of arithmetic operators include

+, -, *, /

Which of the following operations is used to divide in Excel

/

What is the answer to the following calculation?

15

How many arguments does a typical IF statement use to evaluate conditions?

3

Which of the following operations 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?

>

Absolute reference

A cell reference that does not change when a formula is copied to a new location.

Which of the folowing is the best example of a mixed cell reference?

A$2

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function do you use?

AVERAGE

Review the following formula: =$C$2*A7. This formula uses which of the following reference types?

Absolute

Which function counts all the nonblank entries in a range?

COUNTA

Which function counts the number of blank cells in a range?

COUNTBLANK

Which keyboard shortcut toggles through the types of reference (relative, absolute, & mixed) options?

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?

FALSE is displayed.

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

MAX

PEMDAS

Order of operations

Which function is used to add specified values?

SUM

Which of the following is a valid name range?

Sales_Data

The COUNT functions are in which of the Function Library categories?

Statistical

Insert Function

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

1An IF function can contain additional calculations as arguments. True or False?

True

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

Worksheet

Show Formulas

displays the functions and formulas used in each cell of a worksheet instead of the formula or function results