DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ is a function used to find the average of the numbers in a range of cells.
|
|
SUM
|
|
|
AVERAGE
|
|
|
RANGE
|
|
|
MODE
|
Explanation:
Detailed explanation-1: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-2: -The Excel AVERAGE function will calculate the average (arithmetic mean) for a specified set of numbers in an Excel spreadsheet. It is one of the central tendency functions, like MEDIAN and MODE.
Detailed explanation-3: -To get the average of all cells in the specified range that meet a certain condition, use the AVERAGEIF function. The AVERAGEIF function has the following arguments: Range (required)-the range of cells to test against a given criteria. Criteria (required)-the condition that should be met.
There is 1 question to complete.