Excel Formulas and Functions

Front

1.What do MS Excel Formulas start with?

Back

equal sign (=)

Front

2.What arithmetic operator is being used in MS Excel to calculate the Sum of a range of values?

Back

plus sign (+)

Front

3. 3.What arithmetic operator is being used in MS Excel to calculate the Product of a range of values?

Back

Asterisk (*)

Front

4. 4.What must be the formula to compute the Total numbers? 

Back

SUM(B1:B5)

Front

5. 5.What must be the formula to compute the Product of the two numbers?

Back

=A2*B2

Front

6. 6.In which area of the worksheet do excel formulas being displayed?

Back

Formula Bar

Front

7. 7.What must be the missing arithmetic operator to calculate the quotient of the given two numbers?

Back

forward slash ( / )