USING MICROSOFT WORD
MICROSOFT WORD
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average (right)
|
|
|
=Sum (average)
|
|
|
=Sum (left)
|
|
|
=Sum (all)
|
Detailed explanation-1: -For example, the formula =SUMIF(B2:B5, “John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John.” To sum cells based on multiple criteria, see SUMIFS function.
Detailed explanation-2: -=SUM(LEFT) adds the numbers in the row to the left of the cell you’re in. =SUM(BELOW) adds the numbers in the column below the cell you’re in. =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.
Detailed explanation-3: -Detailed Solution. The correct answer is SUM(). The SUM function in excel is an inbuilt function that is used to sum numerical values present in a range of cells.
Detailed explanation-4: -LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.