Exam 2: Microsoft Excel Basics

When an unauthorized person tries to pry into a(n) decrypted file, they will only see unreadable text and symbols.

When a macro is being recorded, all of the selections you make are translated into code .

FIGURE EX 8-1 In Figure EX 8-1 above, the phrase Median Income is the ____.

You can create a sparkline for each row or column of data within a worksheet.

The ____ button gives you the option to remove the Trace Dependents tracer arrows, the Trace Precedents tracer arrows, or all the tracer arrows.

____ functions allow you to find data that already exists rather than looking for the data yourself.

A selected chart element is surrounded by a ____.

To check the spelling in a worksheet, click the Review tab on the Ribbon, and then, in the ____ group, click the Spelling button.

A ____ data table uses one function to change cells that use this function.

Date and time functions are used to format and work with cell contents.

Before you export data, you may want to save the file as a(n) ____.

The ____ tab contains tools to edit and format the picture.

With a(n) ____ workbook, changes made by multiple users are tracked.

The Print option called Print ____ prints all of the worksheets in a workbook.

The PivotTable and PivotChart are ____.

If you select a cell containing data and then click the Trace Dependents button, a(n) ____________________ is drawn from the selected cell pointing to the cell with the function.

____ appear horizontally and are identified by numbers on the left side of the worksheet window.

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.