Exam 2: Formatting a Workbook

The background image does not affect any cell's ____.

A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows.

The region that is sent to the printer from the active sheet is known as the ___________________.

The most efficient way to format an entire table is to ____.

In the above figure,you can view a preview of the border style by looking under the heading "____."

To avoid splitting a worksheet in awkward places,you can insert a(n)____ to specify a specific breaking point.

Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.

In Excel,the ____ table style formats alternating columns in different colors.

What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.

When you don't want to associate a font with a particular design,you use a ____ font.

In Excel,to merge cells A1,B1,C1,D1,and E1,____ is the correct reference for the merged cell.

Modifying the number format affects the value stored in the workbook.

In the Paste Special dialog box,you can ____

To display alternate rows with different fill colors in Excel,use the effect known as ____________________.

If you revise a style in Excel,the appearance of any cell formatted with that style must be updated manually.

____ use the same file format for their theme files.

Setting the ____ to A1:L10 will print only data in those cells.

The appearance of text is determined by its type character._________________________

Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.

When you use conditional formatting to highlight cells in a worksheet,you do not need to include a legend.