Make an excel spreedsheet following these guidelines: $1.$ Enter a main title of Plant Store Payroll for the spreadsheet in cell I$1.$ Merge and center this title in cells I$1$:N$1,$ add bold and italics, use a font size of $18.$ Make the background Green Accent $6$ with White Text.

$2.$ Enter a subtitle of Pay Period January $1-7,2019$ in cell I$2.$ Merge and center this subtitle in cells I$2$:N$2,$ add bold and italics, use a font size of $14.$

$3.$ Enter the following column titles beginning in row $4,$ column A: Last Name, First Name, Family Plan?, Employee #$,$ Hourly Wage, Hours Worked, Regular Salary, OT Hourly Wage, OT Hours Worked, OT Salary, Gross Pay, Federal Income Tax, State Income Tax, FICA, Social Security Tax, Health Insurance, Dental Insurance, $401$K$,$ Union Dues, Stock Option Plan, Net Pay. Use line breaks for titles that contain more than one word, bold, and center all titles.

$4.$ In cell A$21,$ type Fed; in A$22,$ State; in A$23,$ FICA; in A$24,$ SS$,$ and in A$25,$ Union. In B$21,8\%,$ B$22,6\%,$ B$23,4\%,$ B$24,3\%,$ B$25,$ $$2\mathrm{.}50.$

$5.$ Enter the following information for the Last Name column: Smith, Thomas, McDonald, Cunningham, Tope, Tannucci, Stone, Ropes, Dovens, Bruce, Rock, Harris, Jones, Catamore, Manchester. Right align all names.

$6.$ Enter the following information for the First Name column: John, Aaron, Jacob, Brenda, Jennifer, Matthew, Greg, Angela, Grace, Timothy, Louise, Jack, Kevin, Dennis, Michael. Be sure to keep names left aligned.

$7.$ Enter N in the Family Plan? Column for the following employees: Smith, Cunningham, Tope, Stone, Harris, Jones, Manchester; enter a Y for the rest.

$8.$ Enter the following information for the Employee # column: $31496,29931,13764,41392,33277,34930,21543,27130,19965,21063,31380,22619,47318,45601,39393.$ Center all information.

$9.$ Enter the following information for the Hourly Wage column: $21\mathrm{.}75,23\mathrm{.}90,27\mathrm{.}15,20\mathrm{.}00,22\mathrm{.}10,21\mathrm{.}98,24\mathrm{.}12,24\mathrm{.}85,28\mathrm{.}25,25\mathrm{.}00,21\mathrm{.}06,24\mathrm{.}75,20\mathrm{.}00,21\mathrm{.}00,22\mathrm{.}00.$ Center all information, apply currency with symbol and $2$ decimal places.

$10.$ Enter the following information for the Hours Worked column: $40,31,40,40,29,22,40,40,38,40,40,40,15,40,40.$ Center all information.

$11.$ Enter the following information for the OT Hours Worked column: $5,0,1,10,0,0,6,7,0,13,15,20,0,8,12.$ Center all information.

$12.$ Enter a formula to compute all employees Regular Salary. Apply currency format with symbol and two decimal places.

$13.$ Enter a formula to compute all employees OT Hourly Wage $($even for those employees that do not have OT hours$).$ Apply currency format with two decimal places and symbol. OT is time and a half.

$14.$ Enter a formula to compute OT Salary for those employees that have worked OT$.$ Apply currency format with symbol and two decimal places.

$15.$ Enter a formula to compute Gross Pay for all employees. Apply currency format with symbol and two decimal places.

$16.$ Enter a formula to compute all employees Federal Income Tax using an absolute reference to the appropriate cell. Apply currency with two decimal places and symbol.

$17.$ Enter a formula to compute all employees State Income Tax using an absolute reference to the appropriate cell. Apply currency with symbol and two decimal places.

$18.$ Enter a formula to compute all employees FICA using an absolute reference to the appropriate cell. Apply currency with symbol and two decimal places.

$19.$ Enter a formula to compute all employees Social Security Tax using an absolute reference to the appropriate cell. Apply currency with symbol and two decimal places.

$20.$ Using an IF statement, based on whether they have a family or not, enter a $$70\mathrm{.}19$ Health insurance rate no and a rate of $$114\mathrm{.}80$ for yes. Apply currency with symbol and two decimal places.

$21.$ Using an IF statement, based on whether they have a family or not, enter a $$3\mathrm{.}25$ dental insurance for N: For all remaining employees with a Y$,$ enter a rate of $$5\mathrm{.}80.$ Apply currency with symbol and two decimal places.

$22.$ The following employees are taking advantage of the $401$K option for $$10\mathrm{.}00$: Thomas, Cunningham, Tope, Tannucci, Ropes, Dovens, Rock, Harris, Jones, Catamore. Apply currency symbol with two decimal places.

$23.$ All employees belong to the union. The union dues are taken out every week at a rate of $$2\mathrm{.}50.$ Apply currency with symbol and two decimal places.

$24.$ The following employees contribute to the stock option plan for $$3\mathrm{.}25$: McDonald, Stone, Dovens, Bruce, Rock, Harris, Manchester. Apply currency with symbol and two decimal places.

$25.$ Enter a formula to compute the Net Pay for all employees. Be sure to subtract all deductions from the Gross Pay of each employee. Apply currency with symbol and two decimal places.

$26.$ Widen columns if necessary. Be sure to print out both a standard and a formula copy.