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?

 

 

 

The Order of Operations: PEMDAS is a rule in mathematic. 4 + 6 / 2 does not equal 5 but 7. If you want to end up with 5, you need to use _______ so the addition is performed first before the division. The resulting formula would be _______________.

 

Microsoft Excel follows this rule of mathematics. Microsoft Excel however does not always use the same symbols as mathematics. For example in mathematics, you use the X for multiply but Excel uses the * (astrisk).