USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNT
|
|
|
SUM
|
|
|
MIN
|
|
|
AVERAGE
|
Detailed explanation-1: -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-2: -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-3: -Range sum S(i, j) is defined as the sum of the elements in nums between indices i and j inclusive, where i <= j . Example 1: Input: nums = [-2, 5, -1], lower =-2, upper = 2 Output: 3 Explanation: The three ranges are: [0, 0], [2, 2], and [0, 2] and their respective sums are:-2, -1, 2.
Detailed explanation-4: -You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF(B2:B25, ">5") Play.