|
the __________ of a cell determines how the labels and values look. |
format |
|
To format a cell or range, first you select it, and then you apply the formatting using the _________ , the mini toolbar, or a keyboard shortcut. |
ribbon |
|
The default Accounting number format adds dollar signs and ________ decimal places to the data. |
2 |
|
Cells and ranges in a worksheet can be formatted ________ ____ _____ . |
before and after |
|
The _____ size is the physical size of the text. |
font |
|
in the ______ window you can search for online pictures in office.com, through the bing seach engine, or on OneDrive. |
insert |
|
You can apply font sizes and alignment options using the ________ _______ dialog box. |
format cells |
|
You can apply font styles and alignment options using the _____ tab on the ribbon. |
home |
|
Font _______ are formats such as bold, italics, underlining that you can apply to affect the way text and numbers look in a worksheet. |
styles |
|
You can change the ___________ of labels and values in cells to be left,right, center. |
alignment |
|
Double-clicking the column line to the right of a column activates the ___________ feature for the column. |
autofit |
|
To remove all formatting for a selected range, click the _______________________ button in the editing group on the home tab. |
find and select |
|
###### in a cell means that the ________________________________________________________. |
column is to narrow to display the value in the cell |
|
to hide a selected column click the __________ button in the cells group on the home tab |
delete |
|
A small, __________ triangle appears in the upper-right corner of a cell containing a comment. |
red |
|
You can use colors,patterns,and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the way of adding these enhancements is to use the Borders, Font Colors, Fill Color buttons in the Font group ont he _________ tab of the ribbon |
home |
|
You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the _________ _________ dialog box. |
format cells |
|
cell _______ are redesigned combinations of formats. |
styles |
|
__________ ___________ shows you how a fill color will look before you apply it. |
Live preview |
|
_______ formatting is automatically updated if you change data in the worksheet. |
theme |
|
If you create a conditional formatting rule you can modify it using the Conditional Formatting __________ _____________. |
rules manager |
|
The spelling button is found in the Proofing group on the _________ tab on the ribbon. |
review |
|
The find and select button is found in the editing group on the __________ tab on the ribbon. |
home |
|
The name for a collection of characters with a similar, specific design ? |
font |
|
Equal to 1/72 of an inch? |
point |
|
Has a default value of 8.43 characters, a little less than one inch? |
default column |
|
A predefined set of attributes that gives your excel worksheet a professional look? |
theme |
|
A type of conditional formatting that visually illustrates differences among values? |
data bar |
Share This
Flashcard
