Question 1

The PV is the payment vector of the loan.

Accepted Answer

A) True 
 B)False

Question 2

The ________ test formula is one that tests for true or false.

Accepted Answer

The answer of The ________ test formula is one that...

Question 3

The ________ is the Present Value of a loan or in other words; how much was borrowed.

Accepted Answer

The answer of The ________ is the Present Value of...

Question 4

The ________ function finds the lowest value in a list.

Accepted Answer

The answer of The ________ function finds the lowest value...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

To simplify entering ranges in formulas you can use

Accepted Answer

A)  range names. 
B)  a cells relative location. 
C)  both an absolute and a relative cell reference. 
D)  a cell's specific location. 
A)  range names. 
B)  a cells relative location. 
C)  both an absolute and a relative cell reference. 
D)  a cell's specific location.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The PV is

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

________ references usually cause inaccurate results.

Accepted Answer

The answer of ________ references usually cause inaccurate results....

Question 13

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

Accepted Answer

The answer of The ________ function totals the values in...

Question 14

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

Accepted Answer

LOOKUP or

Question 15

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

Accepted Answer

The answer of The ________ function displays the current date...

Question 16

The IF function

Accepted Answer

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

The ________ function finds the midpoint value or a list.

Accepted Answer

MEDIAN or

Question 18

Excel displays a green arrow in the top left corner of a cell if it detects a

Accepted Answer

A)  cell reference or a value. 
B)  rule that governs components of functions. 
C)  potential error. 
D)  predefined formula that performs a calculation. 
A)  cell reference or a value. 
B)  rule that governs components of functions. 
C)  potential error. 
D)  predefined formula that performs a calculation.

Question 19

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

Accepted Answer

The answer of If a formula contains a reference to...

Question 20

A mixed cell reference

Accepted Answer

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

The PV is the payment vector of the loan.

The ________ test formula is one that tests for true or false.

The ________ is the Present Value of a loan or in other words; how much was borrowed.

The ________ function finds the lowest value in a list.

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

To simplify entering ranges in formulas you can use

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

The PV is

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

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

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

________ references usually cause inaccurate results.

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

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

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

The IF function

The ________ function finds the midpoint value or a list.

Excel displays a green arrow in the top left corner of a cell if it detects a

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

A mixed cell reference

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 PV is the payment vector of the loan.

The ________ test formula is one that tests for true or false.

The ________ is the Present Value of a loan or in other words; how much was borrowed.

The ________ function finds the lowest value in a list.

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

To simplify entering ranges in formulas you can use

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

The PV is

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

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

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

________ references usually cause inaccurate results.

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

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

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

The IF function

The ________ function finds the midpoint value or a list.

Excel displays a green arrow in the top left corner of a cell if it detects a

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

A mixed cell reference

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