MICROSOFT EXCEL: SPREADSHEETS EXERCISES

BOOKLET

Instructions:

Complete the following exercises in Microsoft Excel and answer the

questions in this document in the spaces provided.

Exercise 1
1. Open Microsoft Excel and copy the following information. Save your
document as ‘ Spreadsheet Exercises Booklet. These exercises will
need to be uploaded onto Learning Tasks as part of your Assessment.

2. Answer the following questions

a. What is the text in cell A6?

record

b. What is the name of the cell in which text/word Cost appears?

C3

1
c. Which cell does the number 12 appear in?

C6

d. What is the number in B5?

2000

e. What is the number in C5?

10

3. Merge and Centre the heading – All hits Music Store Stocktake. Do
this by highlighting the heading and clicking on

4. Change the heading and Grand total to a blue font. See below.

5. Calculate the total for each item by multiplying the Quantity by the
cost. See below
2
The first one has been done for you.

=B5*D6

6. Calculate the Grand total by using Autosum button found at the

top of your toolbar. See below. It is highlighted in yellow. Don’t forget to
press Enter.

See below

3
7. Write the Grand total and the formula you used in the space below

8. Rename your worksheet to Ex 1 - All hits music store. Do this by

right clicking sheet 1 at the bottom of your Microsoft Excel document.
See below

From this..

4
To this…

9. Change the QUANTITY value of GAMES in B6 to 2500. What is the

new total for GAMES. Write your answer below

3000

Exercise 2
1. Write your top 10 favourite songs and the name of the Band or singer in
the table wbelow. An example is included.

My top 10 Hits
Title Singer / Band
1 With You Dean Lewis
2 Lovely Billie Eilish
3 Blinding Lights The Weeknd
4 Perfect Ed Sheeran
5 Flowers Miley Cyrus
6 Someone You Loved Lewis Capaldi
7 Levitating Dua Lipa
8 Water Tyla
9 Summertime Sadness Lana Del Rey
10 Shivers Ed Sheeran

2. Once you have done this, copy this information into a new spreadsheet
in the same spreadsheet document by clicking onto the + button.
Rename this spreadsheet to Ex 2 - My top 10 hits. See below

5
3. Don’t forget to click on the SAVE button.

4. Change the colour of your heading and centre it by using the merge
and centre button.

5. You are to FORMAT your table. Do this, by highlighting it and clicking

on FORMAT AS TABLE icon, found at the top. Select any colour you
wish to use. Here is an example below

6. SORT and FILTER the title and singer columns by using the
Alphabetical order option

6
 A to Z

7. Copy and paste your table into the space below. Don’t forget to save
your document.

8. Change the lyrics of your favourite song using an AI program. OR

write a new song about an interest. Insert the changes in the table below.

Tonight we walk through quiet streets,

The sky is soft and calm and sweet.
No diamonds, gold, or fancy things—
Just you and me, that’s everything.

Exercise 3
1. Write your top 10 favourite holiday destinations in Australia and the
table below. An example is included. These could be places you have
visited or wish to visit. Include at least one Indigenous landmark

Note: use the Webjet website, [Link] to find Return

Airfares from Melbourne.

7
My favourite holiday destinations
Destination Australian State Airfares return
$
1 Hamilton Island Queensland 700
2 Sydney Opera New South Wales 500
house
3 Great Barrier Reef Queensland 650
4 Uluru Northern Territory 720
5 Twelve Apostles Victoria 180
6 Cradle Mountain Tasmania 400
7 Gold Coast Queensland 350
8 Rottnest Island Western 550
Australia
9 Kangaroo Island South Australia 480
10 Blue Mountains New South Wales 260

2. Once you have done this, copy this information into a new
spreadsheet in the same spreadsheet document by clicking onto the +
button. Rename this spreadsheet to Ex 3 - My favourite holiday
destinations. See below

3. Don’t forget to click on the SAVE button.

4. Change the colour of your heading and centre it by using the the
merge and centre icon.

5. You are to FORMAT your table by highlighting it and clicking on

FORMAT AS TABLE icon, found at the top. Select any colour you wish to
use. Here is an example below

8
6. SORT and FILTER the Destination, Australian State and Airfare
columns by using any option you wish. Name the option chosen in the
space below.

