done his research and ordered the most popular games to fi ll the shelves
recently arrived.
Vendors generally off er a cash discount for early payment to customers who
buy on account. Your employer intends to pay the vendors within 15 days of
receipt of the invoices in order to take advantage of the discounts off ered. For
the buyer, the discount is called a purchase discount; for the seller, it is called
a sales discount. The owner asks you to help calculate what is owed to each
vendor.
The following acti vity illustrates how spreadsheets can be used to calculate a
company's purchase discounts, sales tax, and amount owed to vendors.
2. Type the data as shown.
3. Format the width of column A to 24.0 and left align.
4. Format the width of column B to 11.0 and right align.
9. Format cells D10 G40 as numbers displaying 2 decimal places with a comma