Exam 17: Excel 2007 Unit C: Formatting a Worksheet

The arrow shown in the figure above indicates the ____.

As shown in the figure above, item 1 points to the ____ button.

The ____________________ format adds dollar signs and two decimal places to the data.

You can add words to the dictionary of the spelling checker.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

The Bold and Underline buttons are found in the Font group on the Home tab of the Ribbon.

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

Cell templates are sets of attributes based on themes; they are automatically updated if you change a theme.

Susan is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created the worksheet shown below. But she is not familiar with the formatting features of Excel and has asked you for help. You now need to further format the worksheet title and resize all the columns. a) Write the procedure for centering and merging the worksheet title over the columns A, B, C, and d. b) Write the procedure for resizing columns A, B, and C using the AutoFit feature so that the widest entry in each column fits.

You can apply attributes and alignment options using the ____ tab of the Ribbon.

The Format Painter button copies both the cell's content and formatting.

As shown in the figure above, item 1 points to the ____ button in the Styles group on the Home tab of the Ribbon.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width .

The ____ size is the physical size of the text.

As shown in the figure above, item 3 is the ____________________ button and item 4 is the ____________________ button.

Explain why you would add colors, patterns, and borders to a worksheet. How do you add these enhancements in Excel?

The default Accounting Number format adds dollar signs and ____ decimal places to the data.

The font size is measured in units called pixels .

As shown in the figure above, item ____ points to the Merge Center button.

The formatting due to ____ formatting is automatically updated if you change data in the worksheet.