Lesson 1 - Excel

Excel 1

By Mr Wilkinson

What are we going to learn?

Over this module, you will learn how to enter and format data, use formulas for calculations, create charts, sort and filter information, and apply basic functions to organise and analyse data effectively.

• Microsoft Excel is a spreadsheet program made by Microsoft.

• It helps users to store, organise, and analyse information.
  
  

What is Microcoft Excel

• Tracking Money (Budgets)

• Organised Lists (Scores)

• Charts & Graphs

• Perform calculations quickly.

People Use Excel For:

The Ribbon

Cells

Columns

Rows

Formula Bar

Labelling

Label the areas

Drag labels to their correct position on the image

Cell

Row

Ribbon

Formula Bar

Column

5 Keywords and their definitions

• The Ribbon – A toolbar with different buttons for formatting, formulas, and tools.

• Cells – Small boxes where data is entered.

• Columns – Vertical sections labelled A, B, C, etc.

• Rows – Horizontal sections labelled 1, 2, 3, etc.

• Formula Bar – Shows what is inside a selected cell.

Keywords

Match

Match the words to their definitions

• The Ribbon

• Cells

• Columns

• Rows

• Forumla Bar

Toolbar with different formatting tools.

Small boxes where data is entered.

Vertical divisions in a spreadsheet.

Horizontal divisions in a spreadsheet

Shows what inside the selected cell

• Toolbar with different formatting tools.

• Small boxes where data is entered.

• Vertical divisions in a spreadsheet.

• Horizontal divisions in a spreadsheet

• Shows what inside the selected cell

Multiple Choice

Horizontal sections labelled 1, 2, 3, etc. are called?

• Rows

• Columns

• Cells

• Ribbons

Multiple Choice

The toolbar with different buttons and formatting tools is called?

• Rows

• Columns

• Cells

• The Ribbon

Multiple Choice

Vertical sections labelled A, B, C, etc. are called?

• Rows

• Columns

• Cells

• Ribbons

Multiple Choice

Small boxes where data is entered are?

• Rows

• Columns

• Cells

• Ribbons

Labelling

Label the areas

Drag labels to their correct position on the image

Ribbon

Column

Formula Bar

Row

Cell

Draw

Colour in Cell F2

Draw

Circle the ribbion

Draw

Colour in Cell B2

• Click File > Save As.

• Choose a folder and give your file a name.

• Click Save to keep your work.

• Use Ctrl + S to save quickly.

• Save your file as an Excel Workbook (.xlsx).

Saving Your Work

Multiple Choice

What are these called again?

• Apples

• Columns

• Rows

• Ribbon

Multiple Choice

Which cell is highlighted?

• E2

• B2

• F7

• E6

Multiple Choice

Which cell is highlighted?

• A7

• C3

• G2

• E9

Multiple Choice

Which cell is highlighted?

• A1

• B2

• B8

• E6

• Press the start button then fod your documents.

• In that folder there should be a "Spreadsheets" folder followed by a Lesson 1 folder.

YOU WILL NEED TO OPEN BOTH FILES.

Todays Worksheet.