Scribd
Upload
1K views2 pages

MS Excel Exercise 3

The document provides instructions for two Excel exercises. The first involves creating a worksheet to calculate commissions and total salaries for employees, then adding formulas to find totals, averages, highest, lowest, and counts. The second uses IF statements to calculate tax amounts and rates based on item prices, then find counts, averages, minimums and maximums.

Uploaded by

Manuelo Vangie
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
1K views2 pages

MS Excel Exercise 3

The document provides instructions for two Excel exercises. The first involves creating a worksheet to calculate commissions and total salaries for employees, then adding formulas to find totals, averages, highest, lowest, and counts. The second uses IF statements to calculate tax amounts and rates based on item prices, then find counts, averages, minimums and maximums.

Uploaded by

Manuelo Vangie
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

MS Excel Exercise 3

1. Add another sheet to your previous workbook and create the worksheet shown below.
2. Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15,
Columns E & F: 14.
3. Enter the formula to find COMMISSION for the first employee.
The commission rate is 2% of sales, COMMISSION = SALES * 2%
Copy the formula to the remaining employees.
4. Enter the formula to find TOTAL SALARY for the first employee where:
TOTAL SALARY = SALARY + COMMISSION
Copy the formula to the remaining employees.
5. Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values.
Copy the formula to each column.
6. Format numeric data to include commas and two decimal places.
7. Align all column title labels horizontally and vertically at the center.
8. Save your work and call your teacher to check your output.
MS Excel Exercise 4

Working with the IF Statement.

For the above table find the following:


1. TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100).
2. TOTAL PRICE BEFORE TAX =NO. OF ITEMS * ITEM PRICE.
3. TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX + TAX.
4. RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise it is
REASONABLE.
5. Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE.
6. Save file as Exercise 4.

You might also like