DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In MS.Excel there is a statistical calculation function which functions to find the amount of data contents contained in a range, what is the name of the function called
|
|
Max
|
|
|
Min
|
|
|
Sum
|
|
|
Average
|
|
|
Count
|
Explanation:
Detailed explanation-1: -The SUM Function. The SUM function is used when you need to calculate totals for a range of cells or a group of selected cells on a worksheet. With regard to the Budget Detail worksheet, we will use the SUM function to calculate the totals in row 12.
Detailed explanation-2: -Mode Function Mode returns the most frequent and repeated value in the given range of values: MODE. SNGL(number1, [number2], …)
Detailed explanation-3: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
There is 1 question to complete.