Excel+Can+Do+That?

Excel Can Do That?

Presenter: Karen Ferrell www.karenferrell.net karen_ferrell@yahoo.net

In Excel, use SmartArt Graphics - Go to Smart Art Graphics Tab below toolbox - has templates for flowcharts, graphs, diagrams, cycles, pyramids, lists, etc.

Fun Functions Greatest Common Factor Formula : =gcd(B3,C3) and then hit enter (B3 and C3 are the cells with the two numbers in them)

Least Common Multiple 24 84 =lcm(24,84) and then hit enter

Pi To find Area: Formula: =pi*C9^2 (C9 is the cell with the radius value in it)

Measures of CT randbetween function =randbetween(1,6) from 1 and including 1 and 6

mean =average(click and drag the numbers you want it to calculate the mean of)

median =median(select your range by click and dragging numbers you want it to calculate the median of)

=mode(select your range by clicking and dragging numbers)

=max(select range)-min(select range)

Quotient (B18 and D18 represent the cells that 167 and 7 are typed in) Problem: 167 divided by 7 =quotient(B18,D18)

Remainder =mod(B18,D18)

Roman Numerals =roman(B23)

Square Roots - use when teaching approximating square roots =sqrt(16)

Probability

Dice Roller =randbetween(1,6) - on a mac, use Command= to randomly generate numbers (on a PC hit F9)

Go to her website to get Bingo Cards and game templates