Exam 19: Organizing and Enhancing Worksheets

Page Break Preview displays your page as it will look when printed. ____________________

A ____ contains column headings or field names in a data source.

A ____ is the design of the typeface.

If the text does not fit on one line of a cell, you can wrap to new lines.

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

An example of a font size is 12 _____.

In Excel, a cell's width is automatically adjusted when the font size changes.

When filtering data, you can control the screen data displayed by specifying certain criteria.

To display the current date in a footer, insert the date ____________________.

To change the angle of the text direction, click the ____________________ button.

When a comment is added to a selected cell, it can be viewed in _____.

The header and footer commands are located on the ____ tab.

In a worksheet, a split can be removed by double-clicking the split bar.

Which of the following is NOT true about changing alignment?

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

How many worksheets are contained in a blank workbook by default? Why would you add a new worksheet to a workbook? What do you click to display a different worksheet? Can you copy and paste data from one worksheet to another? List at least one method for inserting a new worksheet. What happens when you delete a tab for a worksheet that contains data?

To remove the data and the formats from a cell, you need to ____________________ the cell.

The default Zoom setting is 75%.

Spreadsheets are often used for reporting finances and managing expenses.

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.