USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=AVERAGE(L3..L10)
|
|
|
=(AVERAGE(L3:L10))/7
|
|
|
=AVERAGE(L3:L10)
|
|
|
+AVERAGE(L3;L10)
|
Detailed explanation-1: -Using functions AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Detailed explanation-2: -Mathematical operators Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).
Detailed explanation-3: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Detailed explanation-4: -For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use-the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.