# Maths Worksheets - Excel by mtm19129

VIEWS: 0 PAGES: 18

• pg 1
GCSE Maths

Active Worksheets

Use the following sheet to to produce a
variety of worksheets.

Each worksheet will randomise the values
Contents (includes worksheet and answer sheet):     of each question set, so every worksheet
produced can be different,
* Percentages 1 and 2               ideal if you want additional practice material.
* Fractions 1 and 2
* Pythagoras                        To change the values used press F9
* Trigonometry
* Algebra

produced by A V Ali
he following sheet to to produce a
variety of worksheets.

worksheet will randomise the values
ch question set, so every worksheet
produced can be different,

change the values used press F9
GCSE Mathematics

Percentages Worksheet 1

1) Find 10 % of :                                      3) Find 2.5 % of :

a) £ 238.00                                            a)   £       377.00
b) £         17.00                                     b)   £        90.00
c) £        55.00                                      c)   £       407.00
d) £        109.00                                     d)   £       382.00
e) £ 436.00                                            e)   £       185.00

2) Find 5 % of :                                       4) Find 17.5 % of :

a)    £ 368.00                                          a)   £       178.00
b)    £ 332.00                                          b)   £       402.00
c)    £ 202.00                                          c)   £       182.00
d)    £ 493.00                                          d)   £       469.00
e)    £      63.00                                      e)   £       439.00

5) Calculate the new price and change in price
Sale            Original                 Change in
discount        Price      New Price Price
a)            40% £ 44.00
b)            40% £ 69.00
c)            35% £ 27.00

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                         11/22/2010
GCSE Mathematics

Percentages Worksheet 1
1)                                                  3)

a)   £     23.80                                        a)   £    9.43
b)    £      1.70                                   b)       £    2.25
c)    £     5.50                                        c)   £   10.18
d)    £    10.90                                    d)       £    9.55
e)   £     43.60                                        e)   £    4.63

2)                                                  4)

a)    £    18.40                                        a)   £   31.15
b)    £    16.60                                    b)       £   70.35
c)    £     10.10                                       c)   £   31.85
d)   £     24.65                                    d)       £   82.08
e)    £      3.15                                       e)   £   76.83

5)
a)   £     26.40     £ 17.60
b)    £     41.40   £ 27.60
c)    £     17.55    £    9.45

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                    11/22/2010
GCSE Mathematics

Percentages Worksheet 2

1) Calculate the new price and change in price
Sale          Original                       Change in
discount      Price         New Price Price
a)           5% £ 63.00
b)          20% £ 125.00
c)          50% £ 133.00

2) Calculate the old price and change in price
Sale          Original                       Change in
discount      Price         New Price Price
a)          50%                   £ 67.50
b)          10%                   £ 110.70
c)          10%                   £ 88.20

3) Calculate the percentage discount and change in price
Sale          Original                       Change in
discount      Price         New Price Price
a)                 £ 10.00        £     7.50
b)                 £ 129.00       £ 90.30
c)                 £ 52.00        £ 41.60

4) Calculate the new price price and percentage discount
Sale          Original                       Change in
discount      Price         New Price Price
a)                 £ 93.00                        £ 23.25
b)                 £ 117.00                       £ 17.55
c)                 £ 115.00                       £ 28.75

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls             created by A V Ali               11/22/2010
GCSE Mathematics

Percentages Worksheet 2

1)                                            2)
a) £ 59.85         £   3.15                   a) £ 135.00   £ 67.50
b) £ 100.00        £ 25.00                    b) £ 123.00   £ 12.30
c) £ 66.50         £ 66.50                    c) £ 98.00    £   9.80

3)                                             4)
a)        25% £        2.50                   a)      25% £ 69.75
b)        30% £ 38.70                         b)      15% £ 99.45
c)        20% £ 10.40                         c)      25% £ 86.25

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls         created by A V Ali                            11/22/2010
GCSE Mathematics

Fraction Arithmetic Worksheet 1

Work out : -

a)    2     +    3                               a)    7     -      1
2          3                                     14           1

b)    2     +    1                               b)    4     -      1
7          3                                     4            1

c)    7     +    7                               c)    12    -      9
9          10                                    13           9

d)    5     +    1                               d)    8     -      4
5          1                                     12           6

e)    3     +    5                               e)    2     -      2
7          5                                     5            2

f)    2     +    1                               f)    3     -      5
3          2                                     8            6

g)    1     +    1                               g)    2     -      7
8          1                                     2            7

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls     created by A V Ali                           11/22/2010
GCSE Mathematics

Fraction Arithmetic Worksheet 1
1)                                                    2)
a)    12   =                                         a)   -7    =       -1
2
6                                                   14            2
b)    13   =             13                          b)   0     =
0
21                 21                               4
c)   133   =             43                          c)   -9    =       -1
1
90                 90                               117           13
d)    10   =                                         d)   0     =
2                                                0
5                                                   72
e)    50   =             3                           e)   -6    =       -3
1
35                 7                                10            5
f)    7    =             1                           f)   -22   =       -11
1
6                  6                                48            24
g)    9    =             1                           g)   0     =
1                                                0
8                  8                                14

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali                            11/22/2010
GCSE Mathematics

Fraction Arithmetic Worksheet 2

Work out : -
1)    Multiplication                          2)    Division

a)     5    x     2                           a)     3       2
9          6                                  8        9

b)     8    x     7                           b)     5       9
8         10                                  5        10

c)     2    x     2                           c)     3       1
2          2                                  3        1

d)     2    x     1                           d)     2       3
2          1                                  7        6

