USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
WHICH ONE OF THESE IS NOT A FORMULE
|
|
sum=(D5+E5)
|
|
|
MAX=(D5:D7)
|
|
|
B1*B2
|
|
|
MIN=(D5:D7)
|
Explanation:
Detailed explanation-1: -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-2: -Formula is an expression that calculates values in a cell or in a range of cells. For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.
There is 1 question to complete.