Spring 2024 In-Person

Professor Albert Wu

Presented 3/30/2024

 

http://FlorenceNightingale.atwebpages.com/Homepage.htm

 

1.

Title Slide

 

 

 

 

 

 

7.

Straight vs. Weighted Average

2.

Order of Precedence

 

 

 

 

 

 

8.

Which Chart Type?

3.

Common Functions

 

 

 

 

 

 

9.

Pie Chart

4.

Absolute vs. Relative Cell Reference

 

 

 

 

 

 

10.

Line Chart

5.

Using the Fill Handle to fill out a Series

 

 

 

 

 

 

11.

Column or Bar Chart

6.

Always double check wizard's assumptions

 

 

 

 

 

 

12.

Other Chart Types & Questions?

 

 

 

When to make a cell reference absolute (i.e. fixed position) instead of relative (i.e. position adjusts) is a critical concept that must be mastered otherwise your experience of using an Excel spreadsheet would be an unproductive one as you would (a) not be able to copy and paste formulas and would have to input each formula individually or (b) have to replicate the source cell for each cell with a result.