MCAS Office 2007 Exam Prep: Exams for Microsoft Office 2007

Part III: MCAS 77-602: Using Microsoft Office Excel 2007

Chapter TenCreating and Manipulating Data

Objectives

This chapter helps you prepare for the MCAS: Using Microsoft Office Excel 2007, Exam 77-602, by covering the following Microsoft objectives:

• Save workbooks.

• Insert data by using AutoFill.

• Ensure data integrity.

• Change worksheet views.

Outline

Introduction	262
The Excel 2007 Ribbon	262
Creating and Saving a New Excel 2007 Workbook	264
Creating a New Excel 2007 Workbook	264
Creating a New Blank Workbook	264
Changing the Default Configuration of a Blank Workbook	265
Creating a New Workbook from a Template	266
Saving an Excel 2007 Workbook	266
Entering Data Using AutoFill	267
Using the AutoFill Handle	267 ...