Question 1

The ________ is the number of payments over the life of a loan.

Accepted Answer

The answer of The ________ is the number of payments...

Question 2

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

Accepted Answer

LOOKUP or

Question 3

A function Screen Tip

Accepted Answer

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

The MEDIAN function

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 6

The Table Array

Accepted Answer

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

The NOW function

Accepted Answer

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

The VLOOKUP function.

Accepted Answer

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

A function is a

Accepted Answer

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

Question 10

One benefit of using range names in formulas is

Accepted Answer

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

The ________ is the number of payments over the life of a loan.

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

A function Screen Tip

The MEDIAN function

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

The Table Array

The NOW function

The VLOOKUP function.

A function is a

One benefit of using range names in formulas is

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 12: Excel: Relational Databases and Queries

The ________ is the number of payments over the life of a loan.

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

A function Screen Tip

The MEDIAN function

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

The Table Array

The NOW function

The VLOOKUP function.

A function is a

One benefit of using range names in formulas is

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters