ee1-p4drill

ee1-p4drill - Overview Project 4 Skill Drills Entering...

This preview shows pages 1–5. Sign up to view the full content.

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4d7c1bd8f412c7eb9b92fa3e0ddc17ffdcca850f.xls Overview 05/07/2009 Project 4 Skill Drills: Entering Formulas in Well-Designed Worksheets What would you like to do? Skill Sheet 1. Add user instructions and other documentation #1-Document 2. Enter formulas by typing and pointing #2-Point 3. Create and copy a formula with an absolute cell address #3-Absolute 4. Display formulas instead of formula results #4-Formulas 5. Split the screen into top and bottom panes #5-Split 6. Freeze column headings #6-Freeze Skill Drill exercises reinforce skills presented in Essentials lessons. In these exercises you apply what you have learned to a different data set. A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 4d7c1bd8f412c7eb9b92fa3e0ddc17ffdcca850f.xls#1-Document 05/07/2009 Project 4 Skill Drill: Adding User Instructions and Other Documentation Community Volunteer Corps - Year 2002 Fundraiser Worksheet to Calculate Porfit on Sales Designed by: Carissa Niro Calendar Calendar 2.50 2.50 60% 60% Note: Enter data in light yellow cells only. Formulas generate the other values. Participant # Sold Revenue Remit to Mfg Profit Susan 100 250.00 150.00 100.00 Harry 15 37.50 22.50 15.00 Bill 25 62.50 37.50 25.00 Janet 5 12.50 7.50 5.00 Joe 50 125.00 75.00 50.00 Barb 10 25.00 15.00 10.00 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 4d7c1bd8f412c7eb9b92fa3e0ddc17ffdcca850f.xls #2-Point 05/07/2009 Project 4 Skill Drill: Entering Formulas by Typing and Pointing Sales tax rate 5% 10% Original purchase amount 19.95 22.75 Sales tax 1.00 2.28 Total due on the purchase 20.95 25.03 A B C D E F G 1 2 3 4 5 6 7 8 9 4d7c1bd8f412c7eb9b92fa3e0ddc17ffdcca850f.xls #3-Absolute 05/07/2009 Project 4 Skill Drill: Creating and Copying a Formula with an Absolute Cell Reference Sales 'R Us 30% <-- Current markup on cost percentage...
View Full Document

{[ snackBarMessage ]}

Page1 / 7

ee1-p4drill - Overview Project 4 Skill Drills Entering...

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

View Full Document
Ask a homework question - tutors are online