Excel Unit C Formatting a Worksheet Test – Flashcards
Unlock all answers in this set
Unlock answersquestion
True or False: You can apply formatting before or after you enter data in a cell or range.
answer
true
question
True or False: The Format Painter button copies both the cell's content and formatting.
answer
false
question
True or False: Normally, you don' t need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.
answer
true
question
True or False: When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.
answer
false
question
True or False: You can add words to the dictionary of the spelling checker.
answer
true
question
True or False: Formatting can change the actual data of a cell.
answer
false
question
True or False: You can change the font and font size of any cell or range using the Mini toolbar.
answer
true
question
True or False: The Increase Decimal button automatically adds dollar signs and two decimal places to your data.
answer
false
question
True or False: You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.
answer
false
question
A predefined set of attributes that gives your Excel worksheet a professional look.
answer
theme
question
Equal to 1/72 of an inch.
answer
point
question
The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.
answer
font
question
A type of conditional formatting that visually illustrates differences among values.
answer
data bar
question
Has a default value of 8.43 characters, a little less than one inch.
answer
column width
question
Font _______ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.
answer
styles
question
You can change the __________ of labels and values in cells to be left, right, or center.
answer
alignment
question
As shown in the figure above, the currently selected font is ____________.
answer
Calibri
question
As shown in the figure above, the current font size is __________.
answer
11
question
As shown in the figure above, item 6 is the ________ list arrow .
answer
Number Format
question
As shown in the figure above, item 2 is the ______ button.
answer
Percent Style
question
To format a cell or range, first you select it, and then you apply the formatting using the ______ or keyboard shortcut.
answer
Ribbon
question
In the figure above, item 2 points to the ______ button in the Alignment group on the Home tab of the Ribbon.
answer
Center
question
In the figure above, item 5 points to the _______ button in the Styles group on the Home tab of the Ribbon.
answer
Conditional Formatting
question
In the figure above, item 7 points to the ___________ button in the Styles group on the Home tab of the Ribbon.
answer
Cell Styles
question
As shown in the figure above, item _____ points to the Center button.
answer
5
question
As shown in the figure above, item _________ points to the Merge & Center button.
answer
8
question
As shown in the figure above, item 1 points to the __________ button.
answer
bold
question
As shown in the figure above, item _____ points to the Bottom Border button.
answer
4
question
As shown in the figure above, item ____ points to the button that italicizes text.
answer
2
question
You can apply attributes and alignment options using the ______ tab of the Ribbon.
answer
Home
question
Double-clicking the column line to the right of a column activates the _________ feature for the column.
answer
AutoFit
question
A ________ is an individual media file, such as art, sound, animation, or movie.
answer
clip
question
Cells and ranges in a worksheet can be formatted ________.
answer
before ore after data is entered
question
You can change colors, patterns, & borders of cells using the Fill tab & Border tab in the __________ dialogue box.
answer
Format Cells
question
The default Accounting number format adds dollar signs and __________ decimal places to the data.
answer
two
question
The Spelling button is found in the Proofing group on the _______ tab on the Ribbon.
answer
Review
question
The formatting due to _________ formatting is automatically updated updated if you change data in the worksheet.
answer
conditional
question
You can apply attributed and alignment options using the ________ dialogue box.
answer
Format Cells
question
###### in a cell means that the __________.
answer
column is too narrow to display the value completely
question
You insert a comment in a worksheet by using the ______ tab in the Ribbon.
answer
Review
question
The _____ of a cell determines how the labels and values look.
answer
format
question
The _______ size is the physical size of the text.
answer
font
