Which of the following is the formula that you created in the total row of the Mailing List table?Group of answer choices= SUM(ABOVE)=AVERAGE(F2:F23)=AVERAGE(ABOVE)=SUM(F2:F23)
Question
Which of the following is the formula that you created in the total row of the Mailing List table?Group of answer choices= SUM(ABOVE)=AVERAGE(F2:F23)=AVERAGE(ABOVE)=SUM(F2:F23)
Solution
Without the context of the table, it's hard to give a definitive answer. However, I can explain what each formula does:
-
=SUM(ABOVE): This formula sums all the values in the cells above the cell where this formula is placed. It's used in Excel tables.
-
=AVERAGE(F2:F23): This formula calculates the average of the values in cells F2 through F23.
-
=AVERAGE(ABOVE): Similar to the first formula, this one calculates the average of the values in the cells above where this formula is placed. It's also used in Excel tables.
-
=SUM(F2:F23): This formula sums the values in cells F2 through F23.
So, the formula you created in the total row of the Mailing List table would depend on what you wanted to calculate: a sum or an average, and whether you're working within an Excel table or not.
Similar Questions
What is the result of the formula that you noted for the average deposit in the Mailing List table BEFORE you changed the value of the cell above the formula?Group of answer choices138.04185.230144.32
What is the result of the formula in the last column and last row of the Mailing List table in the My Hot Holidays document?Group of answer choices185.230144.32138.04
Which function can be used to calculate the average of a range of values in Excel?Group of answer choicesSUMAVERAGECOUNTMAX
Select the correct answerThe average of 100 items was found to be 30. If at the time of calculation, two items were wrongly taken as 32 and 12 instead of 23 and 11, then the correct average is?Options29.829.929.529
The average of 9 items is 79. If one new item whose value is 59 is also included in the series, find average of all the 10 items.A77B80C81D83
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.