Hamna_Mustafa_Excel Assignment # 3 - Classwork-2

Chapter 3: Formulas a Task 1 2 3 4 5 6 7 Insert an IF function in cell I6 that meets the following conditions: - If there is no added ch - Otherwise, I6 should d - Autofill all values in co 8 Insert an IF function in cell J6 that meets the following conditions: - If the total amount in - Otherwise, J1 should d - Autofill all values in co 9 10 11 12 13 - It must be feasible (inf - It must have no extra 14 - The price of the video - The quantity of the vid 15 16 Instructions: Please follow along with your instructor or class TA to complete the be side menu. You have an unlimited amount of times to submit your assignment. In cell F6 , create a formula that multiplies each item's  price (values found in colum Auto Fill the values in column F (range F6:F43 ). Use a SUMPRODUCT function to calculate the value in cell N11 . It should sum the produ In cell G6 , multiply the Total $ amount in column F by the Sales Tax in cell N3 . (Hint: Use Auto Fill the values in column G (range G6:G43 ). Fill column H with the formula which is equal to the Total Amount in column F plus the S Insert the date of May 3rd, 2019 in cell N6 using the DATE function. Insert today's date using the TODAY function in cell N7. In cell B45 , use the COUNTA function to count the number of entries in the range B6:B43 In cell C45 , use the COUNT function to count the number of times there was an added ch Insert an AND function in the range N17:N19 to decide whether it is a good decision to b Enter an OR function in the O17:O19 to decide if you need to contact the supplier if one In range P17:P19 enter a ROUND function that rounds the Total Sales Tax (information in Fill column K with an IFERROR Function. You are summing up numbers in columns C and

17 Below is an image of what your worksheet should look like. Having Problems with ExPrep? Take a screenshot and email: contact@excelpreparation.com Fill column L with a formula that multiplies the Tax (cell N3 ), the commission % (cell N4 ), ExPrep monitors all file submissions. If you submit someone else’s work, the software flags it as a possible integrity vi receive a grade of zero. “Borrowing a friend’s computer” and accidently submitting your friend’s project instead of yo inadvertently, can result in a zero for the project. For this reason, if you use a shared computer, it is advisable to lear

and Functions - Classwork harge, I6 should display the message "No". display the message "Yes". olumn I. column H is less than $500, J1 should display the message "Feasible". display the message "No". olumn J. formation found in column J). cost (information found in column I). o game is less than $40 (information found in column E). deo game is greater than 100 (information found in column D). elow steps. Once you are done, kindly upload this Excel Workbook to ExPrep by usin mn E) by the  quantity (values found in column D). uct of Price and Quantity. cell referencing - you will only be marked correct if you use absolute referencing). Sales Tax in column G. In other words, the values in column H are the sum of values in columns G and F. 3 of your worksheet. harge in the range C6:C43 of your worksheet. buy the video game or not. The conditions to be met are: of the below conditions are met: n column G) for the three videos to the nearest 0 decimal place. d G . However, if an Error occurs, your formula is going to simply return the value "NA".

, and the Price/Item in column E. Use absolute references when necessary. iolation. Both parties are identified even if they are in different sections, courses, or schools. In such a case, both pa our own is not an excuse. You and your friend will both receive grades of zero. Leaving a file available for others to a rn how to save your work to your UMass OneDrive.

Points 5 2.5 5 5 2.5 5 10 10 5 5 5 5 10 10 5 5 ng the

5 arties will access, even

83954

Toy Utopia Video Game Name Category Added Charge Quantity Aspect Animation None 12 Kraken Stop motion 2 50 Bender Mixed media None 203 Lynch Screencast None 21 Big Papa Animated demo None 24 Mad Dog Live action None 93 Volume Up Animation None 30 Static Electric Mixed media None 102 Juicy Mixed media None 36 Cruel Rocks Mixed media None 39 Step Down Mixed media 5 42 Great Escape Animation None 45 Grudges Screencast None 48 LuluX Animated demo None 51 The Y Army Live action None 54 Captain G Animation 5 78 Pirate Palace Mixed media 5 60 X1263 Mixed media 5 63 Past Kings Mixed media 5 66 Polrun Animation 5 69 Great Danes Screencast 2 72 Revenge Date Animated demo 2 75 Suspects Animation 2 78 LP 963 Animation None 81 Mission Impossible Animation None 84 Heart of Gold Mixed media None 87 Two Blocks Mixed media None 90 788 Codes Animation 5 93 Rem 456 Screencast 2 96 Animal Attack Animated demo None 99 Zombie Fall Live action None 102 Rakens Animation None 90 Stevens B Mixed media None 108 Alma 236 Screencast 5 22 High Code Animated demo None 114 Madness Jungle Animation None 117 Forest of Tigers Animation None 26

