Question Four:

ABC Company granted 3% commission to its sales agents for the quarterly sales which exceed 1000 JD. The following information is about ABC Company sales agents and their first quarter sales of year 2016:

Required

1. Create a new work sheet (First Quarter sales), and enter previous data in it.
2. Use the (IF) function in related cells to determine and calculate commission (if any) to each sales agent.
3. Insert necessary equations or functions in related cells to calculate total monthly sales by sales agents in three months, total outstanding commission and company net income in three months.
4. Represent outstanding commission for each sales agents by graph.

E A B D 1 Student Name 2 Student ID 3 EX9 4 First Quarter Sales of Year 2016 5 Sales Agents January February March 6 Ali 500 600 200 7 Riyadh 700 400 300 8 Moner 300 400 400 9 Ahmad 1000 1500 1000 10 Salem 800 900 700 11 Totals ??? ??? ??? Net Income in Three Months ???? 13 Outstanding Commission ??? ??? ??? ??? ??? ??? 12