Capshaw Consulting Group Excel

SAM -Excel - Module 4 - Chapter 6 - Multiple Choice

Cell Protection

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

Name

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

Amortization Schedule

Shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

Borders

A cell ___ can be used to distinguish the different functional parts of a worksheet.

Unprotected

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

Name

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

PV

Function which returns the present value of an annuity.

(VIEW tab | Window Group)

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

Hide

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

CTRL

To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

Protect

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.

(HOME tab | Font group)

Path to the Borders button

(HOME tab | Styles group)

Path to the Cell Style button

(FORMULAS tab | Function Library group)

Path to the Financial button and the PMT function

(FORMULAS tab | Defined Names group)

Path to the Name Manager button

(REVIEW tab | Changes group)

Path to the Protect Sheet button

Format cells

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

Page

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.

Password

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

Data Table

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