Graphics & Visualization Chapter 6 Homework This feature gives you the ability to organize your data better

Unlock access to all the studying documents.

View Full Document

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 1 of 6

Microsoft Excel 2016

Module 6: Managing Multiple Worksheets and Workbooks

A Guide to this Instructor’s Manual:

We have designed this Instructor’s Manual to supplement and enhance your teaching experience through

classroom activities and a cohesive module summary.

In addition to this Instructor’s Manual, our Instructor’s Resources also contains PowerPoint Presentations,

Test Banks, and other supplements to aid in your teaching experience.

Table of Contents

Module Objectives

Grouping Worksheets

Printing a Worksheet Group

Linking Workbooks

Updating Linked Workbooks

Module Objectives

Students will have mastered the material in this module when they can:

• Create a worksheet group

• Create a link to data in another workbook

Grouping Worksheets

LECTURE NOTES

• Demonstrate how to group worksheets.

• Explain how to enter headings and formulas in a worksheet group.

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 2 of 6

TEACHER TIP

A workbook is a collection of worksheets. Sometimes students will want to work with the worksheets

within a workbook as if they were a single unit. Worksheets can be combined together into a group.

Grouping worksheets allows students to apply formulas across the worksheets in the group. Students can

also apply formatting across worksheets in a group. This can allow them to work more efficiently by

allowing them to make multiple changes through a single change.

CLASSROOM ACTIVITIES

Quick Quiz:

1. True/False. When you edit cells in a worksheet group, the changes you make to one worksheet

are automatically applied to the other worksheets in the group. (Answer: True)

Working with Multiple Worksheets

LECTURE NOTES

• Demonstrate how to copy worksheets.

TEACHER TIP

A workbook can contain one or several worksheets. This feature gives you the ability to organize your data

better. Many times a workbook has a massive amount of data. By dividing that data up into worksheets it is

much more manageable and accessible. Often times, a worksheet at the front of the workbook will

summarize the data on the rest of the worksheets. This provides an opportunity to view summarized data

without having to look at the rest of the data unless you want to.

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 3 of 6

Sheet3!A5 is a reference to cell A5 on Sheet3. Students could place the reference in any cell on any

worksheet within the workbook.

TEACHER TIP

In a workbook, students often have several worksheets that represent the same kind of data but for different

entities. It may be beneficial for them to summarize the data onto one worksheet, or consolidate the data.

When students consolidate worksheets, each worksheet must have the same format and structure. Students

CLASSROOM ACTIVITIES

Quick Quiz:

1. What is the first step in copying worksheets to another workbook? (Answer: select the sheet

tabs you want to copy)

2. True/False. The fastest way to copy an entire worksheet to press and hold the Alt key as you

drag and drop the sheet tab. (Answer: False)

Printing a Worksheet Group

LECTURE NOTES

• Demonstrate how to print a worksheet group.

CLASSROOM ACTIVITIES

Quick Quiz:

Linking Workbooks

LECTURE NOTES

• Demonstrate how to link and unlink files.

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 4 of 6

• Show how to navigate and arrange multiple workbooks.

• Explain how to create formulas with external references.

CLASSROOM ACTIVITIES

Quick Quiz:

1. A(n) _______is a connection between the files that allows data to be transferred from one file to

the other. (Answer: link)

Updating Linked Workbooks

LECTURE NOTES

• Demonstrate how to update a destination workbook with source workbooks open.

• Explain how to update a destination workbook with source workbooks closed.

• Show how to manage links.

TEACHER TIP

Remind students of the importance that the data in the destination file accurately reflect the contents of the

CLASSROOM ACTIVITIES

Critical Thinking: Imagine a company that has salespersons throughout the country who record all their

sales data in a workbook. If you are the sales manager, how could you use the concepts in this

module to “pull it all together” so that you have summarized data from the individual workbooks?

Do you think it would be best to pull all the data from the individual workbooks into a single

workbook? Or do you think it would be better to keep the data in separate workbooks and then pull

the summary information into a single workbook? Why do you come to this conclusion?

Creating a Hyperlink

LECTURE NOTES

• Demonstrate how to insert a hyperlink.

• Show how to edit a hyperlink.

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 5 of 6

TEACHER TIP

A hyperlink is a link to information within that file or another file. The hyperlinks are usually represented

PowerPoint presentation, or sites on the Web.

CLASSROOM ACTIVITIES

Quick Quiz:

1. A(n) _______ is a link in a file. (Answer: hyperlink)

2. True/False. To use a hyperlink, you click anywhere inside the cell that contains the link.

(Answer: False)

Using Templates

LECTURE NOTES

• Demonstrate how to create a workbook based on an existing template.

TEACHER TIP

In business, people often create workbooks that have common elements such as invoices, an expense

statement, a balance sheet, or many other day-to-day operations workbooks. Using a template makes this

process much easier because the elements are already in place and all students do is fill them in.

CLASSROOM ACTIVITIES

Quick Quiz:

1. The _______ workbook template, that is used to create new, blank workbooks, contains no

text or formulas, but it includes formatting. (Answer: Blank)

LAB ACTIVITY

Divide the class into as many groups as there are categories of templates (this could vary depending on

what templates are available on your system). Have each group open one of the template categories and

select a template. When they open the template, have the groups discuss a situation where they might

New Perspectives on Microsoft Excel 2016 Instructor’s Manual 6 of 6

• Case Problems: A typical NP module has four Case Problems following the Review Assignments. Short

modules can have fewer Case Problems (or none at all); other modules may have five Case Problems.

The Case Problems provide further hands-on assessment of the skills and topics presented in the

module, but with new case scenarios. There are five types of Case Problems:

• Apply. In this type of Case Problem, students apply the skills that they have learned in the module to

solve a new problem.

• Create. In a Create Case Problem, students are either shown the end result (such as a finished Word

document) and asked to create the document based on the figure provided, or, students are asked to

create something from scratch in a more free-form manner.