Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Not quite understanding what to do for column E and F. Any help would be helpful Problem 3 (33 points) In this problem, you will

image text in transcribed

Not quite understanding what to do for column E and F. Any help would be helpful

Problem 3 (33 points) In this problem, you will learn how date/time data is stored in Excel by working with dates and times Lookup Reference Table Order Fulfill Time Bonus Order FlBonus Handled 2 Order ld 3 23-099 4 23-980 5 32-098 6 33-087 7 24-651 8 22-095 9 26-987 10 22-095 11 26-987 12 32-456 Time Recd 11/6/2018 11:00 Tim 11/10/2018 8:20 Jill 11/7/2018 9:05 Tim 11/9/2018 14:30 Tim ByTime Shipped (Hours) Amount 11/7/2018 14:30 27.5 11/13/2018 11:3575.25 Amount $1.25 15 $1.00 20 SO.75 30 $0.50 $0.25 50 S0.00 11/8/2018 11:45 11/12/2018 10:30 11/14/2018 9:45 11/14/2018 11:45 11/14/2018 16:45 11/15/2018 15:45 11/15/2018 14:45 11/16/2018 15:15 11/10/2018 13:30 Jill 11/11/2018 8:30 Jill 11/12/2018 8:30 Tim 11/13/2018 8:45 Jill 11/14/2018 9:50 Tim 11/15/2018 9:25 Jill Your task is to add formulas in columns E and F. Your formula in column E should calculate the total number of hours it took to fulfill the order, i.e the difference in time between order shipped and order recd (in hours). Your formula for column F should use the reference table to lookup (hint: VLOOKUP) the bonus amount for each order filled. The bonus amount depends upon the number of hours it took the order to get fulfilled

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

The Art Of Safety Auditing A Tutorial For Regulators

Authors: Sasho Andonov

1st Edition

0367351080, 978-0367351083

More Books

Students also viewed these Accounting questions