GO! with Microsoft Excel 2007, Gaskin - Complete test bank - exam questions - quizzes (updated 2022)

CHAPTER 1: CREATING A WORKSHEET AND CHARTING
DATA

Multiple Choice:


1. When you start the Excel program, a new blank ____________ displays.
1. workbook
2. document
3. database
4. presentation

Answer: A Reference: Objective 1: Create, Save, and Navigate an Excel Workbook

Difficulty: Easy

2. The intersection of a column and row is called a:
1. grid.
2. field.
3. cell.
4. box.

Answer: C Reference: Objective 1: Create, Save, and Navigate an Excel Workbook
Difficulty: Moderate

3. From the Save As dialog box, click ____________ to see a list of the available storage drives.
1. Create New Folder
2. the Save in arrow
3. the toolbar
4. the Desktop folder

Answer: B Reference: Objective 1: Create, Save, and Navigate an Excel Workbook
Difficulty: Challenging

,4. To specify ranges of cells that are nonadjacent, separate the ranges with a:
1. colon.
2. bracket.
3. comma.
4. semi-colon.

Answer: C Reference: Objective 1: Create, Save, and Navigate an Excel Workbook
Difficulty: Moderate



5. By default, text in Excel is ____________.
1. left aligned
2. center aligned
3. right aligned
4. justified

Answer: A Reference: Objective 2: Enter and Edit Data in a Worksheet Difficulty:
Easy

6. The ____________ feature can generate a series of values into adjacent cells based on the
value of other cells.
1. AutoCorrect
2. AutoComplete
3. AutoFormat
4. Auto Fill

Answer: D Reference: Objective 2: Enter and Edit Data in a Worksheet Difficulty:
Moderate

7. From anywhere in the worksheet, you can press ____________ to move to cell A1.
1. [Ctrl] + [Enter]
2. [Ctrl] + [Home]
3. [Ctrl] + [Shift]
4. [Ctrl] + [Tab]

Answer: B Reference: Objective 2: Enter and Edit Data in a Worksheet Difficulty:
Moderate

,8. New rows are inserted ____________ the selected row and existing rows shift accordingly.
1. to the left of
2. to the right of
3. above
4. below

Answer: C Reference: Objective 2: Enter and Edit Data in a Worksheet Difficulty:
Challenging

9. Press ____________ to move the active cell one position to the right.
1. Enter
2. Shift + Enter
3. Tab
4. Shift + Tab

Answer: C Reference: 2: Enter and Edit Data in a Worksheet Difficulty:
Moderate

10. Excel’s prewritten formulas are called:
1. calculations.
2. functions.
3. commands.
4. summations.

Answer: B Reference: Objective 3: Construct and Copy Formulas, Use the Sum
Function, and Edit Cells Difficulty: Moderate

11. All formulas begin with the ____________ sign.
1. + (plus)
2. – (minus)
3. = (equal)
4. * (asterisk)

Answer: C Reference: Objective 3: Construct and Copy Formulas, Use the Sum
Function, and Edit Cells Difficulty: Moderate

, 12. The keyboard shortcut for the AutoSum feature is:
1. [Alt] + [=]
2. [Shift] + [=]
3. [Ctrl] + [=]
4. [Tab] + [=]

Answer: A Reference: Objective 3: Construct and Copy Formulas, Use the Sum
Function, and Edit Cells Difficulty: Challenging

13. By default, when numerical data is selected, which of the following calculations do NOT
display in the status bar?
1. Average
2. Count
3. Sum
4. Product

Answer: D Reference: Objective 3: Construct and Copy Formulas, Use the Sum
Function, and Edit Cells Difficulty: Moderate

14. ____________ is the process of changing the appearance of cells and the overall layout of
the worksheet.
1. Justifying
2. Printing
3. Editing
4. Formatting

Answer: D Reference: Objective 4: Format Data, Cells, and Worksheets Difficulty:
Easy

15. The default format for a number typed into Excel is the ____________ format.
1. Accounting
2. Currency
3. General
4. Number

Answer: C Reference: Objective 4: Format Data, Cells, and Worksheets Difficulty:
Moderate