Question 1

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

Accepted Answer

A)  Zoom selection 
B)  Fit selection 
C)  Magnification 
D)  Full screen 
A)  Zoom selection 
B)  Fit selection 
C)  Magnification 
D)  Full screen

Question 2

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

Accepted Answer

A)  white arrow 
B)  thick white plus sign 
C)  black arrow 
D)  thick black plus sign 
A)  white arrow 
B)  thick white plus sign 
C)  black arrow 
D)  thick black plus sign

Question 3

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

Accepted Answer

A)  Page Down key 
B)  Page Up key 
C)  Ctrl+End keys 
D)  Ctrl+Home keys 
A)  Page Down key 
B)  Page Up key 
C)  Ctrl+End keys 
D)  Ctrl+Home keys

Question 4

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

Accepted Answer

A)  left 
B)  right 
C)  either a. or b. 
D)  neither a. nor b. 
A)  left 
B)  right 
C)  either a. or b. 
D)  neither a. nor b.

Question 5

Saving a workbook means loading an existing workbook file from a disk into the program window.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: The worksheet that is displayed in the work area.
Identifies the cell, and is formed by combining the cell's column letter and row number.
The file used to store worksheets.
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
A computerized spreadsheet.

Accepted Answer

The Answer of Spreadsheet and Worksheet and Active worksheet and is...

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

Saving a workbook means loading an existing workbook file from a disk into the program window.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 5: Using Functions

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters

Exam 7: Excel Lesson 1: Microsoft Excel Basics

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

Saving a workbook means loading an existing workbook file from a disk into the program window.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 5: Using Functions

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters