Exam 18: Organizing and Enhancing Worksheets

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

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

You cannot rename sheet tabs.

____ 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.

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

Spreadsheets can function as basic databases.

When you ____________________ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

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

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?

A cell style is a set of predefined formats you can apply to some of the worksheet data, such as a header row, a cell showing a total, or cells showing the date and time.

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

____________________ orientation formats the document sideways with the long edge of the page at the top.

You can use multiple fonts in one document.

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

When you ____________________ data, you screen data that matches specified criteria.

A(n) ____________________ is the design of the typeface in a document.

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?

A(n) ____________________ style is a set of predefined formats that you can apply to all the worksheet data with a single click.

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