Question

section a.2 built-in functions
objective 1 – using built-in functions
guided practice activity #2 – built-in functionality
what are the outputs of the following functions? note cell e3 has been formatted to… decimal places.
spreadsheet with item (soda, water, popcorn, cookie, hot dog), quantity (c3: 3, c4: 1, c5: 3, c6: 4, c7: 2), cost per item, etc.

1. =average(c3,c7)

(handwritten: 3+2=5, 5/2=2.5)

1. =average(c3:c7)

Explanation:

1. Calculating =AVERAGE(C3:C7)

Step1: Identify values in C3:C7

The values in cells C3 to C7 (Quantity column) are 3, 1, 3, 4, 2.

Step2: Sum the values

Sum = \( 3 + 1 + 3 + 4 + 2 = 13 \)

Step3: Divide by number of values

There are 5 values. Average = \( \frac{13}{5} = 2.6 \) (Wait, but the handwritten says 2.5? Wait, maybe I misread. Wait, let's check again. Wait, maybe the cells are C3 to C7: let's see the table. Item Soda (C3): 3, Water (C4):1, Popcorn (C5):3, Cookie (C6):4, Hot Dog (C7):2. So sum is 3+1=4, +3=7, +4=11, +2=13. 13/5=2.6. But the handwritten has 3+2? Wait, maybe a typo. Wait, maybe the user's handwritten is wrong, but let's follow the formula. Wait, no, maybe I misread the cells. Wait, maybe C3:C7 is 3,1,3,4,2. So average is (3+1+3+4+2)/5 = 13/5 = 2.6. But the handwritten shows 3+2? Wait, maybe the user made a mistake. But let's proceed with the correct calculation.

Wait, maybe the user's first calculation is =AVERAGE(C3,C7)? Wait, the first formula is =AVERAGE(C3,C7). Oh! Wait, the first formula is AVERAGE(C3,C7), not C3:C7. Oh, I misread. So C3 is 3, C7 is 2. So average of 3 and 2.

Step1: Identify values for AVERAGE(C3,C7)

C3 = 3, C7 = 2.

Step2: Calculate average

Average = \( \frac{3 + 2}{2} = \frac{5}{2} = 2.5 \)

Step1: Identify values in C3:C7

Values are 3 (C3), 1 (C4), 3 (C5), 4 (C6), 2 (C7).

Step2: Sum the values

Sum = \( 3 + 1 + 3 + 4 + 2 = 13 \)

Step3: Divide by number of values (5)

Average = \( \frac{13}{5} = 2.6 \)

Answer:

2.5

2. Calculating =AVERAGE(C3:C7)