SDSU Wilson Home Entertainment Systems Statement of Cash Flow Project
Question Description
As accounts receivable clerk for Livingood Income Tax and Accounting, you track daily payments from clients in an Excel worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers.
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.
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
Figure 1-104 Data to be entered
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/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
8/26/2019
1005
LITA005
525
9/1/2019
EFT
8/28/2019
1006
LITA006
550
9/2/2019
Credit card
8/30/2019
1007
LITA007
575
9/3/2019
Check
9/1/2019
1008
LITA008
600
9/4/2019
EFT
9/3/2019
1009
LITA009
625
9/5/2019
Credit card
9/5/2019
1010
LITA010
650
9/6/2019
Check
9/7/2019
1011
LITA011
675
9/7/2019
EFT
Figure 1-105 All columns filled
Format data.
Define page layout and add document properties.
Figure 1-106 Properties entered in dialog box
Figure 1-107 Excel 1-6 completed
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."