STEP 1 From your email, open the excel sheet that was emailed to you from me.
STEP 2. Save to your desktop and Rename the sheet as follows: ####### COMP45 13U MIDTERM [####### MEANS STUDENT NUMBER] (20)
STEP 3. Label col K. SALES TOTAL IN $ (10)
STEP 4. Label col L CASES SHORTED IN CASES (10)
STEP 5. Label col M CASES SHORTED AS A % (10)
STEP 6. Label col N CASES SHORTED IN $ (10)
STEP 7. Label col O UNIT SOLD (36 UNITS PER CASE) (10)
STEP 8. Label col P .. COST PER UNIT IN $ (10)
STEP 9. Do wrap text in row 1, all information must be readable. (10)
STEP 10. Complete ALL calculations for the data field in columns K L M N O P (60)
STEP 11. Create three new spreadsheets and rename them ANDY, RAY, SUSAN. (60)
STEP 12. Copy and paste the salesperson data ( ALL DATA ASSOCIATED WITH THEIR NAMES) into their respective spreadsheets. (60)
STEP 13. In database sheet do the grand total on row 102. Label to be in A102. Calculate only totals relevant to the business. (10)
STEP 14. Calculate the relevant totals for the sheets ANDY, RAY , SUSAN. The totals must show in the row immediately below the data field in each sheets. Apply a proper label. (60)
STEP 15. When pasting do the following, click on the down arrow on the PASTE symbol, and select PASTE SPECIAL VALUE 123.
Copy ANDY row 48 and paste into DATABASE ROW 104.
Copy RAY row 40 and paste into DATABASE ROW 106.
Copy SUSAN row 18 and paste into DATABASE ROW 108.
File Home Insert Page Layout Formulas Data Review View Help O Search Share Comments X Calibri ' ' 11 Insert ab Wrap Text General LO Paste BIU a. A Es Merge & Center $ % 98- 9X Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas M11 : B D E G M NA SALES TOTAL CASES SHORTED IN CASES CASES SHORTED A 1 CLIENT NUMBER ORDER NUMBER CITY COUNTRY REGION 2 23356 56880 Toronto CANADA East 3 1124 56883 Saskatoon CANADA West 4 23356 56884 Christ Church NEW ZEALAND Int. 5 1124 56885 Toronto CANADA East 6 1124 56886 Toronto CANADA East 7 23356 56887 Saskatoon CANADA West 8 23356 56893 Saskatoon CANADA West 9 23356 56894 Boston USA Int. 10 1124 56898 Toronto CANADA East 11 23356 56901 Saskatoon CANADA West 12 23356 56902 Christ Church NEW ZEALAND Int. 13 23356 56903 Toronto CANADA East 14 1124 56904 Toronto CANADA East 1124 15 56905 Saskatoon West CANADA 16 1124 56909 Toronto East CANADA 17 1124 56910 Toronto East CANADA 18 West 1124 56911 Saskatoon CANADA 19 1124 56914 Christ Church NEW ZEALAND Int. 20 East 1124 56916 Toronto CANADA 21 Int. 1124 56918 Boston USA DATABASE ORDER QUANT QUANTITY SHIPPE UNIT PRICE (SALES PERSON 5500 5400 $18.00 ANDY 46000 46000 $21.00 ANDY 12000 12000 $13.50 ANDY 6000 5500 $18.00 ANDY 5500 5400 $18.00 ANDY 3200 3000 $21.00 ANDY 3200 3000 $21.00 ANDY 12000 12000 $15.50 ANDY 5500 5400 $18.00 ANDY too 7600 $21.00 ANDY 12000 12000 $13.50 ANDY 6000 6000 $18.00 ANDY 5500 5500 $18.00 ANDY 3200 3200 $21.00 ANDY 6000 6000 $18.00 ANDY 5500 5400 $18.00 ANDY 12400 3000 $21.00 ANDY 12000 12000 $13.50 ANDY 5500 5400 $18.00 ANDY 12000 12000 $15.50 ANDY 9999 Ready a 40 ENG 3:53 PM 2020-10-29 16 B Type here to search File Home Insert Page Layout Formulas Data Review View Help O Search Share Comments X Calibri ' ' 11 Insert ab Wrap Text General LO Paste BIU a. A Es Merge & Center $ % 98- 9X Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas M11 : B D E G M NA SALES TOTAL CASES SHORTED IN CASES CASES SHORTED A 1 CLIENT NUMBER ORDER NUMBER CITY COUNTRY REGION 2 23356 56880 Toronto CANADA East 3 1124 56883 Saskatoon CANADA West 4 23356 56884 Christ Church NEW ZEALAND Int. 5 1124 56885 Toronto CANADA East 6 1124 56886 Toronto CANADA East 7 23356 56887 Saskatoon CANADA West 8 23356 56893 Saskatoon CANADA West 9 23356 56894 Boston USA Int. 10 1124 56898 Toronto CANADA East 11 23356 56901 Saskatoon CANADA West 12 23356 56902 Christ Church NEW ZEALAND Int. 13 23356 56903 Toronto CANADA East 14 1124 56904 Toronto CANADA East 1124 15 56905 Saskatoon West CANADA 16 1124 56909 Toronto East CANADA 17 1124 56910 Toronto East CANADA 18 West 1124 56911 Saskatoon CANADA 19 1124 56914 Christ Church NEW ZEALAND Int. 20 East 1124 56916 Toronto CANADA 21 Int. 1124 56918 Boston USA DATABASE ORDER QUANT QUANTITY SHIPPE UNIT PRICE (SALES PERSON 5500 5400 $18.00 ANDY 46000 46000 $21.00 ANDY 12000 12000 $13.50 ANDY 6000 5500 $18.00 ANDY 5500 5400 $18.00 ANDY 3200 3000 $21.00 ANDY 3200 3000 $21.00 ANDY 12000 12000 $15.50 ANDY 5500 5400 $18.00 ANDY too 7600 $21.00 ANDY 12000 12000 $13.50 ANDY 6000 6000 $18.00 ANDY 5500 5500 $18.00 ANDY 3200 3200 $21.00 ANDY 6000 6000 $18.00 ANDY 5500 5400 $18.00 ANDY 12400 3000 $21.00 ANDY 12000 12000 $13.50 ANDY 5500 5400 $18.00 ANDY 12000 12000 $15.50 ANDY 9999 Ready a 40 ENG 3:53 PM 2020-10-29 16 B Type here to search
