Exam 2: Microsoft Excel Basics

COUNT CELLS determine how many entries are included in the range.

You can count numerical data in a range using the ____ function.

The primary financial functions are future value, present value, and payment .

You enable the Track Changes feature by clicking a check box in the ____________________ dialog box.

You can use shortcut keys to quickly cut, copy, and paste cells.

The ____ feature can be used to ensure that data is entered as accurately as possible in a worksheet.

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

A file that is downloaded from SkyDrive cannot be edited.

Case EX 12-2 Joey has created a PivotTable that contains the financial data for his restaurant. If Joey's PivotTable has two levels of fields, he can click on a ____ to hide some of the data.

Pie charts can be harder to design because you must designate which data should be used on each axis.

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

Drop-down lists are not useful when only specific data can be entered into a cell.

As you review changes made to cells in a workbook with Track Changes enabled, you can accept or deny the changes.

To use the HLOOKUP function, you will need to enter information into the ____________________ dialog box.

The print area consists of the cells and ranges designated for printing.

When the file is downloaded from SkyDrive, it opens in Secure View.

To select more than one cell or range in a worksheet, select the first cell or range, hold down the Shift key, and select each additional cell or range.

A format is the design of text.