Excel Chapter 2 MC Flashcards
____ theme colors are designated for text and background, ____ colors are used for accents and highlights, and ____ colors are used for hyperlinks.
Four, six, two
You can create a ____ color by specifying a mixture of red, blue, and green color values.
custom
To add a ____ to a sheet tab, click the Format button, point to Tab color, and then click a color.
fill color
Selecting the Font Color button arrow will display ____.
10 theme colors A standard color bar A ScreenTip displaying the color name
The ____ appears when you select text and contains buttons for commonly used text formats.
Mini toolbar
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
By default, values appear in the ____ and generally display numbers exactly as you type them.
General number format
Which of the following can you format using the Number group in Excel’s home tab?
Currency formats Numbers to percentages Commas as a thousands separator
Using date and time in Excel, you can ____.
Calculate date and time intervals Format a date or time value
Dates and times in Excel measure intervals between the specified date and time and ____.
January 1, 1900 at 12:00am
In Excel, dates are ____-aligned in the cell by default, regardless of date format.
right
As a general rule, you should ____.
center column titles, left-align text, and right-align numbers
____ merges each of the rows in the selected range across the columns in the range.
Merge Across
In Excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell.
A1:E1
Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.
Orientation
You can add a border in Excel ____.
To enhance readability To the top, right, or bottom of a cell And specify the thickness
All of the following options are available on the Format Cells dialog box except ____.
size
The Paste Options button allows you to ____.
Keep source formatting Copy formatting only, Copy values only
In the Paste Special dialog box, you can ____
Select to rotate selected range 90 degrees Paste only values Paste values and formats
You can treat a range of data as a distinct object in a worksheet known as a(n) ____.
Excel table
A(n) ____ specifies formats for elements in an Excel table, such as font color, fill color, and so forth.
table style
The most efficient way to format an entire table is to ____.
use a table style
Applying a table style marks the range as a table, making available tools designed for analyzing tabular data, including ____.
The ability to sort data Transferring data to and from an external file Filtering data to show only rows that match specified criteria
In Excel, the table style ____ inserts a new row at the bottom of the table that adds the column values.
Total Row
In Excel, the ____ table style formats alternating columns in different colors.
Banded Columns
All of the following are conditional formats in Excel except ____.
font sets
A ____ is a horizontal bar added to the background of a cell to provide a visual indicator of a cell’s value.
data bar
Data bar ____ is based on a cell’s value.
length
In conditional formatting, to highlight only cells that contain a specific date, select the rule____.
A Date Occurring
To view certain columns on a large database, a good option is to ____.
hide columns without information you need
