Docstoc

Petal Pushers Flower Shop

Document Sample
Petal Pushers Flower Shop Powered By Docstoc
					Name:___________________

Period ____

Station #____

Petal Pushers Flower Shop
January February March Totals by Flower Percent of Total

Rose Pansy Tulip Daffodil

19 29 22 8

18 34 25 10 =SUM(C3:C6)
=AVERAGE(C3:C6) =MIN(C3:C6) =MAX(C3:C6)

15 36 35 14 =SUM(D3:D6)
=AVERAGE(D3:D6) =MIN(D3:D6) =MAX(D3:D6)

=SUM(B3:D3) =SUM(B4:D4) =SUM(B5:D5) =SUM(B6:D6) =SUM(E3:E6)
=AVERAGE(E3:E6) =MIN(E3:E6) =MAX(E3:E6)

=E3/E$8 =E4/E$8 =E5/E$8 =E6/E$8

Total =SUM(B3:B6)
Average Minimum Maximum
=AVERAGE(B3:B6) =MIN(B3:B6) =MAX(B3:B6)

A. enter numbers B. enter formulas C. to add formula D. autosum E. copy formula/autofill F. formulas with constants ($) G. functions H. fonts, sizes, text alignments I. cell height & width J. gridlines and borders K. shading

page 125 page 127 page 129 page 130 page 131 page 133 page 135 page 138-39 page 140 page 142 page 144

B3:E6 B8:E8 F3:F6 B9:E11 line 1

Petal Pushers Flower Shop
January February March Totals by Flower Percent of Total

Rose Pansy Tulip Daffodil Total Average Minimum Maximum

19 29 22 8 78 19.5 8 29

18 34 25 10 87 21.75 10 34

15 36 35 14 100 25 14 36

55 99 82 32 265 66.25 32 99

=20% =37% =31% =12%


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4
posted:11/25/2009
language:English
pages:1