Name:     ID: 
 
Email: 

Microsoft Excel Lesson 7

True/False
Indicate whether the statement is true or false.
 

 1. 

A worksheet is a collection of workbooks.
 

 2. 

The active sheet has a blue sheet tab.
 

 3. 

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.
 

 4. 

Each workbook opens with five worksheets.
 

 5. 

Deleting does not permanently remove a worksheet and all its contents from the workbook.
 

 6. 

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.
 

 7. 

Moving a worksheet does not affect 3-D references in the workbook.
 

 8. 

The formula =SUM(Sheet2:Sheet4!D12), adds the value from cell D12 in the Sheet2, Sheet3, and Sheet4 worksheets.
 

 9. 

To print all of the worksheets in the workbook, click Print Entire Workbook print option.
 

 10. 

You designate the portion of the workbook to print on the Area tab in Backstage view.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 11. 

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.
a.
worksheets
c.
cells
b.
workbooks
d.
ranges
 

 12. 

You can reposition a worksheet by dragging its ____ to a new location.
a.
sheet tab
c.
file name
b.
cells
d.
right border
 

 13. 

You can create a copy of a worksheet by pressing the ____ key as you drag and drop its sheet tab.
a.
Ctrl
c.
F3
b.
Tab
d.
Enter
 

 14. 

To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.
a.
Insert
c.
Worksheet
b.
Sheet
d.
Insert Sheet
 

 15. 

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.
a.
period
c.
comma
b.
colon
d.
semicolon
 

 16. 

When working with cell references, any change you make to the ____ cell also changes the value in the destination cell.
a.
source
c.
main
b.
primary
d.
active
 

 17. 

The Print option called Print ____ prints the range or ranges selected within a single worksheet.
a.
Active Sheets
c.
Entire Workbook
b.
Selection
d.
Range
 

 18. 

The Print option called Print ____ prints the worksheet that appears on-screen, or a group of selected worksheets.
a.
Active Sheets
c.
Entire Workbook
b.
Selection
d.
Entire Worksheet
 

 19. 

When using the Arrange Windows dialog box, the ____ layout is NOT an option.
a.
Tiled
c.
Cascade
b.
Vertical
d.
Split
 

 20. 

To make a workbook active, just click ____.
a.
its title bar
c.
either a. or b.
b.
anywhere in the worksheet
d.
neither a. nor b.
 

 21. 

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.
a.
Move or Copy
c.
New
b.
Relocate
d.
Location
 

 22. 

When the Move or Copy dialog box appears, click the To book arrow and click the workbook where you want to move or copy the selected worksheet. After you select the destination workbook, the names of all of its worksheets appear in the ____ sheet box.
a.
To book
c.
Before
b.
From book
d.
After
 
 
FIGURE EX 7-1

nar001-1.jpg
 

 23. 

The area indicated by #2 in Figure EX 7-1 above is ____.
a.
Sheet tabs for the inactive worksheets
c.
Tab scrolling buttons
b.
Sheet tabs for the active worksheets
d.
Custom sheet tabs
 

 24. 

The area indicated by #3 in Figure EX 7-1 above is ____.
a.
Sheet tabs for the inactive worksheets
c.
Tab scrolling buttons
b.
Sheet tabs for the active worksheets
d.
Custom sheet buttons
 
 
Case EX 7-2
Ron wants to be able to distinguish one worksheet from another.  He plans to rename the worksheets and change the color of the tabs.
 

 25. 

How does Ron go about renaming his worksheet?
a.
Right-click its sheet tab, and then click Rename on the shortcut menu
b.
Double-click its sheet tab, type the new name, and then press the Enter key
c.
Either a. or b.
d.
Neither a. nor b.
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Active sheet
b.
Source
c.
Sheet tab
d.
Worksheet range
e.
Destination
 

 26. 

Identifies the worksheets within the workbook.
 

 27. 

The worksheet that appears in the workbook window.
 

 28. 

The location where the data will appear after it is transferred.
 

 29. 

The location the data is being transferred from.
 

 30. 

A group of adjacent worksheets.
 



 
         Start Over