Print Name  ___________________

                                                                                                                                              Signature   ___________________

   Graph/Payment Lab
Individual Assignment
  15  Points

Set Netscape Margins [ Left = 1; Right =. 2; Top =. 4; Bottom = .4; Select Document Title,  Page Number, Page, Black Text, Black Lines]
1] Create a new spreadsheet. Save it at the root of floppy disk A as Excel2.XLS Substitute your own name in place of Name/Your Name throughout this document!
2] Sheet 1 of this spreadsheet is to look like the above:

3] Be sure to enter the names exactly as illustrated [i.e. a blank before Karen and aaron in lower case].  Replace all XX entries with the proper calculated formulas [i.e. all XX cells should start with =].

4] Record the formulas entered that you entered in those cells listed below: [start with =]

Cell  B11 ___________________________    Cell  B12 ___________________________

Cell  C11 ___________________________    Cell  C12 ___________________________

Cell    I5 ___________________________    Cell    J5 ___________________________

Cell    I6 ___________________________    Cell    J6 ___________________________

4] Copy the range of cells A4:J12 to of Sheet 1 as illustrated below:

4] After the copy, record the formulas that are contained in those cells listed below:  [start with =]

Cell  B28 ___________________________    Cell  B29 ___________________________

Cell  I22 ___________________________    Cell  J22 ___________________________

5] Select the range of cells highlighted above. Sort them by Name. Make sure that the respective sales for each person are sorted as well [i.e. Sarah should still have sales of 20, 20, 20, 20, 20, 20 after the sort. Your results should look something like the following:
6] How do you explain the fact that Karen is at the top?  ________________________________________

______________________________________________________________________________

7] ________ (T/F) The formulas are still correct after the sort.
8] Enter the calculation of 2 * 3 + 15 / (6 * 2 / 4)  into cell  J28. The mathematically correct

answer for the calculation of this problem is __________. The spreadsheet calculation is __________.

________ (T/F) The computer calculation is correct.

9] Enter the calculation of 2 * 2^ 3 ^ 2 + 12/ (3 + 9)  into cell  J29. The mathematically correct

answer for the calculation of this problem is __________. The spreadsheet calculation is __________.

________ (T/F) The computer calculation is correct.

10] Change cell A22 to be Karen [no blanks]. Change cell A23 to be Aaron [Proper form]. Once again sort the range A:22:G26  by Name.

11] Create the following Pie chart from your spreadsheet: [Resize the graph to fit A32:??42 as illustrated]
 Did you forget to substitute your own name in place of Your Name in the graph?
12] Create the following Pie chart from your spreadsheet: [Resize the graph to fit A44:??54 as illustrated]
 Did you forget to substitute your own name in place of Your Name in the graph?
13] Create the following Bar chart from your spreadsheet: [Resize the graph to fit A56:??66 as illustrated]
 Did you forget to substitute your own name in place of Your Name in the graph?
14] Create the following Line chart from your spreadsheet: [Resize the graph to fit A56:??66 as illustrated]
 Did you forget to substitute your own name in place of Your Name in the graph?

15] Print a copy of sheet 1 of the Excel2.XLS. Using a pen, label the top right corner of this listing with a 'A'.

16] Change the Jan sales for Sarah [cell B26] to be 0. Save the spreadsheet. __________ (T/F) Each of the graphs automatically reflect the new, correct value for January sales for Sarah.

17] Change the Jan sales for Sarah [cell B26] back to 20. Save the spreadsheet.

18] Sheet 2 of this spreadsheet is to look somewhat like the one above. Replace all XX entries with the proper calculated formulas [i.e. all XX cells should start with =].  Cells B5, B9, B11, B12, C9, C11, C12, D9, D11, D12, E9, E11, E12, F9, F11, F12, G9, G11, G12, H9, H11, H12 must be formulas!

Represent money as currency,  percentages as %, etc.

You must use Absolute Addressing where appropriate to replicate the formulas across the rows.  Substitute your own name in place of Name/Your Name throughout this document!

19] After the copy, record the formulas that are contained in those cells listed below:  [start with =]

Cell   B5 ___________________________    Cell    B9 ___________________________

Cell B11 ___________________________    Cell  B12 ___________________________

Cell    C9 ___________________________    Cell   C11 ___________________________

Cell  C12 ___________________________

20] Print a copy of sheet 2 of the Excel2.XLS. Using a pen, label the top right corner of this listing with a 'B'.

21] Change the number of years to be 20 [cell B6]. Print a copy of sheet 2 of the Excel2.XLS. Using a pen, label the top right corner of this listing with a 'C'.

22] Change the down payment  to be $15,000  [cell B4]. Print a copy of sheet 2 of the Excel2.XLS. Using a pen, label the top right corner of this listing with a 'D'.

23] Save copies of the spreadsheet to at least two disks.

24] Microsoft Excel Spreadsheets have an extension of _____________.

25] Those Labs labeled "Individual Assignment" are to be done separately by each individual. Using a pen,  each individual is to print print his/her name at the top of this document in the space provided and sign it.  Those Labs labeled "Team Assignment" may be done as a team or individually. Using a pen,  each individual on the team is to print print his/her name at the top of this document in the space provided and sign it. Submit only one copy of team assignments!
Include the following in your wire-band binder:

A] Divider

B] Copy of this assignment sheet. Print name and sign!

C] Listings A, B, C, & D.

D]  Disk containing Excel2.xls.