Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is for my intro accounting course, your excel help is greatly appreciated :) Question 1 (6 points) A B C D Possible Outcome Range

image text in transcribedimage text in transcribed

this is for my intro accounting course, your excel help is greatly appreciated :)

image text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Late RC Sekhar, AV Rajagopalan

1st Edition

195683609, 978-0195683608

More Books

Students also viewed these Accounting questions

Question

What do you see as your biggest strength/weakness?

Answered: 1 week ago

Question

1. What does this mean for me?

Answered: 1 week ago