Karen Nazario Excel Exercise #2 =NOW()
Girl Scout Cookie Sales Name Jane Jill Betty Anita Lucy Bella
Thin Mints 45 25 13 20 15 18
Sandies 5 55 5 23 10 15
Fudge 5 4 6 8 25 10
Peanut Butter 10 6 8 15 15 10
Totals =SUM(B7:E7) =SUM(B8:E8) =SUM(B9:E9) =SUM(B10:E10) =SUM(B11:E11) =SUM(B12:E12)
Totals
=SUM(B7:B12)
=SUM(C7:C12)
=SUM(D7:D12)
=SUM(E7:E12)
=SUM(F7:F12)
Cookie Sales 150
100 50
18 15 20 13 25 45
0
15 10 23 5 55 5
10 25 8 6 4 5
Thin Mints
10 15 15 68 10
Sandies Fudge
Peanut Butter Jane
Jill
Betty
Anita
Lucy
Bella
=F7/$F$14 =F8/$F$14 =F9/$F$14 =F10/$F$14 =F11/$F$14 =F12/$F$14
Gold Star Minimum
45 4