# Excel Ch. 4 Review

Total word count: 724
Pages: 3

### Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
 data table You use a ___ to automate data analyses. amortization schedule An ___ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period. cell protection ___ ensures that users do not change the values inadvertently that are critical to the worksheet. the formula checker ___ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words. entry The data ___ section of a worksheet includes data items entered by a user of a worksheet. borders Cell ___ help to set off sections of a worksheet. name, name To print individual sections of a worksheet, ___ these sections then print them by ___. unprotected When considering which cells another worksheet user should be able to manipulate, leave the cells ___. shift You can deselect multiple selected sheets beginning with the Sheet 1 tab by pressing the ___ key and clicking the Sheet1 tab. name A cell ___ often is created from column or row titles. Home tab | font group Which of the following is the path to the borders button? format cells You can add and format a range border by right-clicking the selected range and clicking ___ on the shortcut menu. name You can select a cell or range by typing it’s ___ in the Name Box and pressing the Enter key. absolute Names are ___ cell references. Formulas tab | Defined Names group Which of the following is the path to the Name Manager button? global Names are ___ to the workbook. Formulas tab | Function Library group Which of the following is the path to the Financial button and the PMT function? one-input With a ___ data table you can vary the value in one cell. unused Data tables must be built in an ___ area of a worksheet. Home tab | Editing group Which of the following is the path to the Fill button? Data Table | Data Tools group What is the path to the What-If Analysis button? As many as you want Which of the following is the maximum number off active data tables per worksheet? pressing the Delete key You can delete a data table by selecting the data table and then ___. Home tab | Styles group Which of the following is the path to the Cells Styles button? PV The ___ function returns the present value of an annuity. round To prevent round-off errors, use the ___ functinon. page You can select a worksheet so that it will fit on one page with an option on the ___ tab in the Page Setup dialog box. sheet You can set up a worksheet to print in black and white with an option on the ___ tab in the Page Setup dialog box. range In the accompanying figure, the Print area box accepts a name or a ___ to print. draft quality A check mark in the ___ check box speeds up printing by ignoring formatting and not printing most graphics. name Rather than setting a print are each time you want to print a range, you can ___ the range. protect When building a worksheet for novice users, you should ___ the cells in that worksheet that you do not want changed, such as cells that contain text or formulas. password You should create a ___ when you want to keep others from changing the worksheet from protected to unprotected hide To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ___ on the shortcut menu. View tab | Window group To hide an entire workbook on an unattended computer, click the Hide button on the ___. background formula checking In a process called ___, Excel continually reviews the workbook for errors in formulas as you create or manipulate it. formula checker Similar to the spell checker, Excel has a ___ that check formulas in a worksheet for rule violations. green triangle When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ___ in the upper-left corner of the cell assigned the formula. formulas You can choose which rules you want Excel to use by enabling and disabling them in the ___area in the Excel Options dialog box, as shown in the accompanying figure. trace error button If you click the ___, Excel displays a menu; the first item int he menu identifies the error and the remainder of the menu contains commands you can click.

### More flashcards like this

#### NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

#### NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

#### NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price