gg-1 - If the average daily sales is greater than 50, then...

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

View Full Document Right Arrow Icon
If the average daily sales is greater than 50, then the salesperson gets a bonus equal to 5% of total weekly sales for the store. Thus, in this case, the bonus would be 5% of total weekly sales for the store (cell H10 Monday Tuesday Wednesday Thursday Friday Saturday Total Bonus Chris 15 66 43 61 41 37 263 0 Jill 20 30 40 50 60 70 270 0 Trina 63 45 53 74 22 54 311 69.3 Wayne 42 39 41 57 64 58 301 69.3 Garth 10 44 24 53 75 35 241 0 1386
Background image of page 1

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

View Full DocumentRight Arrow Icon
0).
Background image of page 2
Points per question 1 1 1 3 2 2 10 Question Number 1 2 3 4 5 6 1 2 3 Correct Answer D A B C E D Student 1 D A E C B D 1 1 0 2 D A E C E D 1 1 0 3 D A E C B A 1 1 0 4 D A E C B D 1 1 0 5 D A E C B D 1 1 0 6 D B E C E D 1 0 0 7 D A B B E D 1 1 1 8 D B A C E D 1 0 0 9 D A E C E E 1 1 0 10 D B E A D D 1 0 0 11 D A C C E E 1 1 0 12 D A E C E D 1 1 0 13 D A E C E D 1 1 0 14 D A B C E D 1 1 1 15 D A E B E B 1 1 0 16 A A C B E B 0 1 0 17 D A E D E D 1 1 0 18 D A E C E D 1 1 0 19 D A E B E D 1 1 0 20 D A E C E D 1 1 0 21 D E C B E D 1 0 0 22 D A E C E D 1 1 0 23 D A C B E D 1 1 0 24 D A E C E D 1 1 0 25 D A E C B D 1 1 0 26 C A E C E D 0 1 0 27 D A E B C D 1 1 0 28 D A E C E D 1 1 0 Grade the quiz below. Do it so that if the points per question or correct answer changes, the quiz will still be graded correctly. Use absolute values and IF statements to calculate student scores. Hint:
Background image of page 3

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

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

This note was uploaded on 04/07/2011 for the course ISYS 200 taught by Professor Dean during the Winter '11 term at BYU.

Page1 / 11

gg-1 - If the average daily sales is greater than 50, then...

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

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