Introduction to MS Excel
Unit 4
Spreadsheet
Aim: To work with a spreadsheet software.
Learning Objectives:
By the end of this unit, the pupil will be able to:
• Open and close a spreadsheet software
• Create a simple spreadsheet
• Edit a simple spreadsheet
• Format a simple spreadsheet
What is a Spreadsheet?
A Spreadsheet consists of rows and columns.
Some examples of Spreadsheet programs are:
Opening Microsoft Office Excel 2007
1. I click on the Start button.
2. I click on All Programs.
3. I click on Microsoft Office.
4. I click on Microsoft Office Excel 2007.
OR
Closing Microsoft Office Excel 2007
Row, Column and Cell
Activity 1: Shading columns
Shade column A, column D and column Gin the spreadsheet below:
Activity 2: Shading rows
Shade row 2, row 6, row 4 and row 7 in the spreadsheet below:
Activity 3: Identifying cells
Write the following cell’s addresses in the correct cell of the spreadsheet below:
Activity 4: Identifying cells
Shade the following cells in the spreadsheet below:
Activity 5: Fill in the blanks
1. When I open Microsoft Office Excel 2007, the active cell is _________.
2. I press the right arrow key 3 times, now the active cell is __________.
3. From there, I press the down arrow key 5 times, cell ______ becomes active.
4. I must press the left arrow key ______ times so that B6 becomes active.
Activity 6: Entering text in the cells of a spreadsheet
Activity 7: Deleting text in the cells of a spreadsheet
Activity 8: Changing text in the cells of a spreadsheet
Activity 9: create a simple spreadsheet to show Grade 3 pupil’s information:
Activity 10: Adding a row in a spreadsheet
Insert a row between row 3 and row 4 in the spreadsheet “Pupils Info”
to add information for Deven who is 7 years old and lives at Coromandel.
1. I open the file “Pupils Info”.
2. I right click on row number 4.
Activity 11: Adding a column in a spreadsheet
Insert a column titled “SURNAME” between column A and column B in
the spreadsheet “Pupils” and add the following surname of each pupil:
Amira: Mohamed
Christian: Ng
Deven: Ramsamy
Pravin: Ramlall
Rita: Burton
1. I open the file “Pupils Info”.
2. I right click on column letter B.
Activity 12: Deleting a row in a spreadsheet
Pupil Amira Mohamed has been transferred to another school. Delete
her information from the spreadsheet “Pupils Info”.
1. I open the file “Pupils Info”.
2. I right click on row number 2
Activity 13: Deleting a column in a spreadsheet
Delete the column “Age” from the spreadsheet “Pupils Info” ..
1. I open the file “Pupils Info”.
2. I right click on column letter C.
Activity 14: Adjusting a column’s width in a spreadsheet
Adjust the width of column C.
1. I open the file “Pupils Info”.
I can see that the word Coromandel does not fit in the ADDRESS column.
Activity 15: Fill in the blanks with the words given below:
click, tables, spreadsheet, rows
a. A spreadsheet consists of ______ and columns.
b. Spreadsheets are used to represent information in the form of
c. Microsoft Office Excel is an example of a _______ program.
d. To make a cell active in a Microsoft Office Excel I _______on it.
Activity 16: Interpreting data in a spreadsheet
Activity 17: Select cells A2, B2 and B3 in the spreadsheet “pupils info”
1. I open the file “Pupils Info”.
2. I click on cell A2.
Activity 18: Changing font in a spreadsheet
Change the font of the pupils’ name to Comic Sans MS in the
spreadsheet “Pupils Info”.
1. I open the file “Pupils Info”.
2. I select cells A2, A3, A4 and A5.
4. I go down the menu until I see the Comic Sans MS font.
5. I click on Comic Sans MS
Activity 19: Changing the font size in a spreadsheet
Activity 20: Changing the font colour in a spreadsheet
Change the font colour of the pupils’ addresses to red in the
spreadsheet “Pupils Info”.
1. I open the file “Pupils Info”.
2. I select cells C2, C3, C4 and C5.
Activity 21: Create a simple spreadsheet to show marks and grade of pupils of Grade 3 in a Maths test:
Activity 22: Apply the following formatting to the file “maths test” :
1. Change the font of the words NAME, MARK and GRADE to Times New Roman
and their font size to 16.
2. Change the colour of the names of pupils to blue.
3. Apply bold to the grade of Pravin and change its colour to red.
4. Italicize Amira’s name.
5. Adjust the columns’ widths where the text does not fit in.
6. Save and close the file.
