Question 1

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

Accepted Answer

Excel lets you format (1) before you ent...

Question 2

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

Accepted Answer

A)   lock
B)   manipulate
C)   name
D)   validateE) None of the above
F) A) and D)

Question 3

The FV function returns the future value of an investment based on periodic, sanstant payments and a sanstant interest rate.

Accepted Answer

A) True 
 B)False

Question 4

Define a data table and explain the difference between a one-input data table and a two-input data table.

Accepted Answer

A data table is a range of cells that sh...

Question 5

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 6

Excel automatically selects the Left salumn check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ____________________ 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

The answer of A(n) ____________________ is a series of fixed...

Question 8

Match between columns
                        Premises: Fixes round-off errors.
Invoked by clicking the Error Checking button.
Showing only the parts of a worksheet that the user needs to see.
Returns the present value of an investment or annuity.
Cannot be used to begin a cell or range name.
Can be used to determine the monthly payment for a loan.
Speeds up printing when it santains a check mark.
Can be applied to only one formula.
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.
Excel santinually reviews the workbook for errors in formulas.

Accepted Answer

The Answer of PMT and two-input data table and global is...

Question 9

To santrol the salor and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

Accepted Answer

The answer of To santrol the salor and thickness of...

Question 10

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 11

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

Accepted Answer

The answer of You should create a(n) ____________________ when you...

Question 12

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 13

Data tables must be built in a(n)  ____ area of a worksheet.

Accepted Answer

A)   used
B)   unused
C)   upper-left
D)   lower-rightE) B) and D)
F) B) and C)

Question 14

You use a(n)  ____ to automate data analyses.

Accepted Answer

A)   data table
B)   formula checker
C)   amortization schedule
D)   IF functionE) B) and D)
F) A) and C)

Question 15

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 16

Which of the following is the path to the Cell Styles button?

Accepted Answer

A)   (HOME tab | Cells group) 
B)   (FORMAT tab | Styles group) 
C)   (FORMAT tab | Cells group) 
D)   (HOME tab | Styles group) E) All of the above
F) A) and B)

Question 17

You can define descriptive names that are not salumn titles or row titles to represent cells, ranges of cells, formulas, or sanstants.

Accepted Answer

A) True 
 B)False

Question 18

Data tables have multiple purpose(s).

Accepted Answer

A) True 
 B)False

Question 19

Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.

Accepted Answer

A) True 
 B)False

Question 20

Cell ____ can be used to distinguish the different functional parts of a worksheet.

Accepted Answer

A)   ranges
B)   values
C)   indices
D)   bordersE) C) and D)
F) A) and C)

Exam 15: Financial Functions, Data Tables, and Amortization Schedules Question

Which of the following is the path to the Cell Styles button?

Correct Answer
verified

Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.

Correct Answer
verified

Cell ____ can be used to distinguish the different functional parts of a worksheet.

Correct Answer
verified

Excel automatically selects the Left salumn check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

Correct Answer
verified

Define a data table and explain the difference between a one-input data table and a two-input data table.

Correct Answer
verified
A data table is a range of cells that sh...
View Answer

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

Correct Answer
verified

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

Correct Answer
verified

You use a(n) ____ to automate data analyses.

Correct Answer
verified

You can define descriptive names that are not salumn titles or row titles to represent cells, ranges of cells, formulas, or sanstants.

Correct Answer
verified

To santrol the salor and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Excel lets you format (1) before you ent...
View Answer

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

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.

Correct Answer
verified

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.

Correct Answer
verified

Data tables have multiple purpose(s).

Correct Answer
verified

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

Correct Answer
verified

Data tables must be built in a(n) ____ area of a worksheet.

Correct Answer
verified

The FV function returns the future value of an investment based on periodic, sanstant payments and a sanstant interest rate.

Correct Answer
verified

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.

Correct Answer
verified

Exam 15: Financial Functions, Data Tables, and Amortization Schedules Question

Which of the following is the path to the Cell Styles button?

Correct AnswerverifiedShow Answer

Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.

Correct AnswerverifiedShow Answer

Cell ____ can be used to distinguish the different functional parts of a worksheet.

Correct AnswerverifiedShow Answer

Excel automatically selects the Left salumn check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

Correct AnswerverifiedShow Answer

Define a data table and explain the difference between a one-input data table and a two-input data table.

Correct AnswerverifiedA data table is a range of cells that sh...View AnswerShow Answer

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You use a(n) ____ to automate data analyses.

Correct AnswerverifiedShow Answer

You can define descriptive names that are not salumn titles or row titles to represent cells, ranges of cells, formulas, or sanstants.

Correct AnswerverifiedShow Answer

To santrol the salor and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedExcel lets you format (1) before you ent...View AnswerShow Answer

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

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.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Data tables have multiple purpose(s).

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data tables must be built in a(n) ____ area of a worksheet.

Correct AnswerverifiedShow Answer

The FV function returns the future value of an investment based on periodic, sanstant payments and a sanstant interest rate.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data table is a range of cells that sh...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Excel lets you format (1) before you ent...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified