FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In Excel, MAX and AVERAGE are examples of ____
A
lists
B
formula prefix
C
reference operator
D
functions
Explanation: 

Detailed explanation-1: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.

Detailed explanation-2: -The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.

Detailed explanation-3: -The Average function calculates the average, or arithmetic mean, of its arguments. The Max function finds the maximum value.

There is 1 question to complete.