EXCEL PRODUCTION TEST

 

Enter the Following Table Onto a Blank Worksheet:

 


                 Sales                        Rate      0.15 


  Name         1st Qtr   2nd Qtr   3rd Qtr   4th Qtr  Yr. Totals Commissions 

  Smith            120       180       135       650                          
  Forbes           165       175       125       400                          
  Hyatt            365       255       350       120                          
  Chang            120       220       325       525                          
  Lynch            330       440       345       675                          
  TOTALS                                                                      
  AVERAGE                                                                    
  HIGH

FORMATTING

1. Notice that some of the words extend into other cells. Extend the width of the columns to allow for the whole word.

2. Insert rows separating "TOTALS", "AVERAGES", and "HIGH."

3. Format all the numbers for currency.

4. Title "Sales" and center it across the data range.

5. Bold and italicize column headings.

6. Make "Sales", our newly formed title, size 24 font and arial.

FORMULAS

1. Get totals for all 4 quarters and place them in the "YR. TOTALS" column.

2. Use the =AVERAGE(X:Y) function to get averages for quarter 1.

3. Obtain the highs by using the =MAX function.

4. Calculate each salesperson's commission using the rate indicated in the table.

 

CHARTS/GRAPHS

1. Create a 3D bar graph using the column headings, names, and totals; exclude the commission amounts. 
2. Uh, Oh:  you've just about finished and realize that one name was omitted from the spreadsheet !  In the first column, 
    click on the cell next to Lynch and  at top of screen; select Insert, then Rows. Now you can enter the following information 
    under the proper headings:

                                    Vincent          265     485      678     555