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.