Excel - Chapter 1: Key Terms and Multiple Choice

Formula

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

Workbook

A file containing related worksheets.

Value

A number that represents a quantity or an amount.

Output Area

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

Input Area

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

Range

A rectangular group of cells.

Fill Handle

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

Worksheet

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

Formula Bar

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

Sheet Tab

Displays the name of a worksheet within a workbook.

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.

Wrap Text

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

Name Box

Identifies the address of the current cell.

Text

Includes letters, numbers, symbols, and spaces.

Order of Operations

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

Fill Color

The background color appearing behind data in a cell.

Column Width

The horizontal measurement of a column.

Cell

The intersection of a column and a row.

Alignment

The position of data between the cell margins.

Row Height

The vertical measurement of a row.

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 b. Decrease the Scale value c. Decrease column widths d. Decrease the font size

a

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) b. =A2*(B2-1) c. =A2*B2-1 d. =A2*1-B2

a

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? a. Souvenir Shop is centered over the range A1:E1, and April Sales Report is moved to cell F1. b. Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted. c. Excel does not let you merge and center a range of cells where those cells each contain data. d. Souvenir Shop is combined with April Sales Report. The new combined label is then centered over the range A1:E1.

b

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? a. A copy of the March sheet is inserted to the right of the original March sheet. The new sheet is named April automatically. b. The March sheet is moved to the left of the first sheet tab. The worksheet is not copied. c. A copy of the March sheet is inserted to the left of the original March sheet. The new sheet is named March (1). d. The March sheet is moved to a new workbook named Book1. The March sheet no longer exists in the original workbook.

b

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? a. Your colleague forgot to use Auto Fill to fill in the rest of the month names. b. Your colleague selected all worksheets before using the Print option. c. Your colleague entered January in the header rather than inserting the Sheet Name field. d. Your colleague included all worksheets in one workbook rather than creating a separate workbook for each month.

c

What should you do if you see pound signs (###) instead of values or results of formulas? a. Increase the zoom percentage. b. Delete the column. c. Increase the column width. d. Adjust the row height.

c

When is Auto Fill appropriate to use? a. To copy formulas from one worksheet to another b. To enter the days of the week down a column c. To fill in a data pattern in one column based on data in an adjoining column d. To apply a background color for column headings in a worksheet

c

Cell C6 contains the value 1.2546. How does the value display if you format the cell with Percent Style with 1 decimal place? a. 1.2% b. 1.25% c. 125.4% d. 125.5%

d

Which situation is the most logical for using the Go To command? a. Cell B2 is the active cell, and you want to go to cell A2. b. Cell C15 is the active cell, and you want to go to cell C14. c. Cell F15 is the active cell, and you want to go to cell G15. d. Cell D10 is the active cell, and you want to go to cell D50.

d

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? a. Click in cell B1 and click Paste. b. Click in any cell in column B and insert a new column. c. Click the column B heading, press Delete, and then paste the data. d. Right-click the column B heading and select Insert Cut Cells.

d