# Quiz 2: Excel: Relational Databases and Queries

Computing

Q 1Q 1

Semi-selection or pointing
A) indicates a cells relative location from the cell containing the formula.
B) indicates a cell's specific location and the reference does not change when you copy the formula.
C) is the process of using the mouse to select cells while building a formula.
D) creates an Equals (=) sign.

Free

Multiple Choice

C

Q 2Q 2

A formula in Excel must begin with
A) a cell's specific location.
B) a cells relative location.
C) both an absolute and a relative cell reference.
D) an Equals (=) sign.

Free

Multiple Choice

D

Q 3Q 3

A relative cell reference
A) indicates a cell's specific location and the reference does not change when you copy the formula.
B) contains both an absolute and a relative cell reference.
C) indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula.
D) occurs when a formula directly or indirectly refers to the cell containing the formula.

Free

Multiple Choice

C

Q 4Q 4

An absolute cell reference
A) causes a potential error.
B) indicates a cell's specific location and the reference does not change when you copy the formula.
C) occurs when a formula directly or indirectly refers to the cell containing the formula.
D) contains both an absolute and a relative cell reference.

Free

Multiple Choice

Q 5Q 5

A mixed cell reference
A) occurs when a formula directly or indirectly refers to the cell containing the formula.
B) causes a potential error.
C) contains absolute or relative cell references, but not both.
D) contains both an absolute and a relative cell reference.

Free

Multiple Choice

Q 6Q 6

A circular reference
A) is a predefined formula that performs a calculation.
B) is a rule that governs the structure and components for functions.
C) occurs when a formula directly or indirectly refers to the cell containing the formula.
D) is an input such as a cell reference or a value needed to complete a function.

Free

Multiple Choice

Q 7Q 7

Excel displays a green arrow in the top left corner of a cell if it detects a
A) cell reference or a value.
B) rule that governs components of functions.
C) potential error.
D) predefined formula that performs a calculation.

Free

Multiple Choice

Q 8Q 8

A function is a
A) predefined formula that performs a calculation.
B) cell reference or a value.
C) list of values and defined names as you enter a spreadsheet.
D) set of rules that govern the structure and components for a formula.

Free

Multiple Choice

Q 9Q 9

Syntax (as it applies to Excel 2010)
A) displays a list of functions and defined names as you enter a function.
B) is a small pop-up description that displays the arguments for a function as you enter it.
C) is a set of rules that govern the structure and components for a function.
D) is an input such as a cell reference or a value needed to complete a function.

Free

Multiple Choice

Q 10Q 10

An Argument (as it applies to Excel 2010)
A) calculates the total of values contained in two or more cells.
B) displays a list of functions and defined names as you enter a function.
C) is an input such as a cell reference or a value needed to complete a function.
D) is a small pop-up description that displays the results of the cell.

Free

Multiple Choice

Q 11Q 11

Formula AutoComplete
A) results in formulas such as =B4+C4.
B) calculates the total of values contained in two or more cells.
C) is a small pop-up description that displays the arguments for a function as you enter it.
D) displays a list of functions and defined names as you enter a function.

Free

Multiple Choice

Q 12Q 12

A function Screen Tip
A) automatically inserts functions such as SUM (B4:C4).
B) calculates the total of values contained in two or more cells.
C) automatically inserts formulas such as =B4+C4.
D) is a small pop-up description that displays the arguments for a function as you enter it.

Free

Multiple Choice

Q 13Q 13

The SUM function
A) identifies the midpoint value in a set of values.
B) calculates the total of values contained in two or more cells.
C) calculates the arithmetic mean or average of values in a range.
D) displays the lowest value in a range.

Free

Multiple Choice

Q 14Q 14

For a basic mathematical expression it is best to use
A) the arithmetic mean or average of values.
B) formulas such as =B4+C4.
C) functions such as SUM (B4:C4).
D) the midpoint value in a set of values.

Free

Multiple Choice

Q 15Q 15

