Complete Guide to
Excel 365: Linking,
Printing, & Protecting
Workbooks
Which sequences of menu actions can be used to adjust the print
settings of a document?
File >> Print
What will happen when we try to create an Auto Outline without any
discernible structure to our data?
Excel will give us an error that it "Can not create an Outline"
Which sequences of menu actions can be used to ensure that all the
cells in a sheet except a specific range are protected?
First Review >> Protect Sheet; then, separately Review >> Allow
Edit Ranges
Say workbook A has data linked to another workbook B. Now, if the
linked data from workbook B is copy-pasted into another workbook
C, which data will workbook C be linked to?
Workbook B
Say workbook A has data linked to another workbook B. Both
workbooks A and B are open. Now if the data in workbook A is
edited, how will it affect the linked data in workbook B?
The cell in workbook B will change accordingly to reflect the
changes to workbook A
If there is an image in an Excel workbook that we do not want to be
printed, how can we ensure that it is not?
Click >> Format Picture (on the left side of the sheet) uncheck
"Print Object"
, If there is an unlocked cell in a protected sheet, how will it differ
from other cells within that sheet?
The user will be able to edit that cell without entering a password
Which sequences of menu actions can be used to save a
spreadsheet as an Excel Template?
File >> Save As >> Change the type of the document to .xltx >>
Browse >> Documents/Custom Office Template
Which sequences of menu actions can be used to recover unsaved
workbooks after a crash?
New Excel Workbook >> File >> Manage Workbooks >> Recover
Unsaved Workbooks
AutoFit
A feature that automatically adjusts the width and height of a
column, row, cell, or header.
Cell Borders
Draws an outline around a cell or group of cells.
Cell Styles
Predefined formatting options that can be applied to cells or groups
of cells.
Fill Color
The color of the cell background. By default, there is no fill color.
Merge and Center
Combines selected cells into one large cell, then centers the
content.
Number Formatting
Excel 365: Linking,
Printing, & Protecting
Workbooks
Which sequences of menu actions can be used to adjust the print
settings of a document?
File >> Print
What will happen when we try to create an Auto Outline without any
discernible structure to our data?
Excel will give us an error that it "Can not create an Outline"
Which sequences of menu actions can be used to ensure that all the
cells in a sheet except a specific range are protected?
First Review >> Protect Sheet; then, separately Review >> Allow
Edit Ranges
Say workbook A has data linked to another workbook B. Now, if the
linked data from workbook B is copy-pasted into another workbook
C, which data will workbook C be linked to?
Workbook B
Say workbook A has data linked to another workbook B. Both
workbooks A and B are open. Now if the data in workbook A is
edited, how will it affect the linked data in workbook B?
The cell in workbook B will change accordingly to reflect the
changes to workbook A
If there is an image in an Excel workbook that we do not want to be
printed, how can we ensure that it is not?
Click >> Format Picture (on the left side of the sheet) uncheck
"Print Object"
, If there is an unlocked cell in a protected sheet, how will it differ
from other cells within that sheet?
The user will be able to edit that cell without entering a password
Which sequences of menu actions can be used to save a
spreadsheet as an Excel Template?
File >> Save As >> Change the type of the document to .xltx >>
Browse >> Documents/Custom Office Template
Which sequences of menu actions can be used to recover unsaved
workbooks after a crash?
New Excel Workbook >> File >> Manage Workbooks >> Recover
Unsaved Workbooks
AutoFit
A feature that automatically adjusts the width and height of a
column, row, cell, or header.
Cell Borders
Draws an outline around a cell or group of cells.
Cell Styles
Predefined formatting options that can be applied to cells or groups
of cells.
Fill Color
The color of the cell background. By default, there is no fill color.
Merge and Center
Combines selected cells into one large cell, then centers the
content.
Number Formatting