e)     6    x     1                           e)     3       1
8          1                                  7        4

f)     1    x     2                           f)     1       2
2          9                                  1        2

g)     1    x     1                           g)     3       1
3          1                                  4        2

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                    11/22/2010
GCSE Mathematics

Fraction Arithmetic Worksheet 2
1)                                       2)
a)    10    =            5              a)     3       x   9    =   27   =       11
1
54                 27                    8           2        16           16
b)    56    =            7              b)     5       x   10   =   50   =       1
1
80                 10                    5           9        45           9
c)     4    =                           c)     3       x   1    =   3    =
1                                                        1
4                                       3           1        3
d)     2    =                           d)     2       x   6    =   12   =       4
1
2                                       7           3        21           7
e)     6    =            3              e)     3       x   4    =   12   =       5
1
8                 4                     7           1        7            7
f)     2    =            1              f)         1   x   2    =   2    =
1
18                 9                         1       2        2
g)     1    =            1              g)     3       x   2    =   6    =       1
1
3                 3                     4           1        4            2

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls        created by A V Ali                                      11/22/2010
GCSE Mathematics

Pythagoras Worksheet 1

1) Find the value of length x correct to 1 dp

a)                          b)          45                     c)   x

50
x        60                               x                    23
37

34

d)                          e)                                 f)
x
x                       39    47
48                                          1
45
7
x

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                 created by A V Ali                  11/22/2010
GCSE Mathematics

Pythagoras Worksheet 1

1)      a)      49.4        b)      67.3   c)   29.0

d)      48.5        e)      26.2   f)   45.0

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                 created by A V Ali   11/22/2010
GCSE Mathematics

Trigonometry Worksheet 1

1) Find the value of length x correct to 1 dp

a)                           b)        31.0                          c)          x
55.0                          20.0

4.0                                x                                           36.0
x

45.0

2) Find the value of angle A correct to 1 dp

a)                           b)                           c)
15.0
33.0     59.0                                    A
58.0
48.0
A                                            A
26.0

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                 created by A V Ali                     11/22/2010
GCSE Mathematics

Trigonometry Worksheet 1
1)
a)          2.8               b)      54.0           c)    98.9

2)
a)         65.9 degrees       b)      34.0 degrees   c)    71.8 degrees

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                         created by A V Ali   11/22/2010
GCSE Mathematics

Algebra Worksheet 1

1)   Evaluate the following using x =          4 and y =       10

a)        4 x    +        5 y

b)        5 x    -        5 y

c)        3 x    +        4 y

d)       10 x     +       6 y                      Leave answer as a fraction
3 x

e)        6 x     -       5 y                      Leave answer as a fraction
5 y

a)        6 x    -        9         =          6

b)        5 x    -        6         =         -5

c)        8 y    -        2         =         -1

d)        7 y    -        10        =         -9

e)        8 z    -        2         =         -7

a)        4 x    +        10        =          1 x         +        9

b)        5 x    -        5         =          6 x         +        1

c)        6 y    +        7         =         10 y         +        7

d)        5 y    +         1        =          3 y         +        2

e)        3 z    +        8         =          9 z         +        2

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali                             11/22/2010
GCSE Mathematics

Algebra Worksheet 1

1)                                         2)

a)      66                                 a)         2.5

b)     -30                                 b)         0.2

c)      52                                 c)          0.1

d)     100 =              1                d)          0.1
8
12                3
e)         -0.6
e)     -26 =              13
50                25

3)

a)     -0.3

b)     -6.0

c)      0.0

d)      0.5

e)      1.0

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali          11/22/2010
GCSE Mathematics

1)    Expand the following

a)    (    1   x      +    3   )    (   4   x    +     7    )          1    3    4   7
4    19 21
b)    (    4   x      +    5   )    (   5   x    -     4    )          4    5    5   -4
20    9    #
c)    (    1   x      -    2   )    (   5   x    -     7    )          1    -2   5   -7
5    # 14
d)    (    1   x      +    1   )    (   4   x    -     5    )          1    1    4   -5
4    -1 -5
e)    (    3   x      -    3   )    (   1   x    +     7    )          3    -3   1   7
3    18 #
f)    (    4   x      -    8   )    (   6   x    +     1    )          4    -8   6   1
24 # -8
g)    (    6   x      +    7   )    (   5   x    -     6    )          6    7    5   -6
30 -1 #
h)    (    1   x      -    2   )    (   4   x    -     6    )          1    -2   4   -6
4    # 12

2)    Factorise the following

a)             1      x2   -   8    x   +   12

b)             6      x2   +   12   x   -   18

c)             6      x2   +   10   x   +   4

2
d)             18 x        -   18   x   -   8

e)             6      x2   -   23   x   +   7

2
f)             10 x        -   17   x   +   6

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                    created by A V Ali                 11/22/2010
GCSE Mathematics

1)                                                       2)
a)             4      x2   +   19   x   +   21          a)    (    1    x   -   6   )   (   1   x   -   2   )   1
1
2
b)            20 x         +   9    x   -   20          b)    (    6    x   -   6   )   (   1   x   +   3   )   6
6
c)             5      x2   -   17   x   +   14          c)    (    6    x   +   4   )   (   1   x   +   1   )   6
6
d)             4      x2   -   1    x   -   5           d)    (    6    x   +   2   )   (   3   x   -   4   )   6
18
e)             3      x2   +   18   x   -   21          e)    (    3    x   -   1   )   (   2   x   -   7   )   3
6

b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                created by A V Ali                                                11/22/2010

To top