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