You can adjust both the width of columns and height of rows in an Excel worksheet.
In the Format Cells dialog box, you can see what your text will look like in the Sample box.
If you select the Hide command, it will hide all labels in a worksheet.
Format painter allows you to copy only the format of a cell.
If you choose the Standard Width command from the Format menu, your columns are reset to 1.5 inches.
In figure 1, item 2 displays the currently selected font.
In figure 1, item 2 indicates line length in picas.
In figure 1, item 1 points to pattern attribute options.
In figure 1, item 1 points to the available fonts.
Format Painter button
A cell's format can be copied into other cells using the __________.
Formatting affects how information appears in __________.
before or after data is entered
Cells and ranges in a worksheet can be formatted __________.
letters, numerals, symbols, and punctuation marks
A font is the name given to a collection of __________.
on the border between column headings A and B
To change the width of column A using the mouse, be sure to position the mouse pointer __________.
To adjust the width of a column to fit the widest entry, use the __________ command.
The __________ toolbar is used to change fonts and sizes.
a little less than one inch
The default column width is __________.
If you want to see a sample of a selected font, open the __________ dialog box.
use the Column Standard Width command on the Format menu.
To reset columns to the default width, select the range of cells, then __________.
allows you to set the column width to a specific number of characters.
Selecting the Format menu, then column, and then width __________.
bold, italics, and underlining
Attributes are font styling features, such as __________.
Row height must excced __________.
To delete a row from a worksheet, click the row selector button, click Edit on the __________ bar, the click Delete.
colors, patterns, borders
To enhance the appearance of a worksheet use _________.
Excel automatically adjusts the formula
When you add or delete a row or column within a range used in a formula, __________.
The __________ Menu is used to add a comment to a cell.
Shifting cells down, inserting a row, and inserting a column
__________ can be accomplished from the Insert dialog box.
rows and columns
You can insert __________ into or delete them from your worksheet.
The __________ menu is used to see a comment in a cell.
Patterns tab in the Format Cells dialog box and Borders and Fill Color buttons on the formatting toolbar
You can apply colors, patterns, and borders to a worksheet using the _________________________________________.
In figure 2, item 4 points to an __________ button.
In figure 2, item 2 points to the __________ button.
apply a color to a cell's background.
In the figure 2, item 3 indicates the Fill Color button, which is used to __________.
Single underline, double underline, and outline are examples of __________ buttons.
To apply conditional formatting, select Conditional formatting on the __________ menu.
the File menu
Which menu is used to send a workbook as an attachment?
before data is entered and after data is entered
In figure 3, item 3 points to the Percent style button, which can be used to format cells __________.
In figure 3, item 1 points to the __________.
In figure 3, item 4 points to the Comma style button, which can be used to format __________.
In figure 3, item 2 points to the __________ button.
In figure 2, item 5 points to an __________.
Merging and Centering
In figure 2, item 1 indicates the application of the formatting attribute __________.
in figure 3, you would use the button labeled __ to increase the number of decimal places in selected cells.
Fill Color button
In figure 3, item 6 points to the __________.