Homework answers / question archive / Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypocx + ? O mthoodcc

Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypocx + ? O mthoodcc

Business

Share With

Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypocx + ? O mthoodcc.simnetonline.com/sp/assignments/projects/details/6078795 - Mc Graw Hill ASSIGNMENTS LIBRARY GRADES Alabbas, Adnan Sign Out C IMPORTANT: If you are a Canadian user, be sure to verify that your browser and Microsoft Office use the same country settings. See here for a Help topic on how to change your settings. 1. Open the EX2019-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 A1 and press Enter. 4. Type Accounts Receivable in cell A2 and press Enter. 5.Type the labels in row 4 as shown here in Figure 1-104: B E Date Invoice Client Amount Payment Date Payment Type Figure 1-104 Data to be entered 6.AutoFit columns E:F to display each label in row 4. 7. Type 8/18/19 in cell A5 to enter the date. In cell A6, type 8/20/19 to set a pattern for the dates. 8. O Select cells A5:A6 and use the Fill Handle to fill in dates to cell A15. 9. Select cell B5 and type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the invoice numbers. Reset Progress Back to top 10. Select cells B5:B6 and use the Fill Handle to fill in invoice numbers to reach cell B15. 11. Type LITA001 in cell C5 as the first client ID. In cell C6, type LITA002 to set a pattern. Adnan.Alabbas-Ex....xlsx A Show all 1 ? ???? ra ( 2:46 AM 5/8/2021 ? Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypoc X + O mthoodcc.simnetonline.com/sp/assignments/projects/details/6078795 - Mc Graw Hill ASSIGNMENTS LIBRARY GRADES Alabbas, Adnan Sign Out C 11. Type LITA001 in cell C5 as the first client ID. In cell C6, type LITA002 to set a pattern. 12. Use the Fill Handle to complete the client ID numbers. 13. Type 425 in cell D5. In cell D6, type 450 to set the pattern and fill in the amounts. 14. Type 8/28/19 in cell E5 to enter the date. In cell E6, type 8/29/19 to set a pattern for the dates. Fill the rest of the cells to E15. (Figure 1-105). A B ? D E F Livingood Income Tax and Accounting Accounts Receivable Date Invoice Client ID Amount Payment Date Payment Type 8/18/2019 1001 LITA001 425 8/28/2019 Check 8/20/2019 1002 LITA002 450 8/29/2019 EFT 8/22/2019 1003 LITA003 475 8/30/2019 Credit card 8/24/2019 1004 LITA004 500 8/31/2019 Check Reset Progress Back to top 8/26/2019 1005 LITA005 525 9/1/2019 EFT 8/28/2019 1006 LITA006 550 9/2/2019 Credit card Adnan.Alabbas-Ex....xlsx A Show all 1 ? ???? ra ( 2:47 AM 5/8/2021 ? Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypoc X + O mthoodcc.simnetonline.com/sp/assignments/projects/details/6078795 - Mc Graw Hill ASSIGNMENTS LIBRARY GRADES Alabbas, Adnan Sign Out C 15. Type Check in cell F5. Type EFT in cell F6. Type Credit card in cell F7. Fill the rest of the cells to F15. 16. Format data. a. Select cells C5:C15, 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 A1:F2 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 A4:F15. Apply an Outside Border for cells A1:F2. g. Apply the Green, Accent 1, Lighter 60% fill color (fifth column) to cells A1:F2 and A4:F4. h. Apply the Green, Accent 1, Lighter 60% fill color (fifth column) to cells A6:F6. i. Use the Ctrl key to select the data in rows 8, 10, 12, and 14 and apply the same fill color. 17. Rename Sheet1 as AR and set the tab color to Green, Accent 1 (fifth column). 18. 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). Reset Progress Back to top Excel 1-6 Properties e. Preview your worksheet. General Summary Statistics Contents Custom 19. Save and close the workbook (Figure 1-107). Title: Receivables Adnan.Alabbas-Ex....xlsx A Show all 1 ? ???? ra ( 2:47 AM 5/8/2021 ? Mail - Adnan Ali Alabbas - Out ? Microsoft Office Home ? MSIMnet - Excel 2019 In Practice X G take screenshot windows 10 - ? S Ask a new question - Studypoc X + O mthoodcc.simnetonline.com/sp/assignments/projects/details/6078795 - Mc Graw Hill U ASSIGNMENTS LIBRARY GRADES Alabbas, Adnan Sign Out C 19. Save and close the workbook (Figure 1-107). Title: Receivables Subject: Author: Student Name Manager Company Category: Keywords: Comments: Hyperlink base: Template Save Thumbnails for Al Excel Documents Cancel Figure 1-106 Properties entered in dialog box AR Livingood Income Tax and Accounting Accounts Receivable Dake Lancies Client ID Amount Pict Date POS lo UTADIS S 10 UTAZ5.300 EFT 8/22/22 100 UITS TSO 3129 lon LITAT $300 31 106 UTAS 5300 902 EFT 100 UTNESS SOON TOUTATS STS 9179 102 UTRES 97439EPT 100 UTAR200 9/5/30 cm 1000 UTAS 9/7/2009 1000 UTADOS 9/7/2009 EPT 8/20/2009 Reset Progress Back to top Adnan.Alabbas-Ex....xlsx A Show all 1 ? ???? ra ( 2:47 AM 5/8/2021