DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=average(C1:C4)
|
|
|
=max(C1:C4)
|
|
|
=min(C1:C4)
|
|
|
=sum(C1:C4)
|
Detailed explanation-1: -Formulas calculate values in a specific order. A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.
Detailed explanation-2: -The formula in B3 will automatically recalculate and display the new value in cell B3. Excel will not always tell you if your formula contains an error, so it’s up to you to check all of your formulas.
Detailed explanation-3: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131. The SUM formula automatically updates with the insertion or deletion of a value.
Detailed explanation-4: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.