Hamna_Mustafa_Excel Assignment # 3 - Homework

Chapter 3: Formulas an Tasks 1 2 3 4 5 6 Insert an IF formula in column I that meets the following conditions: - If there is no added ch - Otherwise, I1 should d 7 Insert an IF formula in column J that meets the following conditions: - If the total amount in - Otherwise, J1 should d 8 9 10 11 12 - It must be accepted (in - It must have no extra 13 - The price of the board - The quantity of the bo 14 15 16 Below is an image of what your worksheet should look like. Instructions: Complete the below steps. Once you are done, kindly upload this Excel W Fill all column F (range F6:F43 ) with a formula that multiplies each board game's price by Use a SUMPRODUCT function to calculate the Total in cell O6 . It is the sum of the produ In cell G6 , calculate the commission per item. Your formula multiplies the Total Amount cell referencing - you will only be marked correct if you use absolute referencing). Auto Fill the values in column G (range G6:G43 ). Column H sums up values from columns G and F. Use a SUM function to fill in the range Insert the date of February 3rd, 2023 in cell R3 using the DATE function. Insert today's date using the TODAY function in cell R4 . In cell B45 , use a function to count the number of entries in the range B6:B43 of your wo In cell C45 , use a function to count the number of times there was an added charge in th Insert an AND function in the range O9:O11 to decide whether it is a good decision to bu Enter an OR function in the P9:P11 to decide if you need to contact the supplier if one o In the range Q9:Q11 enter a ROUND function that rounds the Added Commission (colum Fill column K with an IFERROR Function. You are summing up numbers in columns C and Fill column L with a formula that multiplies the Tax (cell O3 ) by the Total in column F. Us

Having Problems with ExPrep? ExPrep monitors all file submissions. If you submit someone else’s work, the software flags it as a possible integrity violatio grade of zero. “Borrowing a friend’s computer” and accidently submitting your friend’s project instead of your own is not result in a zero for the project. For this reason, if you use a shared computer, it is advisable to learn how to save your work Take a screenshot and email: contact@excelpreparation.com

Points 5 5 5 5 5 10 10 5 5 5 5 10 10 5 5 5

83954

Toy Utopia Board Game Type Added Charge Quantity Jumping Jack store Deck Building NA 100 Snakes II Cooperative 23 50 Ronald G. Co-op games NA 203 The Oaks Fighting NA 21 Crazy Monkey Gamebooks 9 24 Bad Blood Legacy 9 24 Turf Campaign 8 60 Balsamic Cooperative NA 24 Tiny Toys Co-op games 9 36 Pirate Kings Deck Building NA 24 The Lions Legacy 9 24 Monopoly Campaign NA 24 Strategic Wins Cooperative 9 48 Grudges and Wins Co-op games NA 51 Sugarcoat Deck Building NA 24 Pine Valley Legacy NA 78 Roll and Win Co-op games NA 60 Ice and Dice Fighting 9 63 Cat Tricks III Gamebooks NA 66 Fire Trouble Gamebooks NA 69 Ladders and Mice Gamebooks 8 72 Spice it Up Co-op games NA 75 Flower Garden Fighting NA 78 Emoji Heaven Gamebooks NA 81 Prison Legacy 6 84 Money 789 Campaign NA 78 Last Unicorn Deck Building NA 110 Help Me Cooperative NA 93 Stay Cool Co-op games NA 96 Queens of England Fighting 6 99 Getaway Gamebooks 10 102 Prince of Darkness Gamebooks NA 23 Goosebumps Gamebooks NA 108 Today is Gone Co-op games NA 22 Computers Today Fighting NA 26 Watch Me Fighting NA 117 Spiderman Fighting NA 26

Price Total Commission Added Commission $ 5.00 $ 500.00 $ 45.00 $ 545.00 $ 3.00 $ 150.00 $ 13.50 $ 163.50 $ 8.00 $ 1,624.00 $ 146.16 $ 1,770.16 $ 2.00 $ 42.00 $ 3.78 $ 45.78 $ 22.00 $ 528.00 $ 47.52 $ 575.52 $ 9.00 $ 216.00 $ 19.44 $ 235.44 $ 10.00 $ 600.00 $ 54.00 $ 654.00 $ 4.00 $ 96.00 $ 8.64 $ 104.64 $ 63.00 $ 2,268.00 $ 204.12 $ 2,472.12 $ 5.00 $ 120.00 $ 10.80 $ 130.80 $ 47.00 $ 1,128.00 $ 101.52 $ 1,229.52 $ 8.00 $ 192.00 $ 17.28 $ 209.28 $ 56.00 $ 2,688.00 $ 241.92 $ 2,929.92 $ 8.00 $ 408.00 $ 36.72 $ 444.72 $ 7.00 $ 168.00 $ 15.12 $ 183.12 $ 46.00 $ 3,588.00 $ 322.92 $ 3,910.92 $ 9.00 $ 540.00 $ 48.60 $ 588.60 $ 6.00 $ 378.00 $ 34.02 $ 412.02 $ 5.00 $ 330.00 $ 29.70 $ 359.70 $ 61.00 $ 4,209.00 $ 378.81 $ 4,587.81 $ 4.00 $ 288.00 $ 25.92 $ 313.92 $ 9.00 $ 675.00 $ 60.75 $ 735.75 $ 10.00 $ 780.00 $ 70.20 $ 850.20 $ 13.00 $ 1,053.00 $ 94.77 $ 1,147.77 $ 6.00 $ 504.00 $ 45.36 $ 549.36 $ 6.00 $ 468.00 $ 42.12 $ 510.12 $ 9.00 $ 990.00 $ 89.10 $ 1,079.10 $ 3.00 $ 279.00 $ 25.11 $ 304.11 $ 8.00 $ 768.00 $ 69.12 $ 837.12 $ 2.00 $ 198.00 $ 17.82 $ 215.82 $ 1.00 $ 102.00 $ 9.18 $ 111.18 $ 9.00 $ 207.00 $ 18.63 $ 225.63 $ 10.00 $ 1,080.00 $ 97.20 $ 1,177.20 $ 46.00 $ 1,012.00 $ 91.08 $ 1,103.08 $ 23.00 $ 598.00 $ 53.82 $ 651.82 $ 5.00 $ 585.00 $ 52.65 $ 637.65 $ 16.00 $ 416.00 $ 37.44 $ 453.44

$ 8.00 $ 1,840.00 $ 165.60 $ 2,005.60

NO Reject Error $ 73.60

Sales Tax: 4% Commision 9% Total $ 31,616.00 Decision Buy The Oaks 1 Crazy Monkey 0 Bad Blood 0

83954

Questions Score Max Points Data in cell(s): R3, in worksheet: ToyUtopia 5 5 Data in cell(s): R4, in worksheet: ToyUtopia 0 5 Data in cell(s): F6, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): G6, in worksheet: ToyUtopia 5 5 Data in cell(s): H6, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): I6, in worksheet: ToyUtopia 8 8 Data in cell(s): J6, in worksheet: ToyUtopia 8 8 Data in cell(s): K6, in worksheet: ToyUtopia 4 4 Data in cell(s): L6, in worksheet: ToyUtopia 4 4 Data in cell(s): O6, in worksheet: ToyUtopia 5 5 Data in cell(s): F7, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): G7:G43, in worksheet: ToyUtopia 5 5 Data in cell(s): H7:H43, in worksheet: ToyUtopia 2.5 2.5 Data in cell(s): I7:I43, in worksheet: ToyUtopia 2 2 Data in cell(s): J7:J43, in worksheet: ToyUtopia 2 2 Data in cell(s): K7:K43, in worksheet: ToyUtopia 1 1 Data in cell(s): L7:L43, in worksheet: ToyUtopia 1 1 Data in cell(s): O9, in worksheet: ToyUtopia 8 8 Data in cell(s): P9, in worksheet: ToyUtopia 8 8 Data in cell(s): Q9, in worksheet: ToyUtopia 3 3 Data in cell(s): O10, in worksheet: ToyUtopia 1 1 Data in cell(s): P10, in worksheet: ToyUtopia 1 1 Data in cell(s): Q10, in worksheet: ToyUtopia 1 1 Data in cell(s): O11, in worksheet: ToyUtopia 1 1 Data in cell(s): P11, in worksheet: ToyUtopia 1 1 Data in cell(s): Q11, in worksheet: ToyUtopia 1 1 Data in cell(s): B45, in worksheet: ToyUtopia 0 5 Data in cell(s): C45, in worksheet: ToyUtopia 0 5 Total Score 85 100