DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNT
|
|
|
AVERAGE
|
|
|
MIN
|
|
|
SUM
|
Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
Detailed explanation-2: -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. SUM helps users perform a quick summation of specified cells in MS Excel.
Detailed explanation-3: -Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-4: -One of the common Excel functions is SUM, which totals the values in a range of cells. For example, the formula =SUM(A2:A10) totals the values in the cell range A2:A10. The AVERAGE function is similar to SUM, except it finds the average of values in a cell range.
Detailed explanation-5: -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.