Exam 50: Formatting Spreadsheets

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

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

You can improve the look of a worksheet by aligning the contents of cells only; it is not necessary to add colors or borders because it is a distraction to readers.

The TABLE TOOLS DESIGN tab is always visible when you are working in Excel.

The general rule for formatting is to ____ column headings.

Excel aligns text along the left cell border by default.

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

Using the Custom Sort feature,data can be rearranged by all of the following EXCEPT ____.

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.

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

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

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

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

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

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

Using the sort and filter tools in a large spreadsheet can simplify the data needed for decision making or problem solving.

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

When an Excel table is activated,a new tab titled ____ appears.

Applying the Comma format to a cell displays the ____.

Format Painter is a good tool to use when you are formatting tables alphabetically.