Chapter 2

Question 1

A mixed cell reference:

Answer 1

contains both an absolute and a relative cell reference.

Question 2

Syntax:

Answer 2

is a set of rules that govern the structure and components for a function.

Question 3

The IF function:

Answer 3

evaluates a condition and returns one value if the condition is true, a different if false.

Question 4

What is a lookup table used for?

Answer 4

It contains data for the basis of a lookup and the data to be retrieved.

Question 5

What is the median of the following numbers?

13,18,13,14,13,16,14, 21,13

Answer 5

14

Question 6

The average and median values in the following dataaset are the same.
13,18,13,14,13,16,14, 21,13

Answer 6

False, the median is 14 and the average is 15

Question 7

Gross pay is calculated by subtracting taxes from the net pay.
-true or false

Answer 7

false

Question 8

Monthly private mortgage insurance (PMI) refers to an additional monthly payment a customer makes to a bank when a customer can not afford a certain percentage of down payment determined by a bank’s business model.
-true or false

Answer 8

true

Question 9

Formula AutoComplete:

Answer 9

displays a list of functions and defined names as you enter a function

Question 10

The Lookup Value:

Answer 10

is a reference to a cell containing a value to look up