DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell C4 contains 90, cell D4 contains 80, so the correct formula for calculating AVERAGE and the correct result is____
|
|
=C4+(D4/2); hasil 170
|
|
|
=(C4+D4)/2; hasil 85
|
|
|
=average(95..80); hasil 85
|
|
|
=C4+D4/2; hasil 85
|
|
|
=(95+80):2 ; result 85
|
Explanation:
Detailed explanation-1: -For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-2: -Enter a formula in cell E4 to calculate the average value of cells B4:D4. On the Home tab, in the Editing group, click the AutoSum button arrow and select Average. Press Enter.
Detailed explanation-3: -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.
There is 1 question to complete.