Question 1

Modified Multiple Choice Which of the following functions have these three arguments: rate, periods, payment?

Accepted Answer

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

Question 2

You cannot use column and row titles within formulas when you want to refer to the related data by name.

Accepted Answer

A) True 
 B)False

Question 3

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

Accepted Answer

A)  ALT 
B)  CTRL 
C)  TAB 
D)  SHIFT

Question 4

To use a name that consists of two or more words in a formula, you should replace any space with the ____________________ character.

Accepted Answer

The answer of To use a name that consists of...

Question 5

Names are ____ to the workbook.

Accepted Answer

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

Question 6

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Accepted Answer

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

Question 7

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

Accepted Answer

The answer of Excel lets you format ____________________ before you...

Question 8

Match between columns
                        Premises: A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.

Accepted Answer

The Answer of ROUND and global and Draft quality check is...

Question 9

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

Accepted Answer

A)  locked 
B)  indexed 
C)  unprotected 
D)  hybrid

Question 10

Excel is case sensitive with respect to names of cells.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: Showing only the parts of a worksheet that the user needs to see.

Accepted Answer

The Answer of formula checker and background formula checking and is...

Question 12

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

Accepted Answer

A)  repetitiveness 
B)  brevity 
C)  violations 
D)  consistency

Question 13

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

Accepted Answer

A)  password 
B)  authorized user 
C)  manager account 
D)  administrative account

Question 14

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

Accepted Answer

A)  (HOME tab | Alignment group) 
B)  (HOME tab | Editing group) 
C)  (HOME tab | Font group) 
D)  (HOME tab | Clipboard group)

Question 15

When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

Accepted Answer

A) True 
 B)False

Question 16

Modified Multiple Choice Which of the following are financial functions?

Accepted Answer

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

Question 17

An amortization schedule summarizes loan information over the life of the loan.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is the path to the Protect Sheet button?

Accepted Answer

A)  (VIEW tab | Protect Sheet group) 
B)  (HOME tab | Protection group) 
C)  (REVIEW tab | Changes group) 
D)  (VIEW tab | Protect group)

Question 19

You can start over with formatting a range by clicking the Cell Styles button (Home tab | Styles group) and tapping or clicking ____________________ in the Cell Styles gallery.

Accepted Answer

The answer of You can start over with formatting a...

Question 20

Modified Multiple Choice Which of the following are PMT function arguments?

Accepted Answer

A)  formula name 
B)  monthly interest rate 
C)  number of payments 
D)  loan amount

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

Modified Multiple Choice Which of the following functions have these three arguments: rate, periods, payment?

You cannot use column and row titles within formulas when you want to refer to the related data by name.

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

To use a name that consists of two or more words in a formula, you should replace any space with the ____________________ character.

Names are ____ to the workbook.

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

Identify the letter of the choice that best matches the phrase or definition.

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

Excel is case sensitive with respect to names of cells.

Identify the letter of the choice that best matches the phrase or definition.

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

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

When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

Modified Multiple Choice Which of the following are financial functions?

An amortization schedule summarizes loan information over the life of the loan.

Which of the following is the path to the Protect Sheet button?

You can start over with formatting a range by clicking the Cell Styles button (Home tab | Styles group) and tapping or clicking ____________________ in the Cell Styles gallery.

Modified Multiple Choice Which of the following are PMT function arguments?