Question: Part 2 1. Create a new workbook called ELI-FCS-Treatment.xlsx. 2. Place the following information on Sheet1. Week 30-Minute 45-Minute 60-Minute Treatments Treatments Treatments Wk 1

Part 2 1. Create a new workbook called
Part 2 1. Create a new workbook called ELI-FCS-Treatment.xlsx. 2. Place the following information on Sheet1. Week 30-Minute 45-Minute 60-Minute Treatments Treatments Treatments Wk 1 3 6 0 Wk 2 5 6 Wk 3 8 2 Wk 4 2 Schedule of Fees 60 minutes $74 45 minutes $60 30 minutes $50 3. Rename the sheet to Treatments. Change the color of the tab to Blue. 4. Determine the following: a) The total number of treatments each week b) The total number of 30-, 45-, and 60-minute treatments over four weeks c) The average number of 30-, 45-, and 60-minute treatments over four weeks d) The weekly income e) The monthly income f) The total number of minutes worked each week 5. Use an IF statement to determine whether the clinic has met its goal of earning at least $600 per week. If the weekly income is $600 or more, the IF statement should return the value Target met; if the weekly income is less than $60, the statement should return the value Target not met

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!