This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

California Division California Washington Washington California California California California Washington Washington California California California Washington Washington California Washington California Washington Washington Washington California Store Joy's Toys Play House Toys Play Yard Toys Play Yard Toys CCSF Toy Store Joy's Toys Jungle Jim's Play Yard Toys Play Yard Toys The Ultimate Toy Store Joy's Toys Play House Toys Terra Toys Joy's Toys Terra Toys Play House Toys The Ultimate Toy Store Jungle Jim's Jungle Jim's Play House Toys The Ultimate Toy Store Play Yard Toys Item Blocks Doll Blocks Train Computers Jump Rope Blocks Train Doll Doll Doll Jump Rope Train Blocks Train Blocks Jump Rope Blocks Train Blocks Train Doll Quantity 75 141 217 119 45 241 172 161 239 165 218 250 102 201 139 207 110 143 195 109 58 185 Price $22.00 $16.00 $22.00 $28.00 $250.00 $8.00 $22.00 $28.00 $16.00 $16.00 $16.00 $8.00 $28.00 $33.00 $56.00 $22.00 $8.00 $22.00 $22.00 $22.00 $28.00 $16.00 Total Sales $1,650.00 $2,256.00 $4,774.00 $3,332.00 $11,250.00 $1,928.00 $3,784.00 $4,508.00 $3,824.00 $2,640.00 $3,488.00 $2,000.00 $2,856.00 $6,633.00 $7,784.00 $4,554.00 $880.00 $3,146.00 $4,290.00 $2,398.00 $1,624.00 $2,960.00 Sales Rep Chambers Chambers Chambers Chambers De Leon Reeves Reeves Reeves Reeves Reeves Rodriguez Rodriguez Rodriguez Rodriguez Rodriguez Simpson Simpson Winters Winters Winters Winters Wright Division California Washington Sales Rep Reeves Winters Rodriguez Simpson Chambers Wright Define List Name Range Data Validation Conditional Formatting Jennifer Biehn c2b7cffea355fc0276e99999b2c236f936e993e4.xls ashington Define List Name Range Data Validation Conditional Formatting Jennifer Biehn c2b7cffea355fc0276e99999b2c236f936e993e4.xls Class Schedule Class LA 52 MABS 60 MABS 101 MABS 202 MABS 202 MABS 60 MABS 60 MABS 60 MABS 60 MABS 60 MABS 60 MABS 60 MABS 60 MABS 60 MABS 101 MABS 60 MABS 60 WDPR 391A MABS 60 WDPR 391B ACCT 53 MABS 60 MABS 60 MABS 60 MABS 60 MABS 61 MABS 61 MABS 61 MABS 67 MABS 67 MABS 60 MABS 60 MABS 60 MABS 101 MABS 101 MABS 101 WDPR 80 WDPR 391A MABS 202 MRKT 145 WDPR 391B ACCT 53 WDPR 391A LA 72 MABS 60 WDPR 391B MABS 101 Section 501 501 501 501 502 10 402 2 11 5 3 12 9 401 4 504 591 402 403 402 1 1 502 592 4 501 1 591 1 501 7 6 8 2 503 3 1 401 1 1 401 501 601 501 503 602 502 Days M M M M M TR MW TR MW TR MW T TR MW MW R S MW TR MW MWF MWF T S MWF T TR S TR R MWF MWF MWF MWF R TR MWF MWF TR TR MWF W T W W T W Start End 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 8:30 PM 6:30 PM 8:30 PM 11:00 AM 12:30 PM 4:00 PM 6:00 PM 8:00 AM 9:30 AM 12:00 PM 1:30 PM 9:30 AM 11:00 AM 8:30 AM 10:00 AM 1:00 PM 4:00 PM 11:00 AM 12:30 PM 4:00 PM 6:00 PM 12:00 PM 1:30 PM 6:30 PM 9:30 PM 8:30 AM 11:30 AM 12:00 PM 1:30 PM 4:00 PM 6:00 PM 12:00 PM 1:30 PM 10:00 AM 11:00 AM 8:00 AM 9:00 AM 6:30 PM 9:30 PM 8:30 AM 11:30 AM 9:00 AM 10:00 AM 6:30 PM 9:30 PM 11:00 AM 12:30 PM 8:30 AM 11:30 AM 9:30 AM 11:00 AM 6:30 PM 9:30 PM 10:00 AM 11:00 AM 10:00 AM 11:00 AM 11:00 AM 12:00 PM 11:00 AM 12:00 PM 6:30 PM 9:30 PM 11:00 AM 12:30 PM 10:00 AM 11:00 AM 10:00 AM 11:00 AM 8:30 AM 9:30 AM 9:30 AM 11:00 AM 10:00 AM 11:00 AM 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 9:30 PM 6:30 PM 9:30 PM Room C116 C115 C110 C109 C109 C116 C116 C109 C115 C110 C116 C109 C110 C109 C110 C116 C115 C109 C110 C109 C116 C115 C116 C116 C115 C110 C115 C109 C109 C109 C115 C110 C109 C110 C110 C110 C111 C109 C115 C115 C109 C116 C111 C111 C116 C111 C110 Instructor Dye Middleton Aparicio Stoner Stoner Cutten Cerone Diamond Hock Hock Leung Hock Knapp Uchida Butler McDonagh McDonagh Oldham Middleton Oldham Leung Diamond Stoner Stoner Diamond Aparicio Berston Berston Knapp Knapp Middleton Oldham Oldham Butler Butler Hock Casserly Barcojo Vota Vota Barcojo Butler Chang Brown McDonagh Chang Aparicio Special Info Starts Jan Starts Mar Starts Jan Starts Mar Starts Jan Starts Mar Starts Jan Starts Mar c2b7cffea355fc0276e99999b2c236f936e993e4.xls, Schedule Insert 2 rows and enter Class Schedule Data/List/Create Use Data Form to add, delete, edit. Use Criteria to find Name Range - Schedule Describe list Simple sort More complex sort Simple filter Custom filter Show wildcard * c2b7cffea355fc0276e99999b2c236f936e993e4.xls, Schedule Acct 53 LA 52 LA 72 MABS 60 MABS 61 MABS 67 MABS 101 MABS 202 MRKT 145 WDPR 80 WDPR 391A WDPR 391B Put list in a logical order Tools/Options/Custom Lists - highlight cells - import Klassy Kow Accounts Payable Account Smith & Hughes Insurance US Express Continental Power and Gas US Express MasterPayCard Continental Power and Gas MasterPayCard Federal Shipping Pacific Cable Pacific Cable Western Telephone Western Telephone Avalon Financial Services Suburban Savings and Loan Sort & subtotals Date Rec'd 1-Nov-01 15-May-02 4-Feb-02 23-Jun-01 10-Apr-02 2-Nov-01 10-Nov-01 7-Sep-02 3-Jan-02 5-Nov-01 8-Mar-02 2-Nov-01 25-Oct-01 10-Jul-02 Due Date 1-Dec-01 14-Jun-02 6-Mar-02 23-Jul-01 10-May-02 2-Dec-01 10-Dec-01 7-Oct-02 2-Feb-02 5-Dec-01 7-Apr-02 2-Dec-01 24-Nov-01 9-Aug-02 Amount 3,500.00 2,458.00 2,456.00 2,356.00 1,832.77 1,568.00 1,200.35 1,200.00 975.00 932.67 932.37 895.32 350.00 350.00 [Student Name] c2b7cffea355fc0276e99999b2c236f936e993e4.xls 10/30/2010 Klassy Kow Ice Cream, Inc. Potential Sites for Klassy Kow House Address Bedrooms Baths Heat Lot Size Age Price Date Listed Notes 12 Matthew Square 5 4 Gas 0.30 48 ### 09-Nov-01 714 Apple Street 5 3 Oil 0.50 15 ### 19-Jul-01 35 Lydia Street 5 2 Electric 0.60 20 ### 13-Mar-01 112 Beach Avenue 4 3 Gas 0.20 11 ### 08-Nov-01 14 Shaw Drive 4 2 Oil 1.75 32 ### 05-Apr-01 282 Central Avenue 4 2 Electric 0.25 7 ### 19-Jul-01 Ocean views 19 Hill Road 4 2 Oil 0.30 26 ### 07-Aug-01 203 Narrow Avenue 4 2 Gas 0.60 12 95,000.00 08-Feb-01 319 Windy Drive 3 1 Solar 0.55 3 ### 14-Oct-01 287 Harbor Avenue 3 1 Solar 1.00 4 ### 22-May-01 122 Robert Treat Pkwy 3 2 Electric 1.25 14 ### 07-Apr-01 44 Cramer Court 3 1 Electric 1.00 18 ### 17-Apr-01 455 Paulis Road 2 1 Electric 0.25 16 ### 15-Oct-01 Nice lake views 903 Ray Road 2 1 Oil 0.33 45 ### 01-Oct-01 On deposit 12 Franklin Avenue 2 2 Gas 0.75 15 ### 30-Mar-01 198 Meadow Road 2 2 Oil 0.85 27 ### 08-Dec-01 690 Rice Avenue 2 1 Oil 0.60 25 92,000.00 01-Dec-01 14 Pratt Place 2 1 Oil 0.30 22 90,000.00 21-Dec-01 11 Breakneck Road 2 1 Oil 0.50 30 80,000.00 02-Jan-01 45 Maywood Drive 2 1 Gas 0.30 45 55,000.00 11-Nov-01 1463 Woodlawn Avenue 2 1 Electric 0.20 28 42,500.00 04-Jun-01 86 Howard Street 1 1 Oil 0.35 16 ### 11-Oct-01 95 Horne Place 1 1 Gas 0.25 14 55,000.00 14-Sep-01 Nice fireplace 194 Glenwood Road 1 1 Oil 0.80 35 37,600.00 23-Dec-01 ... View Full Document

End of Preview

Sign up now to access the rest of the document