Exam 18: Organizing and Enhancing Worksheets

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

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. Sam has selected a range of cells he wants to freeze. Which option will allow him to freeze panes based on selected cells?

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

FIGURE 18-1 What is pictured in Figure 18-1 above?

By using fields in headers or footers instead of manually entering information, the information is always updated automatically.

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

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

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

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?

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

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

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

Zoom settings allow you to change the magnification.

The ____ button spans text across several columns.

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

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.

Explain the difference between sorting and filtering data and give an example of when each should be used.

When you freeze rows and columns, the data remains intact; it's just not visible on the screen.

The font size is a measurement in inches that determines the height of the font.