MathsClass

Generating random questions in Excel - Basic operations

Sunday, 11 March 2007 | 0 Comments

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

	A	B	C	D	E	F	G	H
1	50	+	10	60	50 + 10 = ___ 60
2	98	-	42	56	98 – 42 = ___ 56	98	42	56
3	7	×	6	42	7 × 6 = ___42
4	6	÷	2	3	6 ÷ 2 = ___3

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)

• ← CombiNumerals
• EAA Mathematics Resources →

Post a comment

Commenting is not available in this channel entry.