Assessment

$7$

Create and Use a Template

Open $7-$BillingsDec$16.$xlsx and then turn on the display of row and column headers.

Make the following changes to the workbook:

a$.$ Select and delete all the data below the column headings in row $4.$

b$.$ Delete the text in cell A$3.$

c$.$ Change the subtitle in cell A$2$ to Associate Weekly Billing Summary.

Save the revised workbook as a template named Billings$-$StudentName.xltx$,$ with your name substituted for StudentName.

Close Billings$-$StudentName.xltx$.$

Start a new workbook based on the Billings$-$StudentName template.

Type December $16$ to $20,2024$ in cell A$3.$

Enter the two billings shown in Table $7\mathrm{.}3.$

Table $7\mathrm{.}3$ Assessment $7$

$\backslash$table$[[$File$,$Client,Date,$\backslash$table$[[$Last$],[$Name$]],\backslash$table$[[$First$],[$Name$]],$Attorney,Area,$\backslash$table$[[$Billable$],[$Hours$]],$Rate$],[$IN$-774,10665,\frac{12}{17}\frac{?}{2024},$Rankin,Jan,$\backslash$table$[[$Mauren$],[$Myers$]],$Insurance,$4\mathrm{.}50,300\mathrm{.}00],[$EP$-895,10996,\frac{12}{17}\frac{?}{2024},$Knox,Velma,$\backslash$table$[[$Rosa$],[$Rosinez$]],$Estate,$3\mathrm{.}50,300\mathrm{.}00]]$

Using the highlighter tool on the Draw tab and the Snap to Cells option, highlight cell G$6$ with a pale blue color.

Save the worksheet as an Excel workbook named $7-$Billings.

Preview and then close $7-$Billings.xlsx$.$

Copy Billings$-$StudentName.xltx from the $[[$This PC:$]$DocumentsiCustom Office Templates folder to the EL$2$C$7$ folder on your storage medium. Close the File Explorer window.