Airfares – smallest to largest

7. Find an image of an Australian Map and label it with your 10

Destinations. Use symbols for each landmark. Insert your map in the
space below

8. Create a Chart / Graph showing the Airfare price for each destination.
To this by click on the Insert icon.

9. Create an Advertisement about your favourite Destination. It can take any format you
wish. Insert your Advertisement in the space below.

✈️Explore Hamilton Island – Your Island Escape Awaits! 🌴

Crystal-blue water, white sandy beaches, and peaceful sunsets—all waiting for you on
Hamilton Island.
Relax, explore, snorkel, and discover one of Australia’s most stunning island getaways.
Book now and experience paradise!

Exercise 4
1. Click onto the + button. Rename this spreadsheet to Ex 4 – Allmine
Gold Mines Incorporated. Save your document.

9
2. Create the following spreadsheet. Don’t forget to centre the headings
and change the font colour.

3. Use the Autosum function highlighted below to add the totals.

Exercise 5
1. Click onto the + button. Rename this spreadsheet to Ex Slice of
Heaven Cake shop. Save your document.

2. Create the following spreadsheet. Don’t forget to centre the heading

and change the font colour.

3. Calculate the cost per slice. This is done by dividing the cake cost by
the slices. For example:

=C5/D5

4. Calculate the profit per slice. The is done by subtracting the cost
per slice from the price per slice. For example,

=F5 -E5

10
5. Which cake makes the most profit per slice?

Custom cakes

6. Which cake makes the least amount of profit?

Elaborately decorated sugar cookies

7. Enter a new formula in Column H cells to calculate the profit for

each cake if every piece of each cake was sold.

8. Design a new cake that could help the Cake Shop generate more
profit.

9. List the ingredients that are used to make this new cake.

flour, eggs, fat (usually butter), sugar, salt, a form of liquid (usually
milk), and leavening agents (such as baking soda)

Exercise 6
1. Click onto the + button. Rename this spreadsheet to Ex 6 – Canteen
Order Form. Save your document.

2. Create a canteen order form for yourself as an online booking

system. Use the example below as a guide. You will need to change
the items and use the prices at the provided by the canteen at WHSC.

11
3. Calculate the Total for each canteen item you are planning to order
by multiplying the price by the quantity. For example

= D8*E8

4. Add the totals for all the items you wish to purchase using the
Autosum function. Write the formula you used and the Total amount
into the space below

If you need to sum a column or row of numbers, let Excel do the math
for you. Select a cell next to the numbers you want to sum, select
AutoSum on the Home tab, press Enter, and you're done.

5. Enter a formula that calculates the CHANGE. Insert the formula

below.

E8+E9+E10+E11=F14

6. What happens to the order form if you change the Quantities and
the amount of money enclosed. Show this on your spreadsheet and
write your answer below.

If the quantity or amount is changed, all totals and change will be

automatically updated because the formula will be recalculated.

Exercise 7
12
1. Click onto the + button. Rename this spreadsheet to Ex 7 –Magic
Square. Save your document.

2. Create a new Spreadsheet as shown below. Use an addition formula

to make it add to 15.

13
Exercise 8

14
Exercise 9

15
Exercise 10

16
1. Click onto the + button. Rename this spreadsheet to Ex 10 –
Cinemania Ticket sales. Save your document.

10. Create 10 multiple choice questions on Spreadsheets using

Kahoot or Blooket.

11. Insert the questions created in the space below:

How often do you use Excel?

What is your favourite chart type?
Do you prefer rows or columns for data entry?
What colours do you use often?

17
Do you find formulas easy?

Exercise 11
1. Click onto the + button. Rename this spreadsheet to Ex 11 –Survey.
Save your document.

18
Exercise 12
1. Click onto the + button. Rename this spreadsheet to Ex 12 – Visitors.
Save your document.

Exercise 13
19
1. Click onto the + button. Rename this spreadsheet to Ex 13 –Goal
Seek. Save your document.

20
21
Exercise 14
1. Click onto the + button. Rename this spreadsheet to Ex 14 –Toadstool
Music. Save your document.

Exercise 15
22
1. Click onto the + button. Rename this spreadsheet to Ex 15 – Party.
Save your document

23