FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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
A
sum=(D5+E5)
B
MAX=(D5:D7)
C
B1*B2
D
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.

There is 1 question to complete.