Instructions Part $1$:

$1.$ Using the above data, create the worksheet in Microsoft Office Excel $($or OpenOffice Calc$),$

shown in column A through column F in Figure $1.$

$2.$ Important: you need to use formulas to calculate the numbers in the Total rows and the Total

columns instead of typing those numbers manually

$3.$ Format the worksheet title in cell A$1$ as $24-$point, bold, text color red, with a font you choose.

$4.$ Format the worksheet subtitle in cell A$2$ as $18-$point, bold, with a font you choose

$5.$ Merge and center the worksheet title in cell A$1$ across column A through column F

$6.$ Merge and center the worksheet subtitle in cell A$2$ across column A through column C

$7.$ Format the text in the ranges of A$3$:F$3$ and A$10$:F$10$ with the Heading $2$ cell style

$8.$ Format the numbers in the ranges of A$4$:F$9$ and A$11$:F$14$ with a cell style you choose

$9.$ Format the ranges A$9$:F$9$ and A$14$:F$14$ with the Total cell style

$10.$ Format the numbers in ranges B$4$:E$8$ and B$11$:E$13$ using comma number style

$11.$ Format the numbers in ranges F$4$:F$8$ and B$9$:F$9$ using accounting number style

$12.$ Format the numbers in ranges F$11$:F$13$ and B$14$:F$14$ using accounting number style

$13.$ Adjust the column width for all columns in best fit