Asked by Niketa Kurjee on Jul 02, 2024
Verified
After three months,Anna wants to the know the average distance she runs.What should she do to calculate the average distance?
A) Enter the text =av in a cell at the end of the distance data;then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument.
B) Enter the text =ms in a cell at the end of the distance data;then select the MAX function from the Formula AutoComplete list and then enter the function's argument.
C) Enter the text =function in a cell at the end of the distance data;then select the AVERAGE function from the AutoFunction list and then enter the function's argument.
D) Enter the text =su at the end of the data in the Distance column;then select the SUM function from the Select Function list and then enter the function's argument.
AVERAGE Function
A spreadsheet function that calculates the mean of a range of numbers.
Formula AutoComplete
Formula AutoComplete is a feature in spreadsheet applications that suggests and completes formulas as you type, making it easier to enter and edit formulas accurately.
- Comprehend the significance and utilization of mathematical and logical operations in Excel.
Verified Answer
KE
Kayla Edwards6 days ago
Final Answer :
A
Explanation :
To calculate the average distance, Anna should use the AVERAGE function in Excel. By entering "=av" in a cell at the end of the distance data, Excel's Formula AutoComplete feature will suggest the AVERAGE function, which she can then select and enter the appropriate range of cells as the function's argument.
Learning Objectives
- Comprehend the significance and utilization of mathematical and logical operations in Excel.