Steps for

d Excel $365/2021$

Module $5$: SAM Project la

number of continuing education courses offered.

Provide this information for Justin as follows:

a$.$ Insert a new column in the table to the right of the Open Seats column.

b$.$ Use Total Charged as the column heading of the new column.

c$.$ In cell H $7,$ enter a formula without using a function that uses structured references to multiply the price of the first course $([$@Price$])$ by the number of people enrolled $([$@Enrolled$]).$

d$.$ Apply the Accounting number format with zero decimal places to the newly created column.

e$.$ Add a Total Row to the Courses table, which automatically totals the amounts in the Total Charged column.

f$.$ In cell B$29,$ use the total row to display the count of the continuing education courses.

Justin has created an area in the range J$1$:L$4$ 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 J$2.$

Look up the number of people enrolled in the course with Course ID $6120$ as follows:

a$.$ In cell J$4,$ begin to enter a formula using the VLOOKUP function.

$6.$ Use the Course ID in cell $J2$ as the value to look up$.$

e$.$ 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.

lustin also wants to calculate the total charges for courses offered in a specific session.

te has already entered the session number in cell K$2.$

alculate the total charges for courses offered in Session $3$ as follows:

In cell K$4,$ begin to enter a formula using the DSUM function.

Use the Courses table $($range A$6$:H$29)$ including the headers and the data as the formula database.

Use the Total Charged field header $($in cell H$6)$ as the field to summarize.

Use the values Justin set up in the range $K1$:$K2$ as the criteria.