Question

section 4.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 no decimal places.

table with columns: item, quantity, cost per item, cost; rows: soda (3, $2.50, $8), water (1, $1.75, $1.75), popcorn (3, $1.50, $4.50), cookie (4, $0.50, $2.00), hot dog (2, $2.75, $5.50); subtotal, tax @ 9%, total

1. =average(c3, c7)
2. =average(c3:c7)
3. =sum(c3:e3, e7)
4. =count(b2:e11)

Explanation:

To solve the outputs of the given built - in functions, we analyze each one:

1. Function: =AVERAGE(C3, C7)

• Step 1: Identify the values in cells C3 and C7

From the table, we can see that the value in cell C3 is 3 and the value in cell C7 is 2.

• Step 2: Apply the AVERAGE formula

The formula for the average of two numbers \(x\) and \(y\) is \(\text{AVERAGE}(x,y)=\frac{x + y}{2}\).
Substituting \(x = 3\) and \(y=2\) into the formula, we get \(\frac{3 + 2}{2}=\frac{5}{2}=2.5\).

2. Function: =AVERAGE(C3:C7)

• Step 1: Identify the values in the range C3:C7

The values in cells C3, C4, C5, C6, and C7 are 3, 1, 3, 4, and 2 respectively.

• Step 2: Calculate the sum of these values

The sum \(S=3 + 1+3 + 4+2=13\).

• Step 3: Apply the AVERAGE formula

The formula for the average of \(n\) numbers is \(\text{AVERAGE}=\frac{\text{Sum of numbers}}{n}\). Here, \(n = 5\) (since there are 5 cells in the range C3:C7). So, \(\text{AVERAGE}=\frac{13}{5}=2.6\).

3. Function: =SUM(C3:E3, E7)

• Step 1: Identify the values in the ranges

First, for the range C3:E3, the values in cells C3, D3, and E3 are 3, 2.50, and 7.50 respectively. The value in cell E7 is 2.50.

• Step 2: Calculate the sum of the range C3:E3

The sum of C3:E3 is \(3+2.50 + 7.50=13\).

• Step 3: Add the value of E7 to the sum of C3:E3

Now, we add the value of E7 (\(2.50\)) to the sum we just calculated. So, \(13+2.50 = 15.50\).

4. Function: =COUNT(B2:E11)

• Step 1: Understand the COUNT function

The COUNT function counts the number of cells in a range that contain numbers.

• Step 2: Count the number of numeric cells in B2:E11

By looking at the table and the range B2:E11, we count the number of cells with numeric values. After carefully examining the range, we find that the number of numeric cells is 9.

Final Answers:

1. For =AVERAGE(C3, C7): \(\boldsymbol{2.5}\)
2. For =AVERAGE(C3:C7): \(\boldsymbol{2.6}\)
3. For =SUM(C3:E3, E7): \(\boldsymbol{15.50}\)
4. For =COUNT(B2:E11): \(\boldsymbol{9}\)

Answer:

To solve the outputs of the given built - in functions, we analyze each one:

1. Function: =AVERAGE(C3, C7)

• Step 1: Identify the values in cells C3 and C7

From the table, we can see that the value in cell C3 is 3 and the value in cell C7 is 2.

• Step 2: Apply the AVERAGE formula

The formula for the average of two numbers \(x\) and \(y\) is \(\text{AVERAGE}(x,y)=\frac{x + y}{2}\).
Substituting \(x = 3\) and \(y=2\) into the formula, we get \(\frac{3 + 2}{2}=\frac{5}{2}=2.5\).

2. Function: =AVERAGE(C3:C7)

• Step 1: Identify the values in the range C3:C7

The values in cells C3, C4, C5, C6, and C7 are 3, 1, 3, 4, and 2 respectively.

• Step 2: Calculate the sum of these values

The sum \(S=3 + 1+3 + 4+2=13\).

• Step 3: Apply the AVERAGE formula

The formula for the average of \(n\) numbers is \(\text{AVERAGE}=\frac{\text{Sum of numbers}}{n}\). Here, \(n = 5\) (since there are 5 cells in the range C3:C7). So, \(\text{AVERAGE}=\frac{13}{5}=2.6\).

3. Function: =SUM(C3:E3, E7)

• Step 1: Identify the values in the ranges

First, for the range C3:E3, the values in cells C3, D3, and E3 are 3, 2.50, and 7.50 respectively. The value in cell E7 is 2.50.

• Step 2: Calculate the sum of the range C3:E3

The sum of C3:E3 is \(3+2.50 + 7.50=13\).

• Step 3: Add the value of E7 to the sum of C3:E3

Now, we add the value of E7 (\(2.50\)) to the sum we just calculated. So, \(13+2.50 = 15.50\).

4. Function: =COUNT(B2:E11)

• Step 1: Understand the COUNT function

The COUNT function counts the number of cells in a range that contain numbers.

• Step 2: Count the number of numeric cells in B2:E11

By looking at the table and the range B2:E11, we count the number of cells with numeric values. After carefully examining the range, we find that the number of numeric cells is 9.

Final Answers:

1. For =AVERAGE(C3, C7): \(\boldsymbol{2.5}\)
2. For =AVERAGE(C3:C7): \(\boldsymbol{2.6}\)
3. For =SUM(C3:E3, E7): \(\boldsymbol{15.50}\)
4. For =COUNT(B2:E11): \(\boldsymbol{9}\)