The owner of an auto dealership would like to create a spreadsheet in which sales performance information regarding each salesperson can be tabulated. She would like to use the following format:

Column A is to contain the name of each salesperson; column B, the gross sales; column C, the cost; column D, the profit; and column E, the commission, calculated at 8% of the profit. Construct a spreadsheet for 20 employees.

Transcribed Image Text:

Spreadsheet Application A NAME 1 2 John Adams 2345 B SALES 100,000 C COST 80,000 X D E PROFIT COMMISSION 20,000 1,600