Spreadsheets

Assignment for Unit 2

1. Create the spreadsheet as shown in Figure 1 below. The spreadsheet identifies which employees did or did not meet a goal for a monthly increase in sales. An IF function should be used in cells D4-D15 to determine if the target sales increase was met. (For more information about using an IF function click here for an example.) The monthly sales increase goal was met if the increase between January and February is larger than the January sales figure times the target percentage increase. The spreadsheet has two worksheets. The second worksheet is a copy of the first except the sales goal is 4%. (Notice that the first two worksheets have been renamed.)
   
   Hint, enter the formula for cell D4 (with careful attention to relative and absolute references) and copy down to D15. Copy the spreadsheet from the first worksheet to the second and change the value in B1.

   Question and answer from the email archives.

   

   Figure 1.

   Save the file as SALESGOAL

2. Create a spreadsheet that duplicates the formatting in the following example^*:

   
   

   ^*Note, use formulas to calculate values in column E and row 8.

   And create a chart from the data with the following layout:

   
   

   Save and submit a file named ACMERETAIL

Once you have finished all steps, use File Upload to submit your results.

Copyright 1997 by the Curators of the University of Missouri