The AVERAGE function
A) calculates the arithmetic mean of values in a range.
B) identifies the midpoint value in a set of values.
C) identifies the highest value in a range.
D) displays the lowest value in a range.

Free

Multiple Choice

Q 16Q 16

The MEDIAN function
A) displays the lowest value in a range.
B) identifies the midpoint value in a set of values.
C) identifies the highest value in a range.
D) tallies the number of cells in a range that contain values.

Free

Multiple Choice

Q 17Q 17

The MIN function
A) identifies the highest value in a range.
B) tallies the number of blank cells in a range.
C) displays the lowest value in a range.
D) tallies the number of cells in a range that contain values.

Free

Multiple Choice

Q 18Q 18

The MAX function
A) tallies the number of cells in a range that are not empty.
B) identifies the highest value in a range.
C) tallies the number of blank cells in a range.
D) tallies the number of cells in a range that contain values.

Free

Multiple Choice

Q 19Q 19

The COUNT function
A) tallies the number of cells in a range that are not empty.
B) tallies the number of blank cells in a range.
C) displays the current date.
D) tallies the number of cells in a range that contain values.

Free

Multiple Choice

Q 20Q 20

The COUNTBLANK function
A) tallies the number of blank cells in a range.
B) displays the current date and time.
C) displays the current date.
D) tallies the number of cells in a range that are not empty.

Free

Multiple Choice

Q 21Q 21

The COUNTA function
A) evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
B) evaluates true or false.
C) tallies the number of cells in a range that are not empty.
D) displays the current date.

Free

Multiple Choice

Q 22Q 22

The TODAY function
A) evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
B) displays the current date and time.
C) displays the current date.
D) evaluates true or false.

Free

Multiple Choice

Q 23Q 23

The NOW function
A) contains another function embedded inside one or more of its arguments.
B) evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
C) evaluates true or false.
D) displays the current date and time.

Free

Multiple Choice

Q 24Q 24

The IF function
A) contains data for the basis of the lookup and data to be retrieved.
B) looks up a value and returns a related result from the lookup table.
C) evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
D) contains another function embedded inside one or more of its arguments.

Free

Multiple Choice

Q 25Q 25

The logical test
A) is the lowest value for a specific category or series in a lookup table.
B) evaluates true or false.
C) contains another function embedded inside one or more of its arguments.
D) contains data for the basis of the lookup and data to be retrieved.

Free

Multiple Choice

Q 26Q 26

A nested function
A) contains data for the basis of the lookup and data to be retrieved.
B) is the lowest value for a specific category or series in a lookup table.
C) looks up a value and returns a related result from the lookup table.
D) contains another function embedded inside one or more of its arguments.

Free

Multiple Choice

Q 27Q 27

A lookup table
A) looks up a value and returns a related result.
B) contains data for the basis of the lookup and the data to be retrieved.
C) is the lowest value for a specific category or series.
D) is a reference to a cell containing a value to look up.

Free

Multiple Choice

Q 28Q 28

The breakpoint
A) looks up a value and returns a related result from the lookup table.
B) is a range containing a lookup table.
C) is the lowest value for a specific category or series in a lookup table.
D) is a reference to a cell containing a value to look up.

Free

Multiple Choice

Q 29Q 29

The VLOOKUP function.
A) is the argument in a function that describes to which column to return a value.
B) is a range containing a lookup table.
C) is a reference to a cell containing a value to look up.
D) looks up a value and returns a related result from the lookup table.

Free

Multiple Choice

Q 30Q 30

The lookup value
A) is the argument in a function that identifies which lookup table column from which to return a value.
B) looks in a horizontal table where the first row contains the values.
C) is a reference to a cell containing a value to look up.
D) is a range containing a lookup table.

Free

Multiple Choice

Q 31Q 31

The Table Array
A) is the argument in a VLOOKUP function that identifies from which column to return a value.
B) looks up a value in a horizontal table where the first row contains the values to compare with the lookup value.
C) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
D) is a range containing a lookup table.

Free

Multiple Choice

Q 32Q 32

