Spring 2023 In-Person

Professor Albert Wu

Presented 3/11/2023

 

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?

 

 

 

Perhaps the most profound concept is not a function but a sense of ownership. As you saw in the walkthrough, when I used the Autosum wizard for the third time, the wizard took the Total vertically instead of horizontally as we thought it would as it had done the first two times. You caught it because I directed you to pay attention to what the Autosum wizard. Often, users – myself included – are accostomed to simply click [Next] or [Ok] while not reading the dialog box to get the wizard to move on to do what we expect the wizard to do for us. If I simply pressed [Enter] to accept how the wizard took the total, who is responsible?