NP Excel 2016
Module 06
Quick Check Answers
Session 6.1
2. To select an adjacent group of worksheets, click the first sheet tab, press and hold the
Shift key, and then click the sheet tab of the last worksheet in the range. To select a
3. =’Quarter 2′!C8
5. the average value found in cell B1 in all of the worksheets from Sheet1 to Sheet4
7. =SUM(Sheet1:Sheet4!B1)
8. Select a worksheet group that consists of all the sheets in the workbook, click the Page
Session 6.2
2. A source file is the file that contains the data values to which you want to link.
4. tiled, horizontal, vertical, and cascade
6. If the source file is closed when you open the destination file, a dialog box opens and you
7. On the Data tab, in the Connections group, click the Edit Links button to open the Edit
Links dialog box. The linked workbooks are listed in the dialog box.
8. After you break the links in a worksheet, all external reference formulas are converted to
their most recent values.
Session 6.3
1. Click the cell in which you want to insert the hyperlink. On the Insert tab, in the Links
3. A template is a workbook that contains specific content and formatting that you can use
as a model for other similar workbooks.
5. A user can modify the contents of a workbook based on a template without changing the
template file itself. The next time a new workbook is created based on a template, the
6. Family Monthly Planner, Inventory List, Team Roster, Time Sheets and Expense Reports
7. On the ribbon, click the File tab to open Backstage view, click Save As in the navigation
bar, and then click the Browse button. The Save As dialog box opens. Click the Save as
8. If you store a template in a location other than the Custom Office Templates folder, click