Deck 12: Excel: Relational Databases and Queries

Question 1

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.

Answer 1

D

Question 2

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.

Answer 2

A

Question 3

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.

Answer 3

A

Question 4

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.

Question 5

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.

Question 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.

Question 7

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.

Question 8

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.

Question 9

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.

Question 10

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.

Question 11

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.

Question 12

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.

Question 13

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.

Question 14

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.

Question 15

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.

Question 16

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.

Question 17

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.

Question 18

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.

Question 19

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.

Question 20

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.

Question 21

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.

Question 22

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.

Question 23

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.

Question 24

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.

Question 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.

Question 26

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.

Question 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.

Question 28

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.

Question 29

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.

Question 30

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.

Question 31

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.

Question 32

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.

Question 33

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.

Question 34

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.

Question 35

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.

Question 36

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.

Question 37

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.

Question 38

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.

Question 39

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.

Question 40

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.

Question 41

The PMT function calculates The breakpoint of the lowest value for a specific category.

Question 42

The TODAY function displays what is due to be done today.

Question 43

The NOW function displays the current date and time.

Question 44

The logical test evaluates true or false.

Question 45

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

Question 46

The breakpoint is the lowest value for a specific category or series in a lookup table.

Question 47

The SUM function calculates the total of values contained in two or more cells.

Question 48

The RATE is the periodic interest rate, such as a monthly interest rate.

Question 49

A formula in Excel must begin with a Plus (+) sign.

Question 50

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

Question 51

The AVERAGE function CANNOT calculate the arithmetic mean or average of values in a range.

Question 52

The MAX function identifies the highest value in a range.

Question 53

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.

Question 54

Because the SUM function is a rarely used function it has no button on the Ribbon.

Question 55

A lookup table contains The available functions for this specific workbook.

Question 56

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

Question 57

A function is a predefined formula that performs a calculation.

Question 58

The IF function only evaluates a condition if the condition is true.

Question 59

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

Question 60

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

Question 61

The ________ function finds the lowest value in a list.

Question 62

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

Question 63

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

Question 64

An (A) ________ cell reference provides a permanent reference to a specific cell.

Question 65

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

Question 66

A relative cell ________ indicates a cell's relative location.

Question 67

________ references usually cause inaccurate results.

Question 68

An Excel ________ is a pre-defined computation that simplifies creating formulas.

Question 69

The ________ function displays the current date and time in a cell.

Question 70

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.

Question 71

The PV is the payment vector of the loan.

Question 72

To decrease typing time and ensure accuracy, use semi-________ to select cells.

Question 73

The ________ function displays the current date (not time) in a cell.

Question 74

A range name is a word or a string of characters that represent one or more cells.

Question 75

A Range name can contain up to 1000 characters but it must begin with a number.

Question 76

To insert a function by typing first type an (a) ________ sign.

Question 77

The NPER is the total number of payment periods.

Question 78

The ________ function finds the midpoint value or a list.

Question 79

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

Question 80

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