Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
0 results for
ICT

# Lesson 1 - Formatting and Formula

0 results forGuest
##### Learning Objectives
0 results forGuest
IDSkill_name
1 I can calculate sums using a spreadsheet.
3 I can identify the different elements of a spreadsheet e.g. 'row', 'column', 'cell' etc.
2 I can adjust cell height/width and edit columns and rows

## Calculating Sums

### Extension activity

Put the above sums into an excel worksheet.

See if you can use a simple formula to work them out?

#### 🏁 Learning Objective 2 :- I can identify the different elements of a spreadsheet e.g. 'row', 'column', 'cell' etc.

A spreadsheet appears as a grid - each row has its own number and each column its own letter. This labelling of rows and columns is used to give each cell a cell address or reference, for example, C5 means column C, row 5.

It is also possible to refer to a range of cells collectively, ie E4:E12 includes E4, E12 and all of the cells in-between.

Cells can contain numbers, text or formulae.

### Exercise - Check your understanding

#### 🏁 Learning Objective 3 :- I can adjust cell height/width and edit columns and rows

Click on the image below to complete the Modifying Worksheets tasks

## Creating Charts

Click on the image below to complete the Modifying Worksheets tasks