Question 1

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

Accepted Answer

A)  data table 
B)  formula checker 
C)  amortization schedule 
D)  IF function 
A)  data table 
B)  formula checker 
C)  amortization schedule 
D)  IF function

Question 2

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

Accepted Answer

A)  ranges 
B)  values 
C)  indices 
D)  borders 
A)  ranges 
B)  values 
C)  indices 
D)  borders

Question 3

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 4

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

Accepted Answer

Question 5

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 6

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 7

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 8

Data tables have multiple purpose(s).

Accepted Answer

A) True 
 B)False

Question 9

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

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 14

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 15

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)  validate 
A)  lock 
B)  manipulate 
C)  name 
D)  validate

Question 16

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 17

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 18

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

Accepted Answer

A)  used 
B)  unused 
C)  upper-left 
D)  lower-right 
A)  used 
B)  unused 
C)  upper-left 
D)  lower-right

Question 19

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

Accepted Answer

Excel lets you format (1) before you ent

Question 20

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

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

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

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

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

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

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.

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

Data tables have multiple purpose(s).

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

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.

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

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

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.

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

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

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.

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

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

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

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.

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