Question: 5 . On the Enrollment worksheet, in cell A 1 3 , insert a table using range A 1 3 :D 1 0 6 and

5. On the Enrollment worksheet, in cell A13, insert a table using range A13:D106 and the top row as the headers.6. In cell D14, enter an HLOOKUP function that will look up the class number in cell B14 and will use the Classinfo table to return the Fee from the fifth row of the table with an exact match.7. In cell E13, create a new column header named Class_ Name. In cell E14, enter an HOOKUP function that will look up the class number in cell B14 and use the Classinfo

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 Databases Questions!