untitled

INTRODUCTION TO SPREADSHEETS

S1 ICT

Microsoft Excel

Is a spreadsheet file used to carry out calculations. You can also create charts and graphs.

​There are 3 parts to a spreadsheet...

1. Cells

2. Rows

3. Columns​

S1 ICT

Cells are the individual boxes that make up a spreadsheet​...

Cells...​

​

Rows go across the way...

Rows...​

​

Columns go up and down...

Columns...​

​

Row and columns...​

​

Multiple Choice

Which colour is the column?

• Red

• Green

Cell References

When we use excel we use "cell references" this is another way of saying each cell has a name.

Cell References...​

​

​When we "name" a cell we use the letter from the column and the number from the row.

​

Here are 5 examples...​

Cell References

Now that you know what a cell reference is you have some questions to answer...​

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Task 1

We are going to start with a task to help you find your way around excel.

You ​will be using the fill tool to shade in a number of cells different colours...

​

Your task is to use excel to re-create the following country's flags...​

France

​Iceland

Scotland​

​Sweden

Germany​

Greece​

​

​Here are some examples...

Demonstration...

Your teacher will now lead you through a demonstration on their board...

​

Task 1 - Flags

We are going to start with a task to help you find your way around excel.

You ​will be using the fill tool to shade in a number of cells different colours...

​

Your task is to use excel to re-create the following country's flags...​

France

​Iceland

Scotland​

​Sweden

Germany​

Greece​

​

Task 2 - Pixel Art

For this task you are going to need to make a small change to your spreadsheet.​ Your teacher will talk you through this as a class.

​

Using your spreadsheet and the fill tool you have to create different pixel art, here are some examples...​

​

Open Ended

Did you enjoy using the Quizizz lesson today?

Open Ended

What 2 new things did you learn today in ICT?

Multiple Choice

Microsoft Excel is what type of software?

• Word Processing
• Spreadsheet
• Presentation
• Drawing

Multiple Choice

What do you call the blank boxes on a spreadsheet?

• cells
• info
• squares
• spots

Multiple Choice

A spreadsheet is made of cells organised into horizontal rows and vertical?

• Columns
• Fields
• Records
• Blocks

Multiple Choice

Spreadsheet rows are easily identified by:

• a. numbers.
• b. letters.
• c. Roman numerals.
• d. colors.

Multiple Choice

Spreadsheet columns are easily identified by:

• a. Roman numerals.
• b. numbers.
• c. letters.
• d. colors.

Multiple Choice

Which of the images below represent Microsoft Excel work environment ?

Multiple Choice

The pages of a spreadsheet application is called____________

• slides

• pages

• sheets

• document

Multiple Choice

What is another name for Spreadsheet?

• Microsoft Word

• Microsoft PowerPoint

• Microsoft Excel

• Microsoft Windows

Multiple Choice

What is the name of this Toolbar?

• Menu bar

• Tittle bar

• Formula bar

• None of the above

Multiple Choice

What is this called in Excel?

• Column

• Row

• Numbers

• Cell

Multiple Choice

What's the name of the Cell that is highlighted?

• 3B

• B2

• C3

• B3

Multiple Choice

Spreadsheet is mainly used for _________________.

• Written Text

• Add Images

• Calculations

• Presentation

Multiple Choice

C5 is known as the ________________.

• Cell

• Row Name

• Cell Address

• Column Name

Multiple Choice

Name the image.

• Cell Reference

• Name Box

• Formula Bar

• Standard Toolbar

Multiple Choice

You can format text in Excel by making it bold, italic, etc.

• True

• False

Multiple Choice

Worksheets are made up of rows and columns.

• True

• False

Multiple Choice

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Multiple Choice

Which of the following is a valid formula?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)

Multiple Choice

Putting cells into A-Z order is called?

• Sort Ascending
• Sort Descending
• Filter Ascending
• Filter Descending

Multiple Choice

Which formula would you use to multiply cell B4 by cell C4?

• =B4*C4
• =B4xC4
• =(B4:C4)
• B4xC4=