BTA3O - Excel Spreadsheets Charts to be Complete by MHairston

VIEWS: 162 PAGES: 1

									BTA3O - Excel Spreadsheets & Charts to be Complete


For each of the following exercises:
 Save all your work in your Excel\Spreadsheet folder including Ch8 and Ch9 exercises.
 Use your “Creating Charts” checklist for formatting each of the charts and worksheets.
 Use your “Creating Charts” Excel Functions to find the correct expression to use in your ss.
 Save each exercise similar to: Ch10Ex2SqueakyCleanCars (Filename should include, Ch10,
   Exercise # and Title of exercise.

Bar, Pie Chars—Min(), Max() Functions (Hand in the following 3 exercises together)

1.    (a) Ch10Ex2SqueakyCleanCars: In order to complete this exercise, you will need to
          complete Ch8Ex2 and Ch9Ex2. However, all will be saved according to the above
          filename in your chapter 10 folder. Do no print your exercise until you have
          completed Ch10Ex2. Use your checklist above. Marks will be deducted for not
          following your checklist handed out earlier.

      (b) Ch10Ex3SwimMeet: Read instructions for #1 above. Begin with Ch8Ex3 and
          Ch9Ex3. (Bar, Max() and Min() functions)
          Print out: Spreadsheet with Graph
                     Spreadsheet with formulas (Ctrl ~)—adjust to fit page

      (c) Ch10Ex4StudentStats: Read instructions for #1 above. (Pie, Max(), Min() functions)
          Print out: Spreadsheet with Graph
                     Spreadsheet with formulas

Line Graphs & Bar (Hand in the following 3 exercises together as one assignment)

2.    (a) Ch10Ex5Aquarium: The file that you need is in the Assignments folder, Office XP
          folder, Data Files.

      (b) Ch10Ex6BreakEven: The file you need is in the Assignments folder.

      (c) Ch10Ex10Stocks: The file you need is in the Assignments folder. Follow the
          directions from the text Chapt 9, Ex 10 and Chapt 10, Ex 10. (If statement req’d)


Line Graphs—Sum(), Subtraction, Min(), Max(),

3.    (a) Ch10Ex12TrackProgress: Complete Ch9Ex12 before beginning this exercise.
          Print out: Spreadsheet with Graphs
                     Spreadsheet with formulas

      (b) Ch10Ex13IncomeStmt: Complete Ch8Ex13 before beginning this exercise.
          Print out: Spreadsheet with Graphs
                     Spreadsheet with formulas



D:\Docstoc\Working\pdf\1f7ae17c-adfe-465a-98da-4cb3cd1c85f8.doc

								
To top