In cell J5, enter a formula to calculate the gross education revenue by subtracting the education discount rate from 1, multiplying the result by the cost per attendee and multiplying by the number of education attendees. Copy the formula to the range J6:J8.

 

AutoSave Off H - Mastrapa_e01_grader_a1.xls File Home Insert Page Layout Formulas Data Review View Help Search Cut Calibri 11 A A Wrap Text General +XIKFK Copy Paste BIU v 3 A x Merge & Center Y $ % 95008 Conditional Format as PVVC4 Format Painter Formatting Table Clipboard Font Alignment Number J5 fx A B C 1 2 E June Training Workshops H K M 3 # of Attendees Gross Revenue Educatio Cost per n Corporat Educatio Corporat Educatio 4 Workshop 5 Project Management 6 Systems Analyst Start Date End Date # of Days Attendee Discount 6/4/2018 6/6/2018 e n e n Total 3 1985 0.1 22 2 43670 6/11/2018 6/15/2018 5 2199 0.12 14 1 30786 7 Big Data Analytics 6/18/2018 6/22/2018 5 2199 0.15 12 5 26388 8 Project Management 6/25/2018 6/29/2018 5 1985 0.1 10 10 19850 9 10 11 12 13 14 15 16