59
Accounts Payable
26
13. Compute the formulas for the fi rst company, ABC Game Industries, as follows
(assume the sales tax is 6%):
a. PURCHASE DISCOUNT=AMOUNT BILLED*% DISCOUNT > In cell D10, type
=B10*C10
b. SUBTOTAL=AMOUNT BILLED-PURCHASE DISCOUNT > In cell E10, type
=B10-D10
c. SALES TAX=6%*SUBTOTAL > In cell F10, type
=6%*E10
d. AMOUNT OWED=SUBTOTAL+SALES TAX > In cell G10, type
=E10+F10
14. Use the AutoFill feature to copy the formulas down for the remaining
companies.
15. Enter formulas to calculate the Totals, Average, Maximum, and Minimum for
column B and columns D G.
16. Bold rows 37 40.
17. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
18. Carefully proofread your work for accuracy.
19. Save the spreadsheet as ACCOUNTS PAYABLE.
20. Analyze the changes made to the data in the spreadsheet.
21. Set the Print Area to include all cells containing data in the spreadsheet.
22. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page.
23. Print a copy of the spreadsheet if required by your instructor.
ACTIVITY
For Evaluation Purposes Only