Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 1 . Justin has created an area in the range J 1 :L 4 for looking up data in the Courses table. First, he

11. Justin has created an area in the range J1:L4 for looking up data in the Courses table. First, he wants to find the number of people enrolled in a specific course. He has already entered the course ID in cell J2.
Look up the number of people enrolled in the course with Course ID 6120 as follows:
a. In cell J4, begin to enter a formula using the VLOOKUP function.
b. Use the Course ID in cell J2 as the value to look up.
c. Use the Courses table as the table to search.
d. Display the value in column 6 of the table.
e. Specify an exact match (FALSE) for the range lookup.
12. Justin also wants to calculate the total charges for courses offered in a specific session. He has already entered the session number in cell K2.
Calculate the total charges for courses offered in Session 3 as follows:
a. In cell K4, begin to enter a formula using the DSUM function.
b. Use the Courses table (range A6:H29) including the headers and the data as the formula database.
c. Use the Total Charged field header (in cell H6) as the field to summarize.
d. Use the values Justin set up in the range K1:K2 as the criteria.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions