1) An absolute cell reference is denoted by a(n) _____

a) Asterisk
b) Number sign
c) At sign
d) Dollar sign

2) When cell B2 containing the formula =A4*B6 is copied to cell C1, the formula in cell C1 is ____

= B3*C6

3) Instead of typing the $ symbol in a cell reference, you can press the ____ key

F11
F4
F2
F7

4) Which of the following is an alternative to using a space when naming a range?

Use an underscore
Use a hyphen
Use an equal sign
Use backslash

5) All arguments in a function are enclosed in a pair of _____

Brackets []
Braces {}
Parenthesis ()
Quotes “”

6) Optional arguments in a function are enclosed within _______

Brackets []
Braces {}
Parenthesis ()
Quotes “”

7) An example of a _______ is (C5 + D5)/100

Named Range
Text String
Function
Formula

8) An example of a ______ is SUM(A1:A10)

Text string
Formula
Function
Named Range

9) The inputs used by an Excel function to calculate a result are called _____

Dependent variables
Parameters
Arguments
Independent variables

10) The process of removing unwanted characters, rearranging data in a cell, or correcting erroneous data in text is called ________

Concatenating
Cleansing
Sanitizing
Purifying