Excel Lesson 2

____ determines the best width for a column or the best height for a row, based on its contents.

AutoFit

T/F Numbers that do not fit in the cell are shown as a series of question marks (??????).

False

T/F To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

False, Normal in the Good

T/F A format is the design of text.

False, font

T/F To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the 'Background' Color button arrow.

False, font color

T/f Number fills change the way data looks in a cell.

False, formats

T/F The Cell Styles 'library' includes many predefined styles.

False, gallery

T/F You can use the Format Painter to copy formatting only to adjacent cells or ranges.

False, nonadjacent

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.

Font

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

Home

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

border

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

bottom-left

If you want to specify a precise column width, use the Column Width ____.

dialog box

The default ____________________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

fill

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

right

Excel ____ all numbers.

right-aligns

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

shifted to the right

A ____ is a preset collection of design elements, including fonts, colors, and other effects.

theme

Horizontal alignments do NOT include ____.

top, middle, or bottom

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

truncated

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

upper left

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.

Ctrl+1

Press the ____ keys to apply underlining.

Ctrl+U

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

Currency

As you format cells, ____ shows the results of the different formatting options you can choose.

Live Preview

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.

Merge & Center

You can remove the borders from a selected cell by clicking ____ in the border style menu.

No Border

By default, the ____ theme is applied to each workbook.

Office

To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the Home tab of the Ribbon.

Orientation

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

Page Layout

T/F At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

True

T/F Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

True

T/F Press the Ctrl+B keys to apply bold.

True

T/F Standard accounting format uses a single border below a column of numbers and a double border below the' total.'

True

T/F Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

True

T/F The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

True

T/F The default number format is General, which displays numbers the way you type them.

True

T/F To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

True