paste the label in cell F$3$ to cell A$12.$

the spelling error in the label in cell A$6.$

g$.$ Edit cell A$8$ to correct the is Immunology.$)$ spelling is Ophthalmology.$)$ Quarter $1$ in cell B$3,$ then use Auto Fill to enter Quarter $2,$ Quarter $3,$ and Quarter $4$ in the range C$3$:E$3.$

Create a formula in cell $F4$ that uses cell references and totals the quarterly reimbursements for the Cardiology department.

Use the fill handle to copy the formula in cell F$4$ to the range F$5$:F$11.$

k$.$ Using AutoSum, create a formula in cell B$12$ that totals the first

TABLE $1-4$

quarter reimbursements for all the departments.

Copy the formula in cell B$12$ to the range C$12$:E$12.$

n$.$ Enter a formula in cell B$14$ to calculate a $20\%$ increase in the first quarter reimburs need to add B$12$ to B$12$ multiplied by $.20.$ Use parentheses if necessary to follow th

a$.$ Enter a function, using the help of AutoComplete, in cell B$15$ that calculates the a amount for the departments.

$.$ Copy the formulas in the range $B14$:$B15$ to the range $C14$:$E15.$

Switch to Page Break view and adjust the page break to the bottom of row $18$

$.$ Switch to Normal View, then zoom the worksheet to $120\%.$

Turn on gridlines for printing.

Change the page orientation to landscape.

Preview the worksheet in Backstage view, then use the Page Setup dialog box to and vertically on the page. Compare your screen to FIGURE $1-25.$

Submit your work to your instructor as directed.

Close the workbook, then exit Excel.