Price/Item Total $ (No Tax) Total Sales Tax Total $ (Tax Included) Extra Cost? $ 5.00 $ 60.00 $ 3.00 $ 63.00 No $ 3.00 $ 150.00 $ 7.50 $ 157.50 Yes $ 8.00 $ 1,624.00 $ 81.20 $ 1,705.20 No $ 2.00 $ 42.00 $ 2.10 $ 44.10 No $ 22.00 $ 528.00 $ 26.40 $ 554.40 No $ 9.00 $ 837.00 $ 41.85 $ 878.85 No $ 10.00 $ 300.00 $ 15.00 $ 315.00 No $ 4.00 $ 408.00 $ 20.40 $ 428.40 No $ 63.00 $ 2,268.00 $ 113.40 $ 2,381.40 No $ 5.00 $ 195.00 $ 9.75 $ 204.75 No $ 47.00 $ 1,974.00 $ 98.70 $ 2,072.70 Yes $ 8.00 $ 360.00 $ 18.00 $ 378.00 No $ 56.00 $ 2,688.00 $ 134.40 $ 2,822.40 No $ 8.00 $ 408.00 $ 20.40 $ 428.40 No $ 7.00 $ 378.00 $ 18.90 $ 396.90 No $ 46.00 $ 3,588.00 $ 179.40 $ 3,767.40 Yes $ 9.00 $ 540.00 $ 27.00 $ 567.00 Yes $ 6.00 $ 378.00 $ 18.90 $ 396.90 Yes $ 5.00 $ 330.00 $ 16.50 $ 346.50 Yes $ 61.00 $ 4,209.00 $ 210.45 $ 4,419.45 Yes $ 4.00 $ 288.00 $ 14.40 $ 302.40 Yes $ 9.00 $ 675.00 $ 33.75 $ 708.75 Yes $ 10.00 $ 780.00 $ 39.00 $ 819.00 Yes $ 13.00 $ 1,053.00 $ 52.65 $ 1,105.65 No $ 6.00 $ 504.00 $ 25.20 $ 529.20 No $ 6.00 $ 522.00 $ 26.10 $ 548.10 No $ 9.00 $ 810.00 $ 40.50 $ 850.50 No $ 3.00 $ 279.00 $ 13.95 $ 292.95 Yes $ 8.00 $ 768.00 $ 38.40 $ 806.40 Yes $ 2.00 $ 198.00 $ 9.90 $ 207.90 No $ 1.00 $ 102.00 $ 5.10 $ 107.10 No $ 9.00 $ 810.00 $ 40.50 $ 850.50 No $ 10.00 $ 1,080.00 $ 54.00 $ 1,134.00 No $ 46.00 $ 1,012.00 $ 50.60 $ 1,062.60 Yes $ 23.00 $ 2,622.00 $ 131.10 $ 2,753.10 No $ 5.00 $ 585.00 $ 29.25 $ 614.25 No $ 16.00 $ 416.00 $ 20.80 $ 436.80 No

$ 8.00 $ 984.00 $ 49.20 $ 1,033.20 No

No NA

5% 7% 5/3/2019 3/26/2024 34753 Buy Contact Supplier Sales Tax/ Item 1 1 $ 18.00 0 0 $ 134.00 1 1 $ 20.00

Questions Score Max Points Data in cell(s): F6, in worksheet: ToyUtopia 5 5 Data in cell(s): F7:F43, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): N11, in worksheet: ToyUtopia 5 5 Data in cell(s): G6, in worksheet: ToyUtopia 5 5 Data in cell(s): G7:G43, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): H6, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): H7:H43, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): I7:I43, in worksheet: ToyUtopia 5 5 Data in cell(s): J6, in worksheet: ToyUtopia 5 5 Data in cell(s): J7:J43, in worksheet: ToyUtopia 5 5 Data in cell(s): N6, in worksheet: ToyUtopia 5 5 Data in cell(s): N7, in worksheet: ToyUtopia 5 5 Data in cell(s): B45, in worksheet: ToyUtopia 5 5 Data in cell(s): C45, in worksheet: ToyUtopia 5 5 Data in cell(s): N17, in worksheet: ToyUtopia 5 5 Data in cell(s): N19, in worksheet: ToyUtopia 2 2 Data in cell(s): N18, in worksheet: ToyUtopia 3 3 Data in cell(s): O18, in worksheet: ToyUtopia 3 3 Data in cell(s): O17, in worksheet: ToyUtopia 2 2 Data in cell(s): O19, in worksheet: ToyUtopia 5 5 Data in cell(s): P17, in worksheet: ToyUtopia 0.5 0.5 Data in cell(s): P18, in worksheet: ToyUtopia 2 2 Data in cell(s): P19, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): K6, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): K7:K43, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): L7:L43, in worksheet: ToyUtopia 0 2.5 Data in cell(s): L6, in worksheet: ToyUtopia 0 2.5 Total Score 90 95

Feedback Check step # 17! Check step # 17! 94.7368%