Exam 13: Formatting a Worksheet

To center text across columns, select the range of cells to be merged, then click the Merge & Center button in the Cell group on the Home tab._________________________

Font attributes are typically applied to the entire contents of a cell, but it is possible to change the font attributes for selected text inside a cell.

If a cell containing label data is a column heading, select the cell and click the Align Text Right button in the ____________________ group on the Home tab to move the label to the right side of the cell so that it aligns with the column of numbers.

The ___________________ function can be used to hide rows or columns you don't want displayed.

A formula that contains an absolute reference changes when the formula is copied or moved.

If a label is too long to fit into a cell, it extends into the next cell on the right, if that cell is empty._________________________

Excel gives you the ability to apply number formats to your values.Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

To delete more than one row at a time, drag down over the rows you want to delete.Click the down-arrow button next to Delete in the ____ group, then click Delete Sheet Rows to delete the rows.

Label data is ____ without changing.

Workbooks are an important part of Excel.Please 1) Describe a workbook and how they are used, 2) Explain how many default worksheets are included in each workbook, and 3) Describe some of the adjustments you can make to worksheets.

To hide a block of rows or columns, first select the rows or columns to be hidden, ____ the highlighted area, then select Hide.

To add a colored background to the selected cell or cells, click the ____ tab.Select a color, then click the OK button to apply the background color.

By default, labels are aligned on the ____ of a cell.

The default workbook contains three worksheets, titled ____.

For example, the reference Sheet3!A1 indicates ____.

You can ____ by right-clicking a worksheet tab and making a selection from the shortcut menu.

If a column is too narrow, labels might be cut off and numbers are displayed as ____.

To display rows or columns that were previously hidden, select the rows or columns that border the hidden section.Right-click, then choose ____.

-Referring to the figure above, the number category shown in the dialog box is ____.

____ styles are built into the software, and include formats for displaying currency, percentages, and general numbers.