Exam 97: Formatting Spreadsheets

When you click the Center button,a cell's contents are ____ centered within its cell borders.

To center a heading over four cells,in the Paragraph group,click the Merge button.

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

Excel aligns text along the left cell border by default.

When you want a cell's background to contain color,click the ____________________ button in the Font group on the Home tab.

You can draw attention to a range of cells by adding a(n)____________________ to its edges.

Excel aligns numbers along the ____________________ cell border by default.

In Excel,filtering a column's data means that you temporarily exclude data from screen visibility.

When the "My list has headers" check box is not selected,Excel excludes column headings when it sorts data.

Number formatting options are found on the Home tab on the Ribbon.

Functionality to add a border to a cell is found in the Font group on the Home tab.

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

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

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

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

You can merge three cells together to create one bordered cell.

Using Conditional Formatting,text in a range of cells can be formatted to display a certain color depending on the function in the cell.

In the Table Styles group,the gallery of table styles is divided into two sections: Light and Dark.

A border can be applied to a cell or to a range of cells.

When you apply a(n)____________________ format to selected cells,filter arrows appear so you can manipulate what displays on the screen.