Quiz 6 Excel 2

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

A1

_____ are an example of conditional formats in Excel.

Data bars

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

False

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

False

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. _________________________

False

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

False

Text and numbers are displayed vertically within cells. _________________________

False

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

False

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

Format Painter

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.

Four, six, two

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

General format

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

Merge Across

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

Number

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

Orientation

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

Painter

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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. _________________________

True

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

True

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

True

As a general rule, you should _____.

center column titles, left-align text, and right-align numbers

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.

fill color

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

first cell below the row where you want to insert a page break

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

font styles

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

lets you see and evaluate different formats as you develop your workbook

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

manual

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

manual page break

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

merge

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

numbers

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

print area

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

print title

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

red and green

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

right

A _____ indicates a manual page break.

solid blue line

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.

standard

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

theme

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

theme and non-theme

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 _____.

turn it off