Exam 50: Formatting Spreadsheets

To display headings in the middle of the cell rather than at the bottom,click the ____ Align button on the HOME tab.

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

A cell's border can be displayed in ____.

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

Tools for filtering data are located in the HOME tab's ____ group.

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

The general rule for formatting is to keep text ____.

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

A cell contains the value .065,and you click the Percent Style button.What value displays in the cell?

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

When the Accounting format type is applied to a cell,numbers display with a dollar sign and three decimals.

To enhance the visibility of data in a series of cells in order to signify a conditional change within a column,use ____ formatting.

You specify a range of cells as an Excel table by applying a cell format such as bold to the selected cells.