USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
=(A1+A2+A3)/4
|
|
A1+A2+A3/4
|
|
=A1+A2+A3^4
|
|
(A1+A2) + A3/4
|
Detailed explanation-1: -Answer. Explanation: a. =(A1 +A2 +A3)/4 shows the summation of values of A1, A2 and A3 which is then divided by 4.
Detailed explanation-2: -=AVERAGE(number1, [number2], …) The function uses the following arguments: Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average. Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average.
Detailed explanation-3: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Detailed explanation-4: -Split cells On the ribbon, select the Layout tab. Select Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.
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.