Question 1

The lookup value

Accepted Answer

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

The HLOOKUP function

Accepted Answer

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

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

Accepted Answer

equal or e

Question 4

The TODAY function

Accepted Answer

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

The column index number

Accepted Answer

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

The ________ function calculates the periodic payment for a loan with interest.

Accepted Answer

The answer of The ________ function calculates the periodic payment...

Question 7

A nested function

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 9

The logical test

Accepted Answer

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

The COUNT function

Accepted Answer

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

The SUM function

Accepted Answer

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

The breakpoint

Accepted Answer

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

An Argument (as it applies to Excel 2010)

Accepted Answer

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

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

Accepted Answer

The answer of An (A) ________ cell reference provides a...

Question 15

A range name

Accepted Answer

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

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

Accepted Answer

The answer of Because the ________ function is so commonly...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

A circular reference

Accepted Answer

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

A lookup table

Accepted Answer

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

The lookup value

The HLOOKUP function

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

The TODAY function

The column index number

The ________ function calculates the periodic payment for a loan with interest.

A nested function

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.

The logical test

The COUNT function

The SUM function

The breakpoint

An Argument (as it applies to Excel 2010)

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

A range name

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

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

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

A circular reference

A lookup table

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 lookup value

The HLOOKUP function

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

The TODAY function

The column index number

The ________ function calculates the periodic payment for a loan with interest.

A nested function

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.

The logical test

The COUNT function

The SUM function

The breakpoint

An Argument (as it applies to Excel 2010)

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

A range name

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

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

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

A circular reference

A lookup table

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