Excel - Chapter 1: Key Terms and Multiple Choice

Alignment

The position of data between the cell margins.

Auto Fill

Enables you to copy the contents of a cell or cell range or to continue a sequence by using the fill handle over an adjacent cell or range of cells.

Cell

The intersection of a column and a row.

Column Width

The horizontal measurement of a column.

Fill Color

The background color appearing behind data in a cell.

Fill Handle

A small green square at the bottom-right corner of a cell.

Formula

A combination of cell references, operators, values, and/or functions used to perform a calculation.

Formula Bar

Displays the content (text, value, date, or formula) in the active cell.

Input Area

A range of cells containing values for variables used in formulas.

Name Box

Identifies the address of the current cell.

Order of Operations

Rules that control the sequence in which Excel performs arithmetic operations.

Output Area

A range of cells containing results based on manipulating the variables.

Range

A rectangular group of cells.

Row Height

The vertical measurement of a row.

Sheet Tab

Displays the name of a worksheet within a workbook.

Text

Includes letters, numbers, symbols, and spaces.

Value

A number that represents a quantity or an amount.

Workbook

A file containing related worksheets.

Worksheet

A spreadsheet that contains formulas, functions, values, text, and visual aids.

Wrap Text

Formatting that enables a label to appear on multiple lines within the current cell.

Which situation is the most logical for using the Go To command?

d. Cell D10 is the active cell, and you want to go to cell D50.

When is Auto Fill appropriate to use?

c. To fill in a data pattern in one column based on data in an adjoining column

Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%. Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which of the following formulas produces the same result?

a. =A2-(A2*B2)

What should you do if you see pound signs (###) instead of values or results of formulas?

c. Increase the column width.

You just selected and cut column D. Now you want to move it to be located before data in column B. What should you do next?

d. Right-click the column B heading and select Insert Cut Cells.

The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. What happens when you select the range A1:E1 and click Merge & Center?

b. Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.

Cell C6 contains the value 1.2546. How does the value display if you format the cell with Percent Style with 1 decimal place?

d. 125.5%

You want to copy the March worksheet to use it to enter data for April. After you right-click the March sheet tab and select Move or Copy, you click OK in the Move or Copy dialog box without changing any settings. What happens?

b.  The March sheet is moved to the left of the first sheet tab. The worksheet is not copied.

A colleague emailed an Excel workbook that contains monthly sales data with each month on a separately named worksheet tab. When you print the workbook, the header always prints January. What caused this problem in which the other monthly worksheet printouts do not display the correct worksheet name in the header?

c. Your colleague entered January in the header rather than inserting the Sheet Name field.

Assume that the data on a worksheet consume a whole printed page and two columns on a second page. You can do all of the following except what to force the data to print all on one page?

a. Increase the left and right margins