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

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n) ____________________ status.

(Short Answer)

4.8/5

(40)

Question 21

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

(Multiple Choice)

4.9/5

(41)

Question 22

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

(True/False)

4.8/5

(39)

Question 23

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

(Multiple Choice)

4.8/5

(38)

Question 24

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

(Multiple Choice)

4.8/5

(41)

Question 25

Once you set a print area, Excel will santinue to print the specified range, rather than the entire worksheet.

(True/False)

4.9/5

(35)

Question 26

You should protect cells only after the ____________________ has been tested fully and the sarrect results appear.

(Short Answer)

4.7/5

(40)

Question 27

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

(True/False)

4.9/5

(36)

Question 28

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

(Short Answer)

4.9/5

(25)

Question 29

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.

(True/False)

4.8/5

(39)

Question 30

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

(Multiple Choice)

4.8/5

(42)

Question 31

Which of the following are financial functions?

(Multiple Choice)

4.9/5

(33)

Question 32

You can name a range by ____.

(Multiple Choice)

4.8/5

(33)

Question 33

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

(Multiple Choice)

4.8/5

(32)

Question 34

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

(Multiple Choice)

4.8/5

(45)

Question 35

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

(Multiple Choice)

4.8/5

(32)

Question 36

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

(Short Answer)

4.8/5

(25)

Question 37

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.

(True/False)

4.8/5

(31)

Question 38

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

(Short Answer)

4.8/5

(21)

Question 39

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.8/5

(30)

Question 40

Showing 21 - 40 of 103

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

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n) ____________________ status.

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

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

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

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

Once you set a print area, Excel will santinue to print the specified range, rather than the entire worksheet.

You should protect cells only after the ____________________ has been tested fully and the sarrect results appear.

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

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

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.

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

Which of the following are financial functions?

You can name a range by ____.

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

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

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

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

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.

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

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 ____________________.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

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

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters