# BTA3O - Excel Spreadsheets Charts to be Complete by MHairston

VIEWS: 162 PAGES: 1

• pg 1
```									BTA3O - Excel Spreadsheets & Charts to be Complete

For each of the following 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)

(c) Ch10Ex4StudentStats: Read instructions for #1 above. (Pie, Max(), Min() functions)

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.