Exam 2: Microsoft Excel Basics

A workbook that is saved in Excel is saved with the file extension ____.

You can click a button to select it without running the macro assigned to it.

Filter arrows appear in the lower-right corners of the column heading cells.

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh previews some of the styles and clicks one to apply it to the cell. He now wants to remove it. To remove a style from the selected cell, he should simply click ____ in the Good, Bad and Neutral section of the Cell Styles gallery.

Filtering data removes errors.

By default, the ____ theme is applied to each workbook.

The code words ____ signal the end of a macro.

Select the data totals when selecting the data for creating a chart.

If the last cell in the lower-right corner of a table is selected, you can press ____ to create a new, formatted row.

The Save As command saves an existing workbook on a disk, using its current name and save location.

Before you apply a theme, you need to add some basic formatting to the data, such as a table format, so that Excel knows how to apply the theme to your worksheet.

A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____.

To remove subtotals from the data, click any cell with data. Click the Subtotal button and then click Remove All in the Subtotal dialog box.

You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references.

Once password protection is removed from a worksheet, it cannot be added to the worksheet again.

Figure EX 16-1 Clicking the Encrypt with Password option shown in Figure EX 16-1 above opens the ____ dialog box.

The Transfer command pastes a row of cells into a column, or a column of cells into a row.

By applying conditional formats and criteria, you can then view the cell formats to see which cells met the condition.