Question 1

You can use ________ names in formulas instead of cell references.

Accepted Answer

Range range RANGE

Question 2

Semi-selection or pointing

Accepted Answer

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

Question 3

An absolute cell reference

Accepted Answer

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

Question 4

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

Accepted Answer

The answer of To decrease typing time and ensure accuracy,...

Question 5

Syntax (as it applies to Excel 2010)

Accepted Answer

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

The logical test evaluates true or false.

Accepted Answer

A) True 
 B)False

Question 7

The NOW function displays the current date and time.

Accepted Answer

A) True 
 B)False

Question 8

The RATE

Accepted Answer

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

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

Accepted Answer

TODAY or t

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Formula AutoComplete

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The ________ is the periodic interest or a loan.

Accepted Answer

The answer of The ________ is the periodic interest or...

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of An Excel ________ is a pre-defined computation...

Question 20

The NPER is the total number of payment periods.

Accepted Answer

A) True 
 B)False

You can use ________ names in formulas instead of cell references.

Semi-selection or pointing

An absolute cell reference

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

Syntax (as it applies to Excel 2010)

The logical test evaluates true or false.

The NOW function displays the current date and time.

The RATE

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

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

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

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

Formula AutoComplete

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

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

The ________ is the periodic interest or a loan.

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.

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

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

The NPER is the total number of payment periods.

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

You can use ________ names in formulas instead of cell references.

Semi-selection or pointing

An absolute cell reference

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

Syntax (as it applies to Excel 2010)

The logical test evaluates true or false.

The NOW function displays the current date and time.

The RATE

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

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

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

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

Formula AutoComplete

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

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

The ________ is the periodic interest or a loan.

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.

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

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

The NPER is the total number of payment periods.

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