MathsClass

In this second post about using Excel to generate random questions, the first showed how to make a question about money, I show the simple formulae used to generate questions using the 4 basic operations.

The key Excel function used here is “RANDBETWEEN”.  This function returns a random integer between the numbers specified.  In the multiplication and division questions, for example, this allows you to restrict the questions to the times tables.

Excel Output

Formulas:

A1

=RANDBETWEEN(30,100)

C1

=RANDBETWEEN(3,30)

D1

=A1+C1

E1

=CONCATENATE(A1," ",B1," ",C1," = ___",D1)

A2

=IF(H2<0,G2,F2)

C2

=IF(H2<0,F2,G2)

D2

=A2-C2

E2

=CONCATENATE(A2," ",B2," ",C2," = ___",D2)

F2

=RANDBETWEEN(3,100)

G2

=RANDBETWEEN(3,100)

H2

=F2-G2

A3

=RANDBETWEEN(2,12)

C3

=RANDBETWEEN(2,12)

D3

=A3*C3

E3

=CONCATENATE(A3," ",B3," ",C3," = ___",D3)

A4

=C4*D4

C4

=RANDBETWEEN(2,12)

D4

=RANDBETWEEN(2,12)

E4

=CONCATENATE(A4," ",B4," ",C4," = ___",D4)