Question: Need help with the formula being generated in J4 A B H I J K WNL CH Course ID Session 6120 3 Number Enrolled Total

Need help with the formula being generated in J4Need help with the formula being generated in J4

A B H I J K WNL CH Course ID Session 6120 3 Number Enrolled Total Cost #REF! ! Georgia Medical Center 4 5 7 $ $ $ 800 250 225 0 0 0 $ $ $ C. In cell H7, enter a formula without using a function that uses structured references 14 J4 x fx =VLOOKUP(J2, Courses, Courses[Enrolled), (FALSE)) to multiply the price of the first course ([@Price]) by the number of people enrolled ([@Enrolled]). C D E F G d. Apply the Accounting number format with zero decimal places to the newly created column. Continuing Education - Spring e. Add a Total Row to the Courses table, which automatically totals the amounts in 6 Course Course Name the Total Charged column. Session Price Capacit CapacitEnrolle Open Sea Total Charge 5074 Emergency Care 0 $ 9,600 f. 8 5102 Ethics for RNS In cell B29, use the total row to display the count of the continuing education 3,750 5133 IV Therapy for LPNs 4,500 courses. 5277 Cardio Symposium $ 1,000 30,000 5380 Emergency Care $ 9,600 Justin has created an area in the range J1:L4 for looking up data in the Courses table. IV Therapy for LPNs 3,825 First, he wants to find the number of people enrolled in a specific course. He has already 5522 Ethics for RNS 3,500 5567 entered the course ID in cell J2. Emergency Care 9,600 5606 Bedside Best Practice 225 12 2.700 Look up the number of people enrolled in the course with Course ID 6120 as follows: Acute Care Review 0 $ 9,600 Oncology Review 7,500 a. a. In cell 34, begin to enter a formula using the VLOOKUP function. IV Therapy for LPNs 2,925 5912 Internal Medicine Nev 5,950 b. Use the Course ID in cell J2 as the value to look up. Bedside Best Practice 225 5 2,250 6012 Bedside Best Practice 2,025 C. Use a structured reference to the Courses table as the table to search. Oncology Review 7,500 6060 Ethics for RNs $ 2,500 d. Display the value in column 6 of the table. 24 Cardio Symposium $ 1.000 9 21,000 Holistic Nursing 0 3,375 e. Specify an exact match (FALSE) for the range lookup. Cardio Symposium $ 1,000 15 15,000 Oncology Review $ 5,250 12 15 20 30 12 17 14 12 5482 800 225 250 800 $ $ $ $ 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 5708 5765 5903 1 1 1 1 2 2 2 3 1 1 1 3 1 2 3 2 3 2 1 3 3 2 $ $ $ $ $ $ $ $ $ $ $ $ 800 750 225 350 12 15 20 30 12 20 15 12 15 12 10 20 20 15 15 10 15 30 15 30 10 20 0 0 3 1 0 3 0 0 7 3 5 6 0 5 9 0 5992 12 10 13 17 10 9 10 10 21 15 15 7 13 225 750 250 6031 $ $ $ $ $ $ $ $ $ $ $ $ 225 25 26 27 28 6120 6233 6485 6539 6737 Internal Medicine Nei $ 750 350 3 7 $ 4 550

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 General Management Questions!