DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average
|
|
|
Count
|
|
|
Max
|
|
|
Sum
|
Detailed explanation-1: -For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
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: -Sum a range of cells–SUM Function. The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.
Detailed explanation-5: -The formula to calculate the sum of integers is given as, S = n(a + l)/2, where, S is sum of the consecutive integers n is number of integers, a is first term and l is last term.