Question 1

Smart worksheet design starts with visualizing the results you need.

Accepted Answer

A) True 
 B)False

Question 2

Critical Thinking Questions Case 4-2 Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. Ruth has fully tested all of the formulas in her worksheet and the correct results appear. Ruth provides a copy of the worksheet file to Barret so he can use it for his business calculations. As a user, Barret can make changes only to certain cells. What did Ruth do to ensure the other cells cannot be altered by user Barret?

Accepted Answer

A)  unlock the user cells and then unprotect the worksheet 
B)  unlock the user cells and then protect the worksheet 
C)  she did not completely test the formula for that cell as she had thought 
D)  lock the user cells and then protect the worksheet

Question 3

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 4

A(n) index is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

Accepted Answer

A) True 
 B)False

Question 5

A cell name often is created from column and row titles.

Accepted Answer

A) True 
 B)False

Question 6

To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

Accepted Answer

A)  ALT 
B)  F3 
C)  CTRL 
D)  F10

Question 7

You should create worksheets as if you are going to use them only once.

Accepted Answer

A) True 
 B)False

Question 8

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

Accepted Answer

A) True 
 B)False

Question 9

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.

Accepted Answer

A)  blue square 
B)  red circle 
C)  green triangle 
D)  green diamond

Question 10

To hide an entire workbook on an unattended computer, click the Hide button on the ____.

Accepted Answer

A)  (HOME tab | View group) 
B)  (VIEW tab | Workbook Views group) 
C)  (VIEW tab | Window group) 
D)  (HOME tab | Display group)

Question 11

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

Accepted Answer

A) True 
 B)False

Question 12

What is the path to the What-If Analysis button?

Accepted Answer

A)  (DATA tab | Data Tools group) 
B)  (HOME tab | Analysis group) 
C)  (INSERT tab | What-If Tools group) 
D)  (INSERT tab | Conditions group)

Exam 5: Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Smart worksheet design starts with visualizing the results you need.

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

A(n) index is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

A cell name often is created from column and row titles.

To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

You should create worksheets as if you are going to use them only once.

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.

To hide an entire workbook on an unattended computer, click the Hide button on the ____.

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

What is the path to the What-If Analysis button?