Please help with this project. Need the work to be done using excel. Let me know how I can download it when it$$s ready.

Steps to complete This Project

Mark the steps as checked when you complete them.

$1.$ Open the EX$2019-$IndependentProject$-1-6$ start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it$.$ The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$

$2.$ Apply the Organic theme for the workbook.

$3.$ Type Livingood Income Tax and Accounting in cell A$1$ and press Enter.

$4.$ Type Accounts Receivable in cell A$2$ and press Enter.

The table displays the data to be entered in rows $5$ through $15.$

A B C D E F

Livingood Income Tax and Accounting

Accounts Receivable

Date Invoice Client ID Amount Payment Date Payment Type

$8/18/20191001$ LITA$0014258/28/2019$ Check

$8/20/20191002$ LITA$0024508/29/2019$ EFT

$8/22/20191003$ LITA$0034758/30/2019$ Credit card

$8/24/20191004$ LITA$0045008/31/2019$ Check

$8/26/20191005$ LITA$0055259/1/2019$ EFT

$8/28/20191006$ LITA$0065509/2/2019$ Credit card

$8/30/20191007$ LITA$0075759/3/2019$ Check

$9/1/20191008$ LITA$0086009/4/2019$ EFT

$9/3/20191009$ LITA$0096259/5/2019$ Credit card

$9/5/20191010$ LITA$0106509/6/2019$ Check

$9/7/20191011$ LITA$0116759/7/2019$ EFT

$5.$ Type the labels in row $4$ as shown here in Figure $1-104$:

The table displays the data to be entered in row $4.$

A B C D E F

Date Invoice Client ID Amount Payment Date Payment Type

$6.$

Figure $1-104$ Data to be entered

$7.$ AutoFit columns E:F to display each label in row $4.$

$8.$ Type $8/18/19$ in cell A$5$ to enter the date. In cell A$6,$ type $8/20/19$ to set a pattern for the dates.

$9.$ Select cells A$5$:A$6$ and use the Fill Handle to fill in dates to cell A$15.$

$10.$ Select cell B$5$ and type $1001$ for the first invoice number. In cell B$6,$ type $1002$ to set a pattern for the invoice numbers.

$11.$ Select cells B$5$:B$6$ and use the Fill Handle to fill in invoice numbers to reach cell B$15.$

$12.$ Type LITA$001$ in cell C$5$ as the first client ID$.$ In cell C$6,$ type LITA$002$ to set a pattern.

$13.$ Use the Fill Handle to complete the client ID numbers.

$14.$ Type $425$ in cell D$5.$ In cell D$6,$ type $450$ to set the pattern and fill in the amounts.

$15.$ Type $8/28/19$ in cell E$5$ to enter the date. In cell E$6,$ type $8/29/19$ to set a pattern for the dates. Fill the rest of the cells to E$15.($Figure $1-105).$

$16.$

Figure $1-105$ All columns filled

$17.$ Type Check in cell F$5.$ Type EFT in cell F$6.$ Type Credit card in cell F$7.$ Fill the rest of the cells to F$15.$

$18.$ Format data.

a$.$ Select cells C$5$:C$15,$ increase the indent one time, and AutoFit the column. Do the same for the payment type data.

b$.$ Format the values in column D as Accounting Number Format.

c$.$ Select cells A$1$:F$2$ and click the Alignment launcher $[$Home tab$].$ Click the Horizontal arrow, choose Center Across Selection, and click OK$.$ Change the font size to $18.$

d$.$ Select the labels in row $4$ and apply bold and center alignment.

e$.$ AutoFit columns that do not show all the data.

f$.$ Apply All Borders to cells A$4$:F$15.$ Apply an Outside Border for cells A$1$:F$2.$

g$.$ Apply the Green, Accent $1,$ Lighter $60\%$ fill color $($fifth column$)$ to cells A$1$:F$2$ and A$4$:F$4.$

h$.$ Apply the Green, Accent $1,$ Lighter $60\%$ fill color $($fifth column$)$ to cells A$6$:F$6.$

i$.$ Use the Ctrl key to select the data in rows $8,10,12,$ and $14$ and apply the same fill color.

$19.$ Rename Sheet$1$ as AR and set the tab color to Green, Accent $1($fifth column$).$

$20.$ Define page layout and add document properties.

a$.$ Center the worksheet horizontally on the page.

b$.$ Create a header with the sheet name in the left section and your name in the right section.

c$.$ Delete an existing author name and key your first and last name as Author in the Properties dialog box.

d$.$ Type Receivables in the Title box $($Figure $1-106).$

Figure $1-106$ Properties entered in dialog box

e$.$ Preview your worksheet.

$21.$ Save and close the workbook $($Figure $1-107).$

Figure $1-107$ Excel $1-6$ completed