Exam 2 Tutorial 3

Question 1

Use the _____ symbol to make a cell reference absolute.

Accepted Answer

c. dollar $

Answer

a. asterisk *

Answer

b. number #

Answer

d. equal sign

Question 2

True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new
location.

Answer

true

Question 3

True/False: Functions are organized in the Function Library group.

Answer

true

Question 4

True/False: To add a collection of numbers, use the COUNT function.

Answer

true

Question 5

To let Excel know you want to enter a formula, after clicking in a cell press the
 [blank_start]Equal sign =[blank_end] key.

Accepted Answer

Equal sign =

Question 6

True/False: An error indicator appears in the upper-left corner of the cell with the error value.

Answer

true

Question 7

True/False: The #NUM! error value means that a cell reference used in a formula or function is no
longer valid.

Answer

true

Question 8

True/False: AutoFill copies content but not formats from a cell or range into an adjacent cell or range.

Answer

true

Question 9

True/False: The small black square in the lower-right corner of a selected cell or range is called the
AutoFill button.

Answer

true

Question 10

If you don’t want the cell reference to change when you copy the formula use the
[blank_start]absolute[blank_end] reference.

Accepted Answer

absolute

Question 11

B$4 is an example of a(n)  [blank_start]mixed[blank_end]  reference.

Accepted Answer

mixed

Question 12

What symbol appears at the beginning of a function? An [blank_start]equal sign[blank_end]

Accepted Answer

equal sign

Question 13

A(n) [blank_start]comparison operator[blank_end]  is a symbol that indicates the relationship between two values.

Accepted Answer

comparison operator

Question 14

True/False: The TODAY function doesn’t have any arguments.

Answer

true

Question 15

True/False: Like the COUNT function, many of Excel’s statistical functions ignore cells that are blank
or contain text.

Answer

true

Question 16

True/False: If you leave a cell blank, the COUNTA function will include it.

Answer

true

Question 17

True/False: The values returned by the TODAY and NOW functions are updated automatically whenever
you reopen the workbook or enter a new calculation.

Answer

true

Question 18

To retrieve the return value from a vertical lookup table, you use the [blank_start]VLOOKUP[blank_end] function.

Accepted Answer

VLOOKUP

Question 19

If the VLOOKUP function cannot find the lookup value, the [blank_start]#N/A[blank_end] error value is displayed in the
cell.

Accepted Answer

#N/A

Preguntas del test (19)