The column index number
A) is the periodic interest rate, such as a monthly interest rate.
B) looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value.
C) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
D) is the argument in a VLOOKUP function that identifies from which column to return a value.

Free

Multiple Choice

Q 33Q 33

The HLOOKUP function
A) is the periodic interest rate, such as a monthly interest rate.
B) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
C) looks up a value in a lookup table where the first column contains the values to compare with the lookup value.
D) looks up a value in a lookup table where the first row contains the values to compare with the lookup value.

Free

Multiple Choice

Q 34Q 34

The PMT function
A) is the periodic interest rate, such as a monthly interest rate.
B) is the total number of payment periods.
C) is the present value of a loan.
D) calculates the periodic payment for a loan with a fixed interest rate and fixed term.

Free

Multiple Choice

Q 35Q 35

The RATE
A) is the periodic interest rate, such as a monthly interest rate.
B) is the total number of payment periods.
C) is a word or a string of characters that represent one or more cells.
D) the present value of the loan.

Free

Multiple Choice

Q 36Q 36

The NPER
A) is the total number of payment periods.
B) is a word or a string of characters that represent one or more cells.
C) the present value of the loan.
D) a set of range names.

Free

Multiple Choice

Q 37Q 37

The PV is
A) a set of range names.
B) is a word or a string of characters that represent one or more cells.
C) the present value of the loan.
D) why you do not have to make the cell reference absolute in the formula.

Free

Multiple Choice

Q 38Q 38

A range name
A) Indicates a cell's specific location and the reference does not change when you copy the formula.
B) is a word or a string of characters that represent one or more cells.
C) indicates a cells relative location from the cell containing the formula.
D) creates an Equals (=) sign.

Free

Multiple Choice

Q 39Q 39

To simplify entering ranges in formulas you can use
A) range names.
B) a cells relative location.
C) both an absolute and a relative cell reference.
D) a cell's specific location.

Free

Multiple Choice

Q 40Q 40

One benefit of using range names in formulas is
A) it directly or indirectly refers to the cell containing the formula.
B) it contains both an absolute and a relative cell reference.
C) it identifies the present value of the loan.
D) if you copy the formula, you do not have to make the cell reference absolute.

Free

Multiple Choice

Q 41Q 41

Semi-selection or pointing is the process of using the mouse to select cells while building a formula.

Free

True False

Free

True False

Q 43Q 43

A relative cell reference indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula.

Free

True False

Q 44Q 44

An absolute cell reference indicates a cell's specific location and the reference changes when you copy the formula.

Free

True False

Q 45Q 45

A circular reference occurs when a formula directly or indirectly refers to the cell containing the formula.

Free

True False

Q 46Q 46

Excel displays a green arrow in the top left corner of a cell if it detects no possible error.

Free

True False

Free

True False

Q 48Q 48

An Argument (as it applies to Excel 2010) is an operator such as an equals sign or a plus sign needed to complete a function.

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Free

True False

Q 65Q 65

One benefit of using range names is that if you copy the formula, you do not have to make the cell reference absolute in the formula.

Free

True False

Free

Short Answer

Q 67Q 67

Semi-selection is often called ________ because you use the mouse to select cells as you build the formula.

Free

Short Answer

Free

Short Answer

Free

Short Answer

Q 70Q 70

If a formula contains a reference to the cell containing the formula a ________ reference exists.

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Q 74Q 74

The ________ function totals the values in two or more cells and displays the result in the cell containing the function.

Free

Short Answer

Q 75Q 75

Because the ________ function is so commonly used, it is available on the Home tab and the Formulas tab under AutoSum.

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Q 80Q 80

The ________ returns one value if a condition is true and another value if a condition is false.

Free

Short Answer

Free

Short Answer

Q 82Q 82

The V________ function looks up a value in a table and returns a result from a specified column in the table.

Free

Short Answer

Free

Short Answer

Q 84Q 84

The H________ function looks up a value in a horizontal table and returns a result from a row in the table.

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer

Free

Short Answer