Question 1

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

Accepted Answer

Question 2

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

Accepted Answer

A)  locked 
B)  indexed 
C)  unprotected 
D)  hybrid 
A)  locked 
B)  indexed 
C)  unprotected 
D)  hybrid

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Assigning names to a cell or range of cells allows you to select them quickly.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

In a process called ____,Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

Accepted Answer

A)  background formula checking 
B)  workbook formula checking 
C)  foreground formula checking 
D)  background function checking 
A)  background formula checking 
B)  workbook formula checking 
C)  foreground formula checking 
D)  background function checking

Question 10

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 11

To hide an entire workbook on an unattended computer,click the Hide button on the ____.

Accepted Answer

Question 12

The PMT function has two arguments: rate and payment.

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

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

Accepted Answer

A)  repetitiveness 
B)  brevity 
C)  violations 
D)  consistency 
A)  repetitiveness 
B)  brevity 
C)  violations 
D)  consistency

Question 15

You can name a range by ____.

Accepted Answer

A)  selecting a cell or range,clicking the Define Name button (FORMULAS tab | Define Names group) 
B)  selecting a cell or range,typing the name in the formula bar,and pressing the ENTER key 
A)  selecting a cell or range,clicking the Define Name button (FORMULAS tab | Define Names group) 
B)  selecting a cell or range,typing the name in the formula bar,and pressing the ENTER key

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Data tables have multiple purpose(s)._________________________

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A)  hide 
B)  protect 
C)  code 
D)  delete 
A)  hide 
B)  protect 
C)  code 
D)  delete

Question 19

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 20

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

Accepted Answer

A)  5 
B)  20 
C)  50 
D)  As many as you want 
A)  5 
B)  20 
C)  50 
D)  As many as you want

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

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

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.

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

Assigning names to a cell or range of cells allows you to select them quickly.

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

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

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 a process called ____,Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

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

To hide an entire workbook on an unattended computer,click the Hide button on the ____.

The PMT function has two arguments: rate and payment.

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

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

You can name a range by ____.

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

Data tables have multiple purpose(s)._________________________

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

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

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

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 4: Financial Functions, Data Tables, and Amortization Schedules

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

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

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.

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

Assigning names to a cell or range of cells allows you to select them quickly.

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

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

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 a process called ____,Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

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

To hide an entire workbook on an unattended computer,click the Hide button on the ____.

The PMT function has two arguments: rate and payment.

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

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

You can name a range by ____.

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

Data tables have multiple purpose(s)._________________________

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

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

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

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters