DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Included in the simple statistical formula is ____
|
SUM, MAX, MIN
|
|
COUNT, MAX, DATE
|
|
COUNT, IF, LOOKUP
|
|
AVERAGE, LOOKUP, DATE
|
|
TIME, DATE, COUNT
|
Explanation:
Detailed explanation-1: -Statistical functions are used to apply a mathematical process to a particular set of cells in a worksheet. For instance, the SUM function adds the values contained in a group of cells. Functions are more efficient than formulas when a mathematical process is applied to a group of cells.
Detailed explanation-2: -Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells. A list of commonly used statistical functions is shown in Table 2.4.
There is 1 question to complete.