Question 1

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

Accepted Answer

Excel lets you format (1) before you ent

Question 2

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

Accepted Answer

A)  Paste Options 
B)  Insert Comment 
C)  Format Cells 
D)  Filter 
A)  Paste Options 
B)  Insert Comment 
C)  Format Cells 
D)  Filter

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Periods and underscore characters are allowed in, but cannot begin, cell ____________________.

Accepted Answer

The answer of Periods and underscore characters are allowed in,...

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

Question 7

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

Accepted Answer

A)  function 
B)  name 
C)  formula 
D)  data table 
A)  function 
B)  name 
C)  formula 
D)  data table

Question 8

The ____ function returns the present value of an annuity.

Accepted Answer

A)  FV 
B)  PMT 
C)  PV 
D)  VDB 
A)  FV 
B)  PMT 
C)  PV 
D)  VDB

Question 9

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 10

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

Accepted Answer

A)  range 
B)  file 
C)  worksheet 
D)  tab 
A)  range 
B)  file 
C)  worksheet 
D)  tab

Question 11

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 12

Which of the following are PMT function arguments?

Accepted Answer

A)  formula name 
B)  monthly interest rate 
C)  number of payments 
D)  loan amount 
A)  formula name 
B)  monthly interest rate 
C)  number of payments 
D)  loan amount

Question 13

Excel automatically selects the Left column 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 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  ALT 
B)  CTRL 
C)  TAB 
D)  SHIFT 
A)  ALT 
B)  CTRL 
C)  TAB 
D)  SHIFT

Question 16

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

Accepted Answer

A)  clicking the Delete command in the Clipboard group on the Home tab 
B)  pressing the DELETE key 
C)  clicking the DELETE DATA TABLE command on a shortcut menu 
D)  pressing the OVERTYPE key 
A)  clicking the Delete command in the Clipboard group on the Home tab 
B)  pressing the DELETE key 
C)  clicking the DELETE DATA TABLE command on a shortcut menu 
D)  pressing the OVERTYPE key

Question 17

Case 4-1
Bill has a bicycle repair shop in his basement. He would like a larger workshop so he investigates taking out a loan to convert 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 components will he need to identify for a loan amortization schedule created on an Excel worksheet?

Accepted Answer

A)  beginning and ending loan balance 
B)  year, rate, monthly interest 
C)  beginning and ending loan balance and the amount of payment that applies to the principal and interest per year 
D)  interest paid at the beginning and end of the year 
A)  beginning and ending loan balance 
B)  year, rate, monthly interest 
C)  beginning and ending loan balance and the amount of payment that applies to the principal and interest per year 
D)  interest paid at the beginning and end of the year

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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.

Accepted Answer

A)  Margins 
B)  Header/Footer 
C)  Page 
D)  Sheet 
A)  Margins 
B)  Header/Footer 
C)  Page 
D)  Sheet

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

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

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

Periods and underscore characters are allowed in, but cannot begin, cell ____________________.

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.

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

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

The ____ function returns the present value of an annuity.

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

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

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

Which of the following are PMT function arguments?

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

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.

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

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

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

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 can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

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

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

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

Periods and underscore characters are allowed in, but cannot begin, cell ____________________.

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.

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

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

The ____ function returns the present value of an annuity.

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

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

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

Which of the following are PMT function arguments?

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

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.

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

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

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

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 can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters