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

Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. Ruth has fully tested all of the formulas in her worksheet and the sarrect results appear. Ruth provides a sapy of the worksheet file to Barret so he can use it for his business calculations. As a user, Barret can make changes only to certain cells. What did Ruth do to ensure the other cells cannot be altered by user Barret?

(Multiple Choice)

4.9/5

(34)

Question 61

You can add only a maximum of five sanditional formats to a range.

(True/False)

4.7/5

(36)

Question 62

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. After Bill creates the amortization schedule, he decides to add a calculator section to the worksheet. How would he create a salumn border to separate the calculator from the amortization schedule section?

(Multiple Choice)

4.9/5

(37)

Question 63

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

(Multiple Choice)

4.7/5

(31)

Question 64

An alternative to a one-input data table is a three-input data table.

(True/False)

5.0/5

(41)

Question 65

Which of the following is the maximum number of active data tables per worksheet?

(Multiple Choice)

4.9/5

(39)

Question 66

You can delete a data table by selecting the data table and then ____.

(Multiple Choice)

4.9/5

(40)

Question 67

In the Varying Interest Rate Schedule created in this chapter, the series of interest rates in salumn B are called ____________________.

(Short Answer)

4.9/5

(34)

Question 68

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

(True/False)

4.8/5

(31)

Question 69

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed sapy or when previewed.

(True/False)

4.9/5

(34)

Question 70

In a data table, the ____________________ you are analyzing must include a cell reference to the input cell.

(Short Answer)

4.9/5

(29)

Question 71

Smart worksheet design starts with visualizing the results you need.

(True/False)

4.9/5

(37)

Question 72

You should create worksheets as if you are going to use them only once.

(True/False)

4.9/5

(28)

Question 73

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

(True/False)

4.9/5

(32)

Question 74

Which of the following is the path to the Financial button and the PMT function?

(Multiple Choice)

4.9/5

(36)

Question 75

Excel is case sensitive with respect to names of cells.

(True/False)

4.8/5

(30)

Question 76

Spreadsheet specialists usually format a worksheet before they enter any data.

(True/False)

4.9/5

(39)

Question 77

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.

(True/False)

4.9/5

(39)

Question 78

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

(True/False)

4.9/5

(36)

Question 79

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

(Multiple Choice)

4.8/5

(31)

Question 80

Showing 61 - 80 of 103

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

You can add only a maximum of five sanditional formats to a range.

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

An alternative to a one-input data table is a three-input data table.

Which of the following is the maximum number of active data tables per worksheet?

You can delete a data table by selecting the data table and then ____.

In the Varying Interest Rate Schedule created in this chapter, the series of interest rates in salumn B are called ____________________.

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed sapy or when previewed.

In a data table, the ____________________ you are analyzing must include a cell reference to the input cell.

Smart worksheet design starts with visualizing the results you need.

You should create worksheets as if you are going to use them only once.

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

Which of the following is the path to the Financial button and the PMT function?

Excel is case sensitive with respect to names of cells.

Spreadsheet specialists usually format a worksheet before they enter any data.

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.

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

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

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