15. After you have saved a template, you can access the template from the New screen in
____________________ view.
ANS: Backstage
REF: EX 380
ESSAY
1. Using multiple worksheets makes it easier to group and summarize data. Describe features that can be
applied by forming a worksheet group.
ANS:
By forming a worksheet group, you can:
• Enter or edit data and formulas. Changes made to content in the active worksheet are also made in
the same cells in all the worksheets in the group. You can also use the Find and Replace commands
with a worksheet group.
• Apply formatting. Changes made to formatting in the active worksheet are also made to all the
worksheets in the group, including changing row heights or column widths and applying conditional
formatting.
• Insert or delete rows and columns. Changes made to the worksheet structure in the active
worksheet are also made to all the worksheets in the group.
• Set the page layout options. Changes made to the page layout settings in one worksheet also apply
to all the worksheets in the group, such as changing the orientation, scaling to fit, and inserting headers
and footers.
• Apply view options. Changes made to the worksheet view such as zooming, showing and hiding
worksheets, and so forth are also made to all the worksheets in the group.
• Print all the worksheets. You can print all of the worksheets in the worksheet group at the same
time.
REF: EX 331 TOP: Critical Thinking
2. What are the steps to inserting a hyperlink and linking to: a file or Web page, a location in the current
workbook, a new document, and an e-mail address.
ANS:
• Select the text, graphic, or cell in which you want to insert the hyperlink.
• On the INSERT tab, in the Links group, click the Hyperlink button.
• To link to a file or webpage, click Existing File or Web Page in the Link to list, and then select the
file or webpage from the Look in box.
• To link to a location in the current workbook, click Place in This Document in the Link to list, and
then select the worksheet, cell, or range in the current workbook.
• To link to a new document, click Create New Document in the Link to list, and then specify the
filename and path of the new document.
• To link to an email address, click E-mail Address in the Link to list, and then enter the email address
of the recipient (such as
[email protected]) and a subject line for the message.
• Click the OK button.
REF: EX 370 TOP: Critical Thinking
3. What is an example of when you would use a template? Name at least three benefits of using a
workbook template.