Quiz 6 Excel 2

Formatting changes only the appearance of data—it does not affect the data itself. _________________________

Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. _________________________

A conditional format can make negative numbers red and positive numbers black. _________________________

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________

Each header and footer has three sections—a left section, a center section, and a right section. _________________________

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin. _________________________

Excel organizes fonts into theme and non-theme fonts. _________________________

The cell reference for the merged cell is the upper-right cell reference. _________________________

By default, Excel displays text in a black font color. _________________________

The background image does not affect any cell's format or content. _________________________

Calculated values too large to fit into the cell are displayed in scientific notation. _________________________

Text and numbers are displayed vertically within cells. _________________________

A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________

A conditional format applies formatting to a cell when its value meets a specified condition. _________________________

A footer appears at the top of each printed page. _________________________

If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer. _________________________

One of the benefits of Live Preview is that it _____.

Italic, bold, bold italic, and underline are examples of _____.

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks.

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

By default, numbers appear in the _____ and generally display values exactly as you type them.

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

In Excel, dates are _____-aligned in the cell by default, regardless of date format.

As a general rule, you should _____.

_____ merges each of the rows in the selected range across the columns in the range.

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

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

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

_____ are an example of conditional formats in Excel.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

Fonts, colors, and cell styles are organized in _____ categories.

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

To set a page break in Excel, select the _____.

A _____ indicates a manual page break.

Information that prints on each page, like a company name or logo, may be set as a _____.

A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

Ten ____________________ colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—are always available regardless of the workbook's theme.

One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

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

When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.