SMS221 Chapter Notes - Chapter 6: Taskbar, Dialog Box

• School: Seneca College
• Department: SMS
• Course: SMS221
• Professor: BLESSING AJIBOYE

Document Summary

Printing a worksheet group: same page layout settings apply to all worksheets in the group at the same time, all worksheets in the group can be printed at once. Linking workbooks: navigating multiple workbooks, to move between open workbooks: Use switch windows button in the window group on the view tab lists. Click excel program button on the taskbar, then click the thumbnail of the workbook. Linking workbooks: creating formulas with external references, a formula can include a reference to another workbook (external reference), which creates a set of linked workbooks. Updating linked workbooks: managing links, use edit links dialog box to manage links. Review the status of the links and update the data in the files. Source indicates the file that the link points to. Type identifies the type of each source file. Update specifies the way values are updated from the source file.