Cases

nal...

Create a new Excel sheet in which you will find the delivery cost for each delivery.

a$.$ Create a new sheet that has information for each delivery. Name this sheet "lookup."

Rat...

b$.$ In this lookup sheet, look up the hourly rate for the driver for each delivery. Do not enter this information manually! Use the VLOOKUP function.

c$.$ For each delivery, calculate the delivery cost as hourly rate for the driver multiplied by time $($hours$).$

Fill in the table below for the first ten records.

$2.$ Create a new Excel sheet that aggregates the data contained in the lookup sheet to show each driver's activity analysis.

a$.$ Create a pivot table in a new sheet; name this new sheet "pivot table."