DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM function
|
|
|
Max function
|
|
|
Min function
|
|
|
Average function
|
Detailed explanation-1: -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.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-3: -What is the SUM Function? The SUM Function[1] is categorized under Excel Math and Trigonometry functions. The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel.
Detailed explanation-4: -The [sum range] is the range where the function calculates the sum. Note: The [sum range] is optional. If not specified, the function calculates the sum of the same range as the condition.
Detailed explanation-5: -Sum of Two Functions: The sum of two functions is found by adding the two functions together. Difference of Two Functions: The difference of two functions is found by subtracting the second function from the first function.