this is for my intro accounting course, your excel help is greatly appreciated :)
Question 1 (6 points) A B C D Possible Outcome Range Average Pass 50% or more Rewrite Less than 60% but greater than or equal to 50 % Fall Less than 50% Nam Percentage Score Outcome Xin 99% Harry 826 10 Isla 60% 11 Hanxiao 12 Abode 50%% 13 Chad 10% 14 Brad 10% 15 Alfie 78% 16 Isabella 86% 17 Mohommed 84% In the above spreadsheet, create a formula using the IF Excel function in cell D8 that will determine the outcome of the percentage scores, based on the possible outcomes and their ranges. You should be able to fill down through cells D8:D17. You may also use the AND Excel function. Do not use any spaces within your answer. Using the AVERAGEIF Excel function, create a formula to be filled down through cells D3:D5. The formula should display the average of the percentage scores, based on the outcomes achieved. Do not use any spaces within your answer. A/Question 2 [4 poinisi A B E D E F G omummhuHI-t In the above spreadsheet. create a formula using VLODKUP in cell D4 that will determine the discount applicable to each person based on the Ticket Discounts table {FEES}. You should be aisle to drag your formula from D4 to DB and have it fill in all values appropriately. Do not use analr spaces within your answer. For the TRUE or FALSE parameter, use 1 or ID. respectively. x Question 3 (4 points) A B C D E F G Order List Customer Item Days Until Arrival Price Order Receipts Max Travel Mug 4 5 29.99 The Travel Mug for Max will arrive in 4 days. Your total is $29.99. George Textbook 7 5 69 0 Jessica Phone Case 21 $ 19.99 Caitlyn Carpet 10 5 149.9 Rachel Hair Dryer 4 5 59.99 Randall Calendar 6 5 N 14.9 Joey Sandwich 9.99 11 12 Orders Arriving In Less Than 10 Days 13 Using the COUNTIF Excel function, create a formula for cell D12 that calculates the total number of orders arriving in less than 10 days. Do not use any spaces within your answer. Do not use absolute references ($) within your answer. Using either the CONCATENATE Excel function or &'s, create a formula to be filled down through cells G3:G9. In the specific order that follows, the formula should include: . the item the customer . the days until arrival . the price The first entry has been provided for reference. Do not exclude this entry in your formula. Pay attention to punctuation, grammar, and spacing. Only use spaces where necessary within your answer. Do not use absolute references ($) within your