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

Bill has a bicycle repair shop in his basement. He would like a larger workshop so he investigates taking out a loan to sanvert his garage to a workshop. He uses Excel to create an amortization schedule. Bill would like to borrow $50,000 and pay it off in 10 years. What samponents will he need to identify for a loan amortization schedule created on an Excel worksheet?

(Multiple Choice)

4.9/5

(33)

Question 81

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

(Multiple Choice)

4.8/5

(29)

Question 82

In the acsampanying figure, the Print area box accepts a name or a ____ to print.

(Multiple Choice)

4.8/5

(36)

Question 83

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

(43)

Question 84

Names are ____ cell references.

(Multiple Choice)

4.9/5

(33)

Question 85

The PMT function has two arguments: rate and payment.

(True/False)

5.0/5

(30)

Question 86

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

(Multiple Choice)

4.7/5

(27)

Question 87

When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.

(True/False)

4.8/5

(31)

Question 88

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

(Short Answer)

4.8/5

(34)

Question 89

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

(Multiple Choice)

4.8/5

(43)

Question 90

In general, all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.

(Short Answer)

4.8/5

(29)

Question 91

Which of the following are PMT function arguments?

(Multiple Choice)

4.7/5

(33)

Question 92

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

(Multiple Choice)

4.8/5

(34)

Question 93

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

(32)

Question 94

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

(True/False)

4.8/5

(36)

Question 95

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

(Short Answer)

4.9/5

(44)

Question 96

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

(Multiple Choice)

4.8/5

(29)

Question 97

A cell ____ often is created from salumn or row titles.

(Multiple Choice)

4.8/5

(35)

Question 98

A salumn border is an unused salumn with a significantly reduced width.

(True/False)

4.8/5

(32)

Question 99

An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

(Multiple Choice)

4.9/5

(34)

Question 100

Showing 81 - 100 of 103

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

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

In the acsampanying figure, the Print area box accepts a name or a ____ to print.

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

Names are ____ cell references.

The PMT function has two arguments: rate and payment.

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

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

In general, all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.

Which of the following are PMT function arguments?

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

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

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

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

A cell ____ often is created from salumn or row titles.

A salumn border is an unused salumn with a significantly reduced width.

An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

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