Quiz 6 Excel 2

Sep 22nd, 2023
4.7 (114 reviews)
45 test answers
question
Formatting changes only the appearance of data—it does not affect the data itself. _________________________
answer
True
question
Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________
answer
True
question
The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________
answer
True
question
Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. _________________________
answer
True
question
A conditional format can make negative numbers red and positive numbers black. _________________________
answer
True
question
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________
answer
False
question
Each header and footer has three sections—a left section, a center section, and a right section. _________________________
answer
True
question
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. _________________________
answer
False
question
Excel organizes fonts into theme and non-theme fonts. _________________________
answer
True
question
The cell reference for the merged cell is the upper-right cell reference. _________________________
answer
False
question
By default, Excel displays text in a black font color. _________________________
answer
True
question
The background image does not affect any cell's format or content. _________________________
answer
True
question
Calculated values too large to fit into the cell are displayed in scientific notation. _________________________
answer
True
question
Text and numbers are displayed vertically within cells. _________________________
answer
False
question
A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________
answer
False
question
A conditional format applies formatting to a cell when its value meets a specified condition. _________________________
answer
True
question
A footer appears at the top of each printed page. _________________________
answer
False
question
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. _________________________
answer
True
question
One of the benefits of Live Preview is that it _____.
answer
lets you see and evaluate different formats as you develop your workbook
question
Italic, bold, bold italic, and underline are examples of _____.
answer
font styles
question
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.
answer
Four, six, two
question
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.
answer
fill color
question
When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.
answer
red and green
question
By default, numbers appear in the _____ and generally display values exactly as you type them.
answer
General format
question
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.
answer
numbers
question
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
answer
right
question
As a general rule, you should _____.
answer
center column titles, left-align text, and right-align numbers
question
_____ merges each of the rows in the selected range across the columns in the range.
answer
Merge Across
question
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.
answer
A1
question
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.
answer
Orientation
question
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.
answer
Number
question
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 _____.
answer
turn it off
question
_____ are an example of conditional formats in Excel.
answer
Data bars
question
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
answer
Painter
question
Fonts, colors, and cell styles are organized in _____ categories.
answer
theme and non-theme
question
To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.
answer
manual page break
question
To set a page break in Excel, select the _____.
answer
first cell below the row where you want to insert a page break
question
A _____ indicates a manual page break.
answer
solid blue line
question
Information that prints on each page, like a company name or logo, may be set as a _____.
answer
print title
question
A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
answer
theme
question
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.
answer
standard
question
One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.
answer
merge
question
The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
answer
Format Painter
question
The region that is sent to the printer from the active sheet is known as the ____________________.
answer
print area
question
When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.
answer
manual
1 of 45
question
Formatting changes only the appearance of data—it does not affect the data itself. _________________________
answer
True
question
Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________
answer
True
question
The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________
answer
True
question
Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. _________________________
answer
True
question
A conditional format can make negative numbers red and positive numbers black. _________________________
answer
True
question
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________
answer
False
question
Each header and footer has three sections—a left section, a center section, and a right section. _________________________
answer
True
question
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. _________________________
answer
False
question
Excel organizes fonts into theme and non-theme fonts. _________________________
answer
True
question
The cell reference for the merged cell is the upper-right cell reference. _________________________
answer
False
question
By default, Excel displays text in a black font color. _________________________
answer
True
question
The background image does not affect any cell's format or content. _________________________
answer
True
question
Calculated values too large to fit into the cell are displayed in scientific notation. _________________________
answer
True
question
Text and numbers are displayed vertically within cells. _________________________
answer
False
question
A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________
answer
False
question
A conditional format applies formatting to a cell when its value meets a specified condition. _________________________
answer
True
question
A footer appears at the top of each printed page. _________________________
answer
False
question
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. _________________________
answer
True
question
One of the benefits of Live Preview is that it _____.
answer
lets you see and evaluate different formats as you develop your workbook
question
Italic, bold, bold italic, and underline are examples of _____.
answer
font styles
question
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.
answer
Four, six, two
question
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.
answer
fill color
question
When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.
answer
red and green
question
By default, numbers appear in the _____ and generally display values exactly as you type them.
answer
General format
question
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.
answer
numbers
question
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
answer
right
question
As a general rule, you should _____.
answer
center column titles, left-align text, and right-align numbers
question
_____ merges each of the rows in the selected range across the columns in the range.
answer
Merge Across
question
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.
answer
A1
question
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.
answer
Orientation
question
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.
answer
Number
question
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 _____.
answer
turn it off
question
_____ are an example of conditional formats in Excel.
answer
Data bars
question
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
answer
Painter
question
Fonts, colors, and cell styles are organized in _____ categories.
answer
theme and non-theme
question
To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.
answer
manual page break
question
To set a page break in Excel, select the _____.
answer
first cell below the row where you want to insert a page break
question
A _____ indicates a manual page break.
answer
solid blue line
question
Information that prints on each page, like a company name or logo, may be set as a _____.
answer
print title
question
A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
answer
theme
question
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.
answer
standard
question
One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.
answer
merge
question
The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
answer
Format Painter
question
The region that is sent to the printer from the active sheet is known as the ____________________.
answer
print area
question
When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.
answer
manual