USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Correct
|
|
|
Incorrect
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Average This is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5. Median The middle number of a group of numbers.
Detailed explanation-2: -Correct common formula errors one by one Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.
Detailed explanation-3: -You might want to change the cell format to General or to Number with some larger number of decimal places. Second, if you see 4 for the average of 0, 7 and 0, one of the zeros might be text “0", not numeric 0, especially if you are using a formula like =AVERAGE(A1:A3).
Detailed explanation-4: -The formula to calculate the average of given numbers is equal to the sum of all the values divided by the total number of values.