DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Functions in Ms. The Excel used to calculate the average of a group of values is____
|
|
SUM
|
|
|
Average
|
|
|
Min
|
|
|
Count
|
Explanation:
Detailed explanation-1: -Microsoft Excel already has an in-built tool to calculate the simple moving averages. It’s called the Data Analysis Toolpak. Before you can use the Data Analysis toolpak, you first need to check whether you have it in the Excel ribbon or not.
Detailed explanation-2: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-3: -Using functions AVERAGE: This function determines the average of the values included in the argument.
There is 1 question to complete.