ee1-p8challenge

ee1-p8challenge -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 013725f4d37ef272814ef1aa524fffeb6b2dea19.xls Overview 05/07/2009 Project 8 Challenges: Developing a Multiple-Sheet Workbook What would you like to do? Skill Sheet 1. Subtotal data using the Average function #1-AvgSubtotal 2. Apply two conditional formats to a cell #2-TwoCondFormat 3. Insert sheets and edit the new sheets simultaneously #3-InsertGroup 4. Create a chart sheet and save it as a Web page #4-Chart Challenge exercises expand on or are somewhat related to skills presented in Essentials lessons. If you have problems, use on-screen Help. A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 013725f4d37ef272814ef1aa524fffeb6b2dea19.xls #1-AvgSubtotal 05/07/2009 Project 8 Challenge: Subtotaling Data Using the Average Function Residential Real Estate Listings Listed Price Area Address Bed Bath Heat Built Pool 23-Jan 98,200 Autumn Woods 6370 Elm Street 3 1.5 Gas 1994 N 12-Mar 85,500 Autumn Woods 6415 Elm Street 2 1.5 Gas 1995 N 1-Mar 74,500 Autumn Woods 6250 Maple Street 2 1.5 Gas 1995 N 6-Feb 79,600 Autumn Woods 3212 Popler Circle Drive 2 2 Gas 1995 N 84,450 Autumn Woods Average 13-Mar 85,600 Cape Cod Village 7421 Crook Drive 2 2 Solar 1988 N 17-Feb 91,600 Cape Cod Village 8247 Cape Cod Drive 3 2 Solar 1988 N 6-Feb...
View Full Document

Page1 / 8

ee1-p8challenge -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online