Excel Assignment Winter 2011-Antoine Tardif

Excel Assignment Winter 2011-Antoine Tardif - Assignment #...

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

View Full Document Right Arrow Icon
Assignment # 1 - Excel - Winter 2011 Change the values in the tables below, per instructions. Note: Often in team work, one of the two students will do most of the work. Don't find yourself short changed for your midterm. Furthermore, plagiarism, i.e. the copying of this assignment will not be tolerated and is strictly enforced. The tables below are used in Step 1 Green Copy Centre Sales Order No Puchase Date Cust ID Salesman # Task ID Quantity Payment date 889 2/Sep/10 200 300 COL75 251 2/Sep/10 2604 890 5/Sep/10 250 101 LAM10 100 5/Nov/10 19801 891 18/Sep/10 225 300 FOL25 1500 19/Nov/10 14617 892 26/Sep/10 175 101 LAM10 249 22/Dec/10 8509 893 29/Sep/10 175 125 COL75 2539 28/Dec/10 9181 894 1/Sep/10 300 300 FOL35 4000 19/Sep/10 13935 895 1/Oct/10 225 125 COL75 875 17/Oct/10 8578 896 12/Oct/10 250 101 COL75 1250 13/Nov/10 19070 897 14/Oct/10 300 125 FOL25 500 2/Jan/11 9238 898 15/Oct/10 225 300 LAM10 99 15/Oct/10 14818 899 23/Oct/10 175 125 PHO85 50 19/Nov/10 15286 900 2/Dec/10 175 101 FOL25 49 1/Apr/11 7271 901 17/Dec/10 225 245 FOL35 999 4/Mar/11 2729 Cust ID Cust Name Prov Salesman # 101 125 245 300 175 Mike Cameron NB Name Your Own Name Partner (if one) Agnes Alverez David Richter 200 Robert Lasalle QC 5.00% 3.27% 5.00% 8.00% 225 Your name QC 8.50% 4.13% 7.50% 12.00% 250 Aaron Cinco ON 300 Thanura Leung NS Task ID Task Description Province Sales tax COL75 Collating $0.280 $0.273 $0.259 $0.239 NS 12.45% FOL25 Folding $0.248 $0.227 $0.213 $0.199 NB 12.35% FOL35 Folding $0.443 $0.424 $0.411 $0.407 ON 11.95% LAM10 Laminating $18.500 $17.890 $16.350 $14.259 QC 12.11% PHO85 Photo prints $0.185 $0.169 $0.147 $0.123 This assignment is to be uploaded as an Excel file to webct by the posted deadline. It can be done on your own or as a team of 2 students (for the latter, the 2 need not be in the same section). Note: When you first start, use the File Save As to name your workbook: Excel Assignment with Your own name. Note: You can work with any version of Excel. Random number for instructor Commission % if Sales >500 and <1,000 Commission % if Sales >=1,000 Change Cust ID 225 to your own name (first, last). For a team use 1 name. As well, in the table above, Unit cost Quantity<5 0 units Unit cost Quantity >= 50 and <250 Unit cost Quantity >= 250 and <1,000 Unit cost Quantity >= 1,000 units
Background image of page 1

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

View Full DocumentRight Arrow Icon
Antoine Tardif 260440232 Green Copy Centre Sales Complete all other columns with formulas (expressions). Order No 889 890 891 892 893 894 895 896 897 898 899 900 901 From pick list select your class. Enter your full name (last + first names) & your partner's name, if you have one. Enter your
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course BUSINESS 101 taught by Professor All during the Spring '09 term at McGill.

Page1 / 6

Excel Assignment Winter 2011-Antoine Tardif - Assignment #...

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