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 no...
table image with items, quantity, cost per item, cost

1. =average(c3:c7)

Explanation:

Step1: Identify the values in cells C3 to C7

Looking at the table, the values in column C (Cost per item) for rows 3 to 7 are 7.50, 1.75, 1.30, 6.50, and 2.75.

Step2: Calculate the sum of these values

Sum = 7.50 + 1.75 + 1.30 + 6.50 + 2.75 = 19.80

Step3: Calculate the average

The AVERAGE function takes the sum of the values and divides by the number of values. There are 5 values. So, Average = $\frac{19.80}{5}$ = 3.96

Answer:

3.96