1 excel core objective 1: managing the worksheet environment microsoft office 2010 certification...
TRANSCRIPT
![Page 1: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/1.jpg)
1
Excel Core Objective 1: Managing the Worksheet Environment
Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice
Story/Walls
![Page 2: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/2.jpg)
Navigate Through a Worksheet
Mouse and Shortcut Methods: Use hot keys Use the name box
Story/Walls MOS 2010 Excel Core Objective 1 22
![Page 3: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/3.jpg)
Print a Worksheet or Workbook
Ribbon Method: Print only
selected worksheets
Print an entire workbook
Story/Walls MOS 2010 Excel Core Objective 1 33
![Page 4: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/4.jpg)
Print a Worksheet or Workbook (cont.)
Ribbon Method: Construct headers and footers Scale worksheet printouts
Story/Walls MOS 2010 Excel Core Objective 1 44
![Page 5: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/5.jpg)
Print a Worksheet or Workbook (cont.)
Ribbon Method: Print titles Set up the
worksheet page for printing
Set a print prea Print gridlines
Story/Walls MOS 2010 Excel Core Objective 1 55
![Page 6: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/6.jpg)
Story/Walls MOS 2010 Excel Core Objective 1 6
Personalize the Environment by Using Backstage
Ribbon Methods: Manipulate the
Quick Access Toolbar
6
![Page 7: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/7.jpg)
Story/Walls MOS 2010 Excel Core Objective 1 7
Personalize the Environment by Using Backstage (cont.)
Ribbon Methods: Customize a tab Customize a
group
7
![Page 8: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/8.jpg)
Story/Walls MOS 2010 Excel Core Objective 1 8
Personalize the Environment by Using Backstage (cont.)
Ribbon Methods: Manipulate Excel
default settings (Excel options)
Manipulate workbook properties (Document panel)
8
![Page 9: 1 Excel Core Objective 1: Managing the Worksheet Environment Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649ca65503460f949676f6/html5/thumbnails/9.jpg)
Personalize the Environment by Using Backstage (cont.)
Ribbon Methods: Manage versions AutoSave
Story/Walls MOS 2010 Excel Core Objective 1 99