HW1 File Review 8. Page Layout - 11 Tell me what you Home Insert X Cut Ih Copy Format Painter Draw Calibri Formulas A = Data = A View Help 23 Wrap Text Merge & Center - General $ -% BIU-- Clipboard Alignment Number D25 Name Matt Cole Kristina Ernest Emilee Johnson Marie Hunt David Arnold Jeff Jones 8 Robert Williams Ken Hunter 10 Michael Jordan 11 Dan Katz 12 Rodney Gardener 13 Mike Lowe 14 Joe Jenkins 15 Gordon Mcdonald 16 Robby Jenson Bill Peterson Black Friday 1.5 Vlookup 500 About File Home 2 .8.: Draw Page Layout HW Tell me what you Insert Formulas Data Review View Help = LX Cut Ih Copy Format Painter Clipboard Calibri B IU. - 11 . - A A .A Wrap Text Merge & Center - General $ - % 016 G H Score Vlookup Name Matt Cole Kristina Ernest Emilee Johnson Marie Hunt 6 David Arnold Jeff Jones 8 Robert Williams 9 Ken Hunter 10 Michael Jordan 11 Dan Kata 12 Rodney Gardener 13 Mike Lowe Joe Jenkins 15 Gordon Mcdonald 16 Robby Jenson 17 Peterson 89 Name Black Friday 185 Vlookup 100 Air Se loom File Home Insert Data Review 8 . Draw Page Layout Formulas Calibri - 11 - A A B IU.L .A. View Help Tell me wh A Xout General Ch Copy - * Format Painter Clipboard 29 Wrap Text Merge & Center - $ - % Numbe Alignment D17 X fo 1000 G H 10 0.5 Black Friday 185 Vlookup EOQ Type here to search 0e e o IT-5 (5 points). Refer to the data in the sheet named "If-5". Write if statements on the sheet named "If so that students will get A if their score is greater than or equal to 90, B if there score is greater than or equal to 80 but less than 90, C if there score is greater than or equal to 70 but less than 80, D if their score is greater than or equal to 60 but less than 70, and F otherwise. (note: You have to use If function, otherwise no credit will be given). Vlookup (5 points). Refer to the sheet named "Vlookup". Columns E and F indicate the grading scale. For example, if a score is 0 through 59 the grade is F, if a score is 60 through 62, the grade is "D" and so on. Write Vlookup statements on column C so that each student is graded. (note: You have to use Vlookup, otherwise no credit will be given). DataTable-1 (10 points). Refer to EOQ" sheet. In our SCM310 class, EOQ can be computed using the formula: Square root of (2*D*Co/Ch). By changing Co from 5,10,15,20, compute the different Q*s (note: You have to use Data table function, otherwise no credit will be given). Data Table 2 (10 points). Refer to EOQ" sheet. Show the changes of Q* by changing Co from 5,10,15,20 and Ch from 0.2, 0.5, 0.7,0.9, and 1(note: You have to use Data table function, otherwise no credit will be given)
