Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Fixes round-off errors.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 2

When building a worksheet for novice users,you should ____ the cells in the worksheet that you do not want changed,such as cells that contain text or formulas.

Accepted Answer

A)  hide 
B)  protect 
C)  code 
D)  delete 
A)  hide 
B)  protect 
C)  code 
D)  delete

Question 3

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words._________________________

Accepted Answer

A) True 
 B)False

Question 4

Discuss the options for when you can apply formatting to cells.

Accepted Answer

Excel lets you format (1)before you ente

Question 5

Which of the following is the path to the Borders button?

Accepted Answer

Question 6

Which of the following is the maximum number of active data tables per worksheet?

Accepted Answer

A)  5 
B)  20 
C)  50 
D)  As many as you want 
A)  5 
B)  20 
C)  50 
D)  As many as you want

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Can be used to determine the monthly payment for a loan.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 8

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

Accepted Answer

A) True 
 B)False

Question 9

The ____ function returns the present value of an annuity.

Accepted Answer

A)  FV 
B)  PMT 
C)  PV 
D)  VDB 
A)  FV 
B)  PMT 
C)  PV 
D)  VDB

Question 10

-____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.

Accepted Answer

The answer of  
-____________________ like the kind shown in...

Question 11

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

Accepted Answer

two double

Question 12

____ ensures that users do not change values inadvertently that are critical to the worksheet.

Accepted Answer

A)  Cell protection 
B)  Range Finder 
C)  The formula checker 
D)  A data table 
A)  Cell protection 
B)  Range Finder 
C)  The formula checker 
D)  A data table

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Cannot be used to begin a cell or range name.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 14

Excel is case sensitive with respect to names of cells.

Accepted Answer

A) True 
 B)False

Question 15

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

Accepted Answer

A)  General 
B)  Formulas 
C)  Proofing 
D)  Advanced 
A)  General 
B)  Formulas 
C)  Proofing 
D)  Advanced

Question 16

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is the path to the Fill button?

Accepted Answer

Question 18

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

Accepted Answer

A)  Page 
B)  Sheet 
C)  Margins 
D)  Header / Footer 
A)  Page 
B)  Sheet 
C)  Margins 
D)  Header / Footer

Question 19

Names are ____ to the workbook.

Accepted Answer

A)  national 
B)  international 
C)  global 
D)  inclusive 
A)  national 
B)  international 
C)  global 
D)  inclusive

Question 20

A cell ____ often is created from column or row titles.

Accepted Answer

A)  function 
B)  name 
C)  formula 
D)  data table 
A)  function 
B)  name 
C)  formula 
D)  data table

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fixes round-off errors.

When building a worksheet for novice users,you should ____ the cells in the worksheet that you do not want changed,such as cells that contain text or formulas.

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words._________________________

Discuss the options for when you can apply formatting to cells.

Which of the following is the path to the Borders button?

Which of the following is the maximum number of active data tables per worksheet?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be used to determine the monthly payment for a loan.

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

The ____ function returns the present value of an annuity.

-____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

____ ensures that users do not change values inadvertently that are critical to the worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used to begin a cell or range name.

Excel is case sensitive with respect to names of cells.

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

Which of the following is the path to the Fill button?

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

Names are ____ to the workbook.

A cell ____ often is created from column or row titles.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 4: Financial Functions,Data Tables,and Amortization Schedules

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fixes round-off errors.

When building a worksheet for novice users,you should ____ the cells in the worksheet that you do not want changed,such as cells that contain text or formulas.

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words._________________________

Discuss the options for when you can apply formatting to cells.

Which of the following is the path to the Borders button?

Which of the following is the maximum number of active data tables per worksheet?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be used to determine the monthly payment for a loan.

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

The ____ function returns the present value of an annuity.

-____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

____ ensures that users do not change values inadvertently that are critical to the worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used to begin a cell or range name.

Excel is case sensitive with respect to names of cells.

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

Which of the following is the path to the Fill button?

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

Names are ____ to the workbook.

A cell ____ often is created from column or row titles.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters