Computer info systems

1. Create a new workbook and save it as [your initials] Excel 1-6. If the 

workbook has opened in Protected View, click Enable Editing in the security 

bar.  

2. Apply the Organic theme for the workbook.  3. In cell A1, type Livingood Income Tax and Accounting and press Enter   4. In cell A2, type Accounts Receivable and press Enter.  5. In row 4, type the labels as shown here in Figure 1-104: 1-104 Data to be  entered   6. AutoFit or widen the columns to display each label in row 4 in its cell.  7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set  a pattern for the dates.  8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell A15.   9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to  set a pattern for the invoice numbers.   10. Select cells B5:B6 and use the Fill Handle to fill in invoice numbers to  reach cell B15.   11. In cell C5, type LITA001 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 the first two payment dates in column E and fill the cells (Figure  1-105). 1-105 All columns filled  15. Type the first three payment types in cells F5:F7 and then use the Fill  Handle to complete the cells in column F.   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:A2 and change the font size to 18. Center the labels  across cells A1:F2.  

d. Select the labels in row 4 and apply bold format 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 to cells A1:F2 and  A4:F4.   h. Apply the Green, Accent 1, Lighter 60% fill color 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.   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). e. Preview your work