Name: 

In Excel, the header row provides labels which identify the content in the worksheet columns.

Zoom settings allow you to change the magnification.

When you split a worksheet horizontally, the panes appear side by side on the screen.

You cannot rename sheet tabs.

When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.

You can use multiple fonts in one document.

The default Currency format has two decimal places and a dollar sign.

Spreadsheets can function as basic databases.

When you apply a table style, the selected cells are converted to an Excel table.

You can base a sort on as many as six columns.

A ____ contains column headings or field names in a data source, such as a table or spreadsheet.

An alternative way to freeze rows and columns is to ____ a worksheet, which divides the worksheet into two panes.

When you want to add a new category to an Excel workbook, you click the ____ at the bottom of the screen.

____ at the bottom of the screen provide quick and easy access to worksheets.

The ____ allows you to remove the contents and the formatting in a cell.

The ____ button allows you to combine several cells into a single cell.

Which button allows you to align text at an angle within a cell?

If text doesn’t fit on one line, you can use the ____ button to allow all the text to wrap to new lines within the cell.

Which button can you use to change the number format from .10 to .1 in a cell?

The ____ command scales the worksheet up or down as necessary so it fits on the number of pages you designate.

____ can be used to insert dates, times, filenames, the file path, and page numbers automatically.

____ provide useful information on a printed worksheet and are printed in the top margin of every worksheet page.

Commands for changing print settings are located on the ____ tab.

Which option in the Print dialog box enables you to print only selected cells in the active worksheet?

The ____ button spans text across several columns.

When the header row scrolls out of view, it is difficult to identify the data. Which of the following is not an option to help overcome this problem?

A key feature of Microsoft Excel is the ease with which you can ____.

Which button opens the Quick Styles gallery filled with table styles?

FIGURE 18-1

What is pictured in Figure 18-1 above?

FIGURE 18-2

Which button is the black arrow pointing to in Figure 18-2 above?

Case 18-1
Martha is a high school math teacher. She has created a worksheet to track her students’ grades. She added two new students to the worksheet today and she wants to make sure the formatting is consistent.

Which button should she use to copy the formatting of a cell without copying the contents of the cell?

Which button should Martha use to add a black line to the bottom of a row of cells that contain the midterm exam grades?

Case 18-2
Sam is viewing a very large worksheet that contains product data for the warehouse where he works. He is getting frustrated trying to locate data. He tried splitting the worksheet, but that didn’t help him find what he was looking for.

How can Sam remove the dividing line in the split worksheet?

Sam has selected a range of cells he wants to freeze. Which option will allow him to freeze panes based on selected cells?