How do I do this in excel?

For Dotober $2021,$ TruBent Machining's manufacturing activities generated

the records shown in the Data sheet. TruBent worked on numerous Jobs that month

and each data record pertains to the inputs for each job. The records are in

chronological order and each record has fields for :Year, Month, Day,

Job No$.,$ Type, Sub$-$Category, and Quantity $($measured in appropriate input units $--$

for example, labor and machine quantities are measured in hours.$)$

In order to complete the assignment you will need to do the following activities:

Watch video and use the practice data $($optional if you already know to work with

Excel Tables and PivotTables$).$

Prepare the Data by adding Unit Costs and Item Costs as explained on the Data tab.

Create an Ercel table using the data in the Data tab.

Use the Excel table to create a PivotTable located in the Pivot tab.

Answer the questions given below.

a$.$ Some of the questions pertain to the specific job high$-$lighted in Green below. Note

that this job is keyed to your UINN. Therefore be sure that you have entered

your UIN and Name on the "Name & ID$"$ tab.

b$.$ Some of the questions pertain to the entirety of the data set and not a particular job.

Among the objectives are to determine the total amount of costs added in Dotober to WIP and

to Job No$.$

$6509$

The Costs per unit for each type of input by category are given in the table below.

Machine costs are treated as overhead. Direct costs pertain to materials and labor.

There are two types of labor, "skilled" and "normal". Each has a separate

cost per labor hour. There are three types of materials used by TruBent.

once again each material is measured in an appropriate input unit and the

cost per unit is with respect to that input unit.

Required$-$Part $1$

Questions $1$ to $6$ pertain only to Job No$.===>$