Computacion Word Excel

Introduction to Excel
What Can I Do with a Spreadsheet?

bjectives
After you read this chapter you will be able to:
1. Define worksheets and workbooks (page 314). 2. Use spreadsheets across disciplines (page 314). 3. Plan for good workbook and worksheet design (page 315). 4. Identify Excel window components (page 317). 5. Enter and edit data in cells (page 322). 6. Describe and use symbolsand the order of precedence (page 328). 7. Display cell formulas (page 330). 8. Insert and delete rows and columns (page 331). 9. Use cell ranges; Excel move; copy, paste, paste special; and AutoFill (page 332). 10. Manage worksheets (page 340). 11. Format worksheets (page 341). 12. Select page setup options for printing (page 353). 13. Manage cell comments (page 356).

Excel 2007

311Exploring Microsoft®Office 2007 Computer Concepts:Getting Started, by Robert T.Grauer and Lynn Hogan.Published by Prentice Hall.Copyright ©2008 by Pearson Education, Inc.

CASE STUDY
Weddings by Grace
Grace Galia is a wedding consultant who specializes in all aspects of wedding planning for her clients. Although more and more couples are striving to cut costs by handling most of the planning ontheir own, Grace is successfully growing her business based on a proven history of superbly run events resulting in many happy newlyweds. She offers her clients a complete wedding package that includes the cocktail hour, dinner, and beverage (including alcohol). The client chooses the type of dinner (e.g., chicken, salmon, filet mignon, or some combination), which determines the cost per guest,and specifies the number of guests, and then the cost of the reception is obtained by simple multiplication. Grace provides a detailed budget to all of her clients that divides the cost of a wedding into three major categories—the ceremony, the reception (based on the package selected), and other items such as music and photography. She asks each client for their total budget, and then worksclosely with the client to allocate that amount over the myriad items that will be necessary. Grace promises to take the stress out of planning, and she advertises a turnkey operation, from invitations to thank-you notes. She assures her clients that their needs will be met without the clients overextending themselves financially. Grace has asked you, her manager trainee, to complete her worksheetcomparing the two wedding plans she offers her clients.

Case Study

Your Assignment
• Read the chapter carefully, focusing on spreadsheet formulas and basic spreadsheet commands. • Open chap1_case_wedding, which contains the partially completed worksheet, and save it as chap1_case_wedding_solution. • Insert formulas to calculate the cost of the reception in both options. • Use appropriateformulas to calculate the difference in cost for each item in the two options. • Copy the total formula to the difference column. • Format cells as currency with no decimals. Widen or narrow columns as necessary to conform to good design principles. • Emphasize totals with borders and separate the categories with a complimentary fill color. • Merge and center rows 1 and 2 so the headings arecentered over the worksheet. Change the font, font color, and font size to match your design. • Insert an appropriate image in the space indicated. You may have to resize to fit. • Emphasize the category headings. • Add your name and today’s date to the worksheet. • Choose the options you need to set from the Page Setup dialog box.

312

CHAPTER 1

| Introduction to Excel

ExploringMicrosoft®Office 2007 Computer Concepts:Getting Started, by Robert T.Grauer and Lynn Hogan.Published by Prentice Hall.Copyright ©2008 by Pearson Education, Inc.

Introduction to Spreadsheets
A spreadsheet, the computerized equivalent of a ledger, contains rows and columns of data. A spreadsheet program is a computer application designed to build and manipulate spreadsheets.

After word processing, a...