FUNDAMENTALS OF COMPUTER

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 ____
A
SUM, MAX, MIN
B
COUNT, MAX, DATE
C
COUNT, IF, LOOKUP
D
AVERAGE, LOOKUP, DATE
E
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.