Exam 97: Formatting Spreadsheets

Conditional formatting is used to ____ that are usually difficult to visualize when viewing a spreadsheet.

To display a cell's entire contents,click the ____________________ button in the Alignment group on the Home tab.

When you apply the Currency format type,the ____________________ symbol is displayed in the cell.

The ____________________ can be used to copy a cell's color shading from one cell to another to ensure consistency between related cells.

Selected spreadsheet cells can be sorted by the values in more than one column.

A range of cells designated as a(n)____ can be analyzed and treated as separate from the rest of the Excel worksheet.

Excel's gallery of table styles is divided into three sections: ____.

Applying the Comma format to a cell displays the ____.

The ____ group on the Home tab contains the buttons you use to format text in cells.

The Number Format box includes two formats that contain dollar signs: ____.

In Excel,the Conditional Formatting option is located in the ____ group on the Home tab.

When a cell is formatted in Currency,a zero value will display as ____.

When you want a cell's contents,which consist of the total amount of wages paid this pay period,to stand out in a spreadsheet,you should apply a ____ border.

A cell's border can be displayed in ____.

You improve the look of a worksheet by aligning the contents of cells,but adding borders and colors is a distraction to viewers.

____________________ data makes it easier to read large sets of data.

By default,numbers entered in cells display in the General format type.

The general rule for formatting is to keep text ____.

You specify a range of cells as an Excel table by applying a cell format.

The general rule for formatting is to keep numbers ____,with decimal places aligned.