MOAC Excel Lesson 4 - Formatting Cells and Ranges
clear
No color (________________________) is the default background.
Options
On Excel's ______________ page, you can change the default font used in all new workbooks.
Increase
To change the font, select the font that you want in the Font box. You can then change the size in the Font Size box or click _________________ Font Size or Decrease Font Size until the size you want is displayed in the Font Size box.
Titles Labels
To improve the overall design of a worksheet, the font size is usually enlarged for __________ and _________.
adjacent
The cells in a range can be _________________ or nonadjacent.
appearance
The commands in the Font, Alignment, and Number groups are used for basic formatting. Using only these groups, you can significantly change the ________________ of a worksheet.
appearance
The font determines the __________________ of the cell contents.
recently
The most _____________________ applied color appears on the Font Color button. To apply that color, make a selection and click Font Color. To apply a different text color, click the arrow next to Font Color.
match
The number of cells you select must _______________ the number of cells that you want to insert.
reverse
The principles for deleting cells are the same as those for inserting cells except that the direction the cells shift is ____________.
two select
Thus if you want to insert _________ cells, you must _________________ two cells.
palette
To add color and shading, select the cells to which you want to add special effects. The color _________________ you used to apply font color is also used for background color.
data
To apply formatting to text and values in an existing worksheet, you must first select the ___________.
blend
To apply the color shown on the Fill Color button, simply make a selection and click the button. To apply a different fill color, click the arrow next to Fill Color and apply either a theme color or a standard color. You can also click More Colors to open the Colors dialog box and custom ________________ colors.
insert
To insert blank cells in a worksheet, select the cell or the range of cells where you want to _________ the new blank cells.
override
You can use Alignment commands to change this default alignment or to _________________ previous alignment formatting.
special effects pictures
You can use a solid color or apply special effects, such as _______________________, textures, and _______________________.
alignment
You can use the Merge and Center command in the _______________________________ group to merge cells.
Delete
You can use the ______________command in the Cells group to delete cells, ranges, rows, or columns.
Number
___________________________________ formatting can be applied to cells before data is entered, or data can be selected and formatted after it has been entered.
font
A _______ is a set of text characteristics designed to appear a certain way.
character
A __________________________ can be a letter, number, punctuation mark, or symbol. Black is the default, or automatic, font color in Excel, but you can easily change text color.
merged cell
A _____________________________________ is created by combining two or more horizontally or vertically adjacent cells.
accurate
Applying ______________________ formatting to numeric data makes this information easier to interpret- and therefore more useful.
interest
Applying special characteristics to specific text or values adds ____________________ to a worksheet and calls attention to specific data.
decrease preciseness
After you choose a number format, you will need to further specify how you want the numbers to appear. You can use the commands in the Number group to apply formats and to increase or decrease the number of decimal places displayed in worksheet data. When you ____________________ the number of decimal places, the data becomes less precise because the numbers following the decimal point are rounded. This lack of _________________________________ is insignificant, however, when you are dealing with large numbers.
Insert Cells
Again, once the cells have been selected, click the arrow next to Insert, and then click ___________________. When the Insert dialog box opens, click the direction you want to shift the cells.
down
By default the option box has the shift cells ___________ option selected. The dialog box also allows you to insert a row or a column in a worksheet.
alphabetic left right
By default, when you enter _________________ characters or alphabetic characters combined with numbers or symbols, the cell content is ________-aligned, but when you enter numbers, the content is ___________-aligned.
left remain
Cells can be merged in a row or a column- but in either situation, the content of the upper-____________ cell will be centered in the merged cell. If the cells to be merged contain information that will be deleted in the merge, a dialog box opens to caution you that only the content of the upper-left cell will ________________ after the merge.
number
To change how numeric data appears, you can select one of the formatting options in the ___________________________ group on the Home tab, you can launch the Format Cells dialog box and click the Number tab.
enhances
Color __________________________ the visual appeal of a worksheet.
shared electronically catching
Excel provides many ways to format labels and values in a worksheet. In the business world, worksheets are usually printed or ___________ with others ___________________________. Therefore, you want your worksheet or workbook to be as eye-___________________________ and understandable as possible.
Points height
Font size is measured in points. Each time you click Decrease Font Size or Increase Font Size, the size changes by a set amount that matches the size options on the Font Size list. _____________ refer to the measurement of the _____________ of the characters in a cell. One point is equal to 1/72 inch.
appearance
Formatting changes the _________________________ of numbers; it does not change their value. The actual value is always displayed in the formula bar.
pound wider
If ____________________________ symbols (###) appear in a cell, it means that the numeric value entered is ___________________ than the cell.
shift right
If however you click the arrow next to Insert and select Insert Cells, the Insert dialog box opens and you can choose to _____________ cells to the ___________________.
after Existing
If you chose a different default font and/or font size, that font is used only in workbooks that you can create _________ you change the default and restart Excel. _________________ workbooks are not affected.
blank cell
If you click Insert in the Cells group, a _____________________ is inserted and by default the existing cells move down in the column.
adjusts
If you later change the column width, the text wrapping __________________ automatically.
multiple
If you want the text in a cell to appear on _______________________ lines, you can format the cell so that the text wraps automatically, or you can enter a manual line break.
attribute
In addition to changing font and font size, you can apply special attributes to a font that add visual appeal. An ___________________ is a formatting characteristic, such as bold, italic, or underlined text.
combining
Merging is a useful tool when _________________________ data from other sources. When you merge cells, the data that you want to appear in the merged cells will be the content from the upper-left cell of the selected range. Only the data in the upper-left cell will remain in the newly merged cell; data in the other cells included in the merge will be deleted.
numeric
Most of the data that you use in Excel is __________________________.
select multiple
Inserting and deleting items requires you first select these items in your worksheet and workbook. To __________ means to click in an area to make it active. You can also select ________________ areas by clicking, holding, and dragging to highlight a group of cells, rows, or columns.
Delete
Similar options apply to the _______________ command-here you can delete a cell, a row, a column, or an entire worksheet.
aligned
Text and numbers in a cell can be ____________ to the left, right, or center.
Home appearance
The _________ tab contains the formatting commands that you will use to enhance the _________________ of the worksheets that you create.
default
The ___________, or predefined, font for Excel 2010 is 11-point Calibri. This is an easy-to-read font that takes up less space than Arial, which was the default in earlier Excel versions.
double-click alt + enter
To start a new line of text at a specific point in a cell, ________________________________ the cell to place it in Edit mode, then click the location where you want to break the line and press ____________________________.
alignment
To wrap text automatically, select the text you want to format and click Wrap Text in the ________________________ group.
select
Too add color to the text in your worksheet, you must first __________________________ the cell, range of cells, text, or characters that you want to format with a different color.
Font
Use ___________ commands to change font and font size; to bold, italicize and underline data; and to add color, fill, and borders.
Alignment
Use _________________ commands to chose how data is aligned within cells.
Number
Use __________________ commands to apply a format to values and to increase or decrease the number of digits after a decimal.
clear understand focus data
Use a _______________, logical design plan that presents data in an easy-to-___________________________ format. Don't overuse special character attributes. The __________________ of your worksheet should be on the _________________ and the information it conveys.
fill color
Use the _____________________________ command in the Font group to change the background color of a cell. The most recently used fill color appears on the Fill Color button.
wrap breaks width
When a cell is formatted to _________________ text, any data in the cell automatically ____________________ to fit the column ______________________.
height
When text is wrapped, row _____________________ is also adjusted to accommodate the wrap.
arrow cells worksheet
When you click the __________ below the Insert command in the Cells group on the Ribbon, you can insert _______, rows, columns, or even a new _______________.
general value
When you enter a number in Excel, the default format is _____________________, which displays the data exactly as you enter it. If you include a special character such as $ or % when you enter a number, the special character will appear in the cell. The format does not affect the actual cell __________________.
highlighted Shading
When you make a selection, the cell or range is ____________________ on the screen. These highlights do not appear in a printout, however. If you want cells to be highlighted when you print a worksheet, you must use formatting features to apply _________________.
Quick Access Toolbar
When you right-click, the Mini toolbar displays above the shortcut menu. Just click any of the toolbar's available features to apply them to selected text. Unlike the ________________________________, which can be customized, you cannot customize the Mini toolbar. However, you can turn off the Mini toolbar in Excel Options.
ranges complete
When you select data, you identify the cell or range of cells in which you want to enter data or apply formatting. You can select cells, _______________, rows, columns, or the ___________________ worksheet.
mini toolbar
When you select text for formatting, you can also use the ______________________________________, shown in the figure below, to apply select formatting features. This unique formatting tool was new in Excel 2007 and has carried over to Excel 2010.
large columns rows
Where you merge cells, the selected cells become one _____________________ cell that spans multiple _________________ or __________________.
background
You can also apply a background color and add a pattern effect. Simply make a selection in the Pattern Style box (as shown below) to add a pattern to the ________________________ color.
background pattern
You can also call attention to cells by adding a ______________________ color and/or _______________________.
selected characters
You can also change the font for only a _______________ cell, a range of cells, or for _____________________ within text.
Editing contents
You can also place a cell in ___________ mode and select all or part of its contents.
more
You can choose a theme color or a standard color. You can also click __________________ to open the Colors dialog box, in which you can choose from additional standard colors or create colors to your own specifications.
Alignment Style Format attributes
You can improve the design of a worksheet in several ways: i. Change the ____________________________ ii. Change the font _________________ and enlarge the text for titles. iii. ___________________ titles and labels in bold and/or italics iv. Apply special formatting __________________
merged single not
You can split cells that have been ________________ into separate cells again, but you cannot split a ________________________ worksheet cell that has ___________ been merged.