Excel Ch 3

Size

A the Format cells dialog box with the Font tab selected, you can choose a font size in the _ list box.

Top and Bottom

At the Format Cells dialog box with the Border tab selected, the Presets section contains all the following options except

Column

By default, a(n) _ is inserted immediately to the left of the column containing the active cell.

the Mini toolbar

Double-clicking in a cell and then selecting the data within it will display which of the following?

Points

Excel measures row height in

Setting the column widths to 0

In addition to using the Hide Columns option, you can hide columns by doing which of the following?

Theme

In excel , a _ is a set of formatting choices that includes colors, fonts, and effects.

Ampersand (&)

In the Number group on the Home tab, the format symbols available for formatting numbers include all the following except the

Entire worksheet

The Delete dialog box contains al the following options except

the type of data entered

The alignment of the dat in cells depends on which of the following?

Text control

The text typed into a cell will overlap the next cell if it is too long. To wrap text to the next line within a cell, insert a check mark in the Wrap text check box in the _ section of the Format cells dialog box.

Fill Effects button

To add shading to a cell, click the _ on the Fill tab at the Format cells dialog box.

Format Painter

To apply formatting to several locations in a worksheet, double-click the _ button, select the desired cells, and then click the button again to turn off the feature.

boundary lines

To change the width of adjacent columns at the same time, select the columns and then drag on of the column _ within the selected columns.

Format

To display the Column Width dialog box, begin by clicking the _ button in the cells group on the Home tab.

Column Width

Use the _ measurement box in the column width dialog box to specify a column width number

Scientific

Use the _ number formatting option for very large and very small numbers.

Ctrl + Y; F4

When applying formatting to the cells in a worksheet, you can repeat the last action by pressing the keyboard shortcut _ or the _ function key.

double-headed arrow pointing up and down

You can change the height of a row by positioning the cell pointer on the boundary between rows until it displays as a _, clicking and holding down the left mouse button, and then dragging up or down o the desired height.

Live Preview

use the _ feature to display the worksheet with the theme formatting applied.

General

At the Format Cells dialog box, what is the default number format category?

Alt + Enter

To enter dat on more than one line within a cell, press _ to the move to the next line.

row below where the new row is to be inserted

To insert in a worksheet, select the _ and then click the insert button in the cells group.

Insert Sheet Columns

To insert more than one column, select the number of columns to be inserted in the worksheet, click the insert button arrow, and then click

Selecting the rows above and below the hidden row

To make a hidden row visible, start by

the desired formatting

To use the Format Painter feature, begin by making active a cell or selected cells that contain

Orientation

Click the _ button to choose an option for rotating data in a cell.

The light-gray boundary line in the column or row header will display as a slightly thicker gray line.

How can you tell if a worksheet contains hidden columns or rows?

Contents

Pressing the Delete key deletes the _ of the active cell.

More Borders

To display the Format Cells dialog box, click the Borders button arrow in the Font group and then click _ at the drop-down list.

Accounting

Which of the following number formatting options adds a dollar symbol and two digits after the decimal point and also lines up the currency symbols and decimal points?

Merge Cells

Which of the following options allows you to to combine selected cells?

add a new column

You can use buttons and options in the Font group to do all thhe following except

Either before or after the numbers are entered in to the cells

When can the formatting for numbers in cells be specified?

the average number of characters in the standard font that can fit in a cell

When you drag a column boundary, a box displaying a number appears above the mouse pointer. What does the number in this box represent?

All the references adjust automatically

When you insert rows or columns in a worksheet, what happens to the cell references that are affected by the insertion?

Rotate the text

Which of the following is not an option at the Format Cells dialog box with the Font tab selected?