a$.$ Cross State Trucking Brian Eagleton is a dispatch manager a: hauler based in Chicago, Illinois. Brian needs to develop a workbook that wil mmarize the driving log of Cross State drivers. Brian has a month of travel data from one the company's drivers and wants you to create a workbook that he can use to analyze this data. Complete the following:

Open the NP$\_$EX$\_1-2.$xlsx workbook located in the Excel$1>$ Case$1$ folder included with your data files. Save the workbook as NP$.$ EX$\_1\_$Trucking in the location specified by your instructor.

Change the name of the Sheet $1$ worksheet using Travel Log as the name, and then move it to the end of the workbook. Rename the Sheet$2$ worksheet using Documentation as the name.

In the Documentation sheet, enter your name in cell B$3$ and the current date in cell B$4.$ Move the Documentation sheet to the front of the workbook.

Go to the Travel Log worksheet. Resize the columns so that all the data is visible in the cells.

Between the Odometer Ending column and the Hours column, insert a new column. Enter Miles as the column label in cell $14.$

In the Miles column, in the range $15$:$125,$ enter formulas to calculate the number of miles driven each day by subtracting the odometer beginning value firom the odometer ending value.

Between the Price per Callon column and the Seller column, insert a new column. Enter Total Fuel Purchase as the label in cell N$4.$

In the Total Fuel Purchase column, in the range $N5,N25,$ enter formulas to calculate the total amount spent on fuel each day by multiplying the gallons value by the price per gallon value.

In cell B$5,$ use the COUNT function to calculate the total number of driving days using the values in the Date column in the range D$5$:$025.$

In cell B$6,$ use the SUM function to calculate the lutal number of driving hours using the values in the Hours column in the range J$5\mathrm{.}125.$

In cell B$7,$ enter a formula that divides the hows of criving value icell B$6$i by the days of driving