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

When you format a cell to display percentages,Excel assumes that whatever you enter into that cell in the future will be a percentage.Thus,if you enter the number .5,Excel translates the value as ____________________.

(Short Answer)

4.9/5

(41)

Question 21

Which of the following are financial functions?

(Multiple Choice)

4.8/5

(40)

Question 22

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

(Multiple Choice)

4.9/5

(31)

Question 23

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be applied to only one formula.

(Multiple Choice)

4.9/5

(30)

Question 24

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

(Short Answer)

4.8/5

(30)

Question 25

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.

(Multiple Choice)

4.8/5

(35)

Question 26

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

(Short Answer)

4.7/5

(39)

Question 27

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

(Multiple Choice)

4.8/5

(38)

Question 28

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.

(Multiple Choice)

4.9/5

(30)

Question 29

A name cannot be assigned to two or more nonadjacent ranges.

(True/False)

4.8/5

(29)

Question 30

MATCHING Identify the letter of the choice that best matches the phrase or definition. -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.

(Multiple Choice)

4.9/5

(38)

Question 31

You should ____________________ all other cells (non data entry)in a worksheet from input by the user of the worksheet.

(Short Answer)

4.9/5

(41)

Question 32

____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.

(Short Answer)

4.9/5

(40)

Question 33

The arguments in ____ in the ScreenTip for a function are optional.

(Multiple Choice)

4.9/5

(32)

Question 34

To prevent round-off errors,use the ____ function.

(Multiple Choice)

4.9/5

(38)

Question 35

Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. -Barret decides he wants to unprotect one of the protected cells so he can replace one of the formulas.What did Ruth do to cause an error message to appear when Barret tries to change the protection?

(Multiple Choice)

4.9/5

(34)

Question 36

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

(Multiple Choice)

4.8/5

(35)

Question 37

Names are ____ cell references.

(Multiple Choice)

4.8/5

(37)

Question 38

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

(Short Answer)

4.8/5

(33)

Question 39

To prevent sensitive data from being seen in a worksheet,you can hide the worksheet by clicking ____ on the shortcut menu.

(Multiple Choice)

4.8/5

(37)

Question 40

Showing 21 - 40 of 110

When you format a cell to display percentages,Excel assumes that whatever you enter into that cell in the future will be a percentage.Thus,if you enter the number .5,Excel translates the value as ____________________.

Which of the following are financial functions?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be applied to only one formula.

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

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.

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

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

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.

A name cannot be assigned to two or more nonadjacent ranges.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -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.

You should ____________________ all other cells (non data entry)in a worksheet from input by the user of the worksheet.

____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.

The arguments in ____ in the ScreenTip for a function are optional.

To prevent round-off errors,use the ____ function.

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

Names are ____ cell references.

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

To prevent sensitive data from being seen in a worksheet,you can hide the worksheet by clicking ____ on the shortcut menu.

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