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 show decimal places.
spreadsheet chart with columns a - h, rows 1 - 12, items (soda, water, popcorn, cookie, hot dog) with quantity, cost per item, cost columns, and subtotal, tax, total rows

1. =average(c3, c7)

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

1. =average(c3:c7)

$\

$$\begin{cases}\\text{sum} = 3 + 1 + 3 + 4 + 2 = 13\\\\=\\frac{13}{5}=2.6\\end{cases}$$

$ (handwritten)

1. =sum(c3:e3, e7)

Explanation:

1. For =AVERAGE(C3, C7)

Step1: Identify values in C3 and C7

From the table, \( C3 = 3 \) (quantity for Soda) and \( C7 = 2 \) (quantity for Hot Dog).

Step2: Apply AVERAGE formula

The AVERAGE function calculates the mean: \( \text{AVERAGE}(x_1, x_2) = \frac{x_1 + x_2}{n} \), where \( n = 2 \) (number of values). So \( \frac{3 + 2}{2} = \frac{5}{2} = 2.5 \).

Step1: Identify values in C3 to C7

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

Step2: Sum the values

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

Step3: Apply AVERAGE formula

Number of values \( n = 5 \). So \( \text{AVERAGE} = \frac{13}{5} = 2.6 \).

Step1: Evaluate \( C3:E3 \)

\( C3 = 3 \), \( D3 = 2.50 \) (cost per item), \( E3 = 3 \times 2.50 = 7.50 \) (cost). Wait, no—wait, the SUM here is for quantities? Wait, no, looking at the table: Wait, maybe \( C3 \) is quantity (3), \( D3 \) is cost per item (2.50), \( E3 \) is cost (7.50)? Wait, no, the SUM(C3:E3, E7): Let's re - check. Wait, maybe \( C3 \) (quantity for Soda) is 3, \( D3 \) (cost per item) is 2.50, \( E3 \) (cost) is 7.50? No, maybe the SUM is for the cells as numbers. Wait, \( C3 = 3 \), \( D3 \) (maybe a number? Wait, no, the table has "Cost per item" as currency, but maybe in the formula, we take the numeric values. Wait, \( C3:E3 \) cells: \( C3 = 3 \), \( D3 = 2.50 \), \( E3 = 7.50 \) (since \( 3\times2.50 = 7.50 \))? Wait, no, maybe the SUM is for the quantities? Wait, no, the problem is about Excel functions. Wait, \( C3:E3 \) is a range. Let's list the values: \( C3 = 3 \), \( D3 = 2.50 \), \( E3 = 7.50 \)? No, maybe the E7 is the cost for Hot Dog, which is \( 2\times2.75 = 5.50 \)? Wait, no, let's re - examine the table. The "Cost" column (E) for row 3: Soda, quantity 3, cost per item 2.50, so cost \( 3\times2.50 = 7.50 \) (E3). Row 7: Hot Dog, quantity 2, cost per item 2.75, so cost \( 2\times2.75 = 5.50 \) (E7). And \( C3:E3 \) is cells C3 (3), D3 (2.50), E3 (7.50). So \( \text{SUM}(C3:E3, E7)=\text{SUM}(3, 2.50, 7.50, 5.50) \).

Step2: Calculate the sum

\( 3+2.50 + 7.50+5.50=(3)+(2.50 + 7.50)+5.50=3 + 10+5.50 = 18.50 \). Wait, but maybe the C3:E3 is quantity, cost per item, cost? No, maybe the SUM is for the numeric values in the range. Alternatively, if \( C3 = 3 \), \( D3 \) is not a number for summing (but in Excel, if it's a number, it will sum). Wait, maybe the initial table's C3 is 3 (quantity), C4 is 1 (quantity), C5 is 3 (quantity), C6 is 4 (quantity), C7 is 2 (quantity). And E3 is 7.50 (cost), E7 is 5.50 (cost). Wait, the formula is SUM(C3:E3, E7). So \( C3:E3 \) is cells C3, D3, E3. Let's assume the values are: \( C3 = 3 \), \( D3 = 2.50 \), \( E3 = 7.50 \), and \( E7 = 5.50 \). Then sum is \( 3+2.50 + 7.50+5.50 = 18.50 \). But maybe the D3 is not a number for summing? Wait, no, in Excel, if it's a number, it will be summed. Alternatively, maybe the C3:E3 is the quantity, cost per item, and cost for Soda, and E7 is the cost for Hot Dog. So \( C3 = 3 \), \( D3 = 2.50 \), \( E3 = 7.50 \), \( E7 = 5.50 \). Then \( \text{SUM}(3, 2.50, 7.50, 5.50)=3 + 2.50+7.50 + 5.50 = 18.50 \).

Answer:

\( 2.5 \)

2. For =AVERAGE(C3:C7)