Functions And Formula in Ms- Excel


 
 
Concept Explanation
 

Functions And Formula in Ms- Excel

In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.

Formula is an expression that calculates values in a cell or in a range of cells.

               For example, =A1+A2+A3+A4 is a formula that adds up the values in cells A1 through A4.

Whereas,

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

What is the formula to add up a column of numbers in Excel?

Right Option : A
View Explanation
Explanation
Question : 2

Which of the following can be entered in the Excel formula bar for addition ?

Right Option : B
View Explanation
Explanation
Question : 3

____________ is a sequence of cell reference, mathematical operators and functions of the existing value to give a new value.

Right Option : C
View Explanation
Explanation
 
 
 


Students / Parents Reviews [10]