Excel Review Lesson

SLIDESMANIA.COM

Excel Spreadsheet

Formulae

Prepared by:

A Henry Raphael

SLIDESMANIA.COM

Symbols for the Mathematical
/arithmetic Operations when using
Excel Spreadsheet to create a formula

Mathematical
Operation

Symbols

Addition

+

Subtraction

-

Multiply

*

Division

/

Multiple Choice

What are the four arithmetic operation symbols that can be used for Excel formulae?

• • = + ^&

• */^-

• -/*+

• =/*+

SLIDESMANIA.COM

Always start the equation/formula
with an equal sign

Use cell names rather than the values
in the cell (clicking in the required
cell allows for more accuracy)

Rules for creating a formula in excel
spreadsheet

Multiple Choice

What are the two rules to consider when creating a formula in Excel?

• Always start with an equal sign

  Use cell reference/name instead of values

• Use the values to calculate the formulae

  Use brackets in the formulae

• Use the operations in the formulae

  Use the values for in the equation

• Always start with an equal sign

  Donot use brackets for the cell range

SLIDESMANIA.COM

Examples of formula for performing
addition, subtraction, multiplication,

and division in a cell range.

Examples of formula

=B4*C4

to multiply the value in B4 and C4

=D3/D10

to divide the value in D3 by the

value in D 10
=C20 -D20 to subtract the value in D20 from
the value in C20
=sum( F15 + E15 ) To add the values in F15
and E15 together

Multiple Choice

The formulae used for calculating the total in a data set range is

• =(A1:A4)

• =sum(A1:A4)

• =(A1+A4)

Multiple Choice

The formulae used for calculating the difference in a data set range is

• =(A1-A4)

• (A1:A4)

• =(A1/A4)

Multiple Choice

The formulae used for calculating the product in a data set range is

• =(A1/A4)

• =(A1:A4)

• =(A1*A4)