spreadsheets entry-l2. what will you learn today? what is a spreadsheet and why do joiners need...

Spreadsheets Entry-L2

What will you learn today?• What is a spreadsheet and why do joiners need

spreadsheets?• Be able to identify parts of a spreadsheet.• Be able to move around a spreadsheet, enter data and

formula.• How to use the SUM function to add a range of numbers?• How to replicate a formula?• How to add rows and columns?• How to change the orientation and print with gridlines?• How to work out the Average, Minimum and Maximum?• How to format a spreadsheet?

What is a spreadsheet?

• A program in grid format of rows and columns, to store and manipulate numbers

• Using formulae means that any changes are automatically updated for the whole spreadsheet. This very powerful feature enables forecasts to be made in seconds!

Why do YOU need to learn spreadsheets?

• Personal weekly/monthly budget• Personal investments• Personal finances• New Job• Promotion

Parts of a spreadsheetWorkbook nameFormula Bar

Active CellCell address is D4

Worksheet 1

Column Headings(Letters)

Row Headings(Numbers)

Menus

Ribbon/Toolbar

Label - BootsValue - £24

Moving around a spreadsheet

• Use the arrows on the keyboard

Entering Text AND Widening ColumnsWhen entering BASIC CALCULATIONS in cell A1, it appears like it extends into B1 – THIS IS NOT SO!To correct this you must widen the column:Drag the line between A & B or DOUBLE CLICK left mouse button between A & B

Formula Symbols

All formulas begin with =

(Add)

(Minus) (Multiply)

(Divide)

+- */

Write Formulas

10 + 20 =A1+B120 – 10 =B1-A120 ÷ 10 =B1/A110 X 20 =A1*B1

Add

What formula would you use in D4?

=D2+D3

Minus

What formula would you use for column D?

=B3-C3=B4-C4=B5-C5=B6-C6=B7-C7

Multiply

What formula would you use for C3?

=A3*B3

Task 2 Workbook Exercise 1

**Finish quickly?** – Go to website www.lizcurrie.org, click Quizzes and scroll down to:

Task 1www.lizcurrie.org – Level 1 Spreadsheets – Drag and

drop game parts of a spreadsheet

Using the SUM function to add a range of numbers

Three ways:

1. =SUM(A3:A8) 2. =SUM( then click on A3 an drag mouse to A8)

3. Using AUTOSUM

REMEMBER TO PRESS ENTER KEY AFTER FORMULA

Replicating Formula

Position mouse in right corner.

Wait for cursor to change to a thin black cross.

Left click and drag from the black square down the rest of the column, then release the mouse.

Add Gridlines and Change Orientation

To change to LANDSCAPE• Choose the PAGE

LAYOUT tab• Choose Orientation and

then Landscape

To add GRIDLINES• Choose the PAGE

LAYOUT tab• Add a tick to Print in the

Gridlines section

Workbook Exercises 3Exercise 4 – Recap and Practice

**Finish quickly** – www.lizcurrie.orgQuizzes – Spreadsheet Word Search (interactive)

Adding Rows and Columns

• To add a new ROW – right-clickOn a number and choose INSERT.(The new row will appear above).

• To add a new COLUMN – right-clickOn a letter and choose INSERT.(The new column will appear to the left).

Or click on HOME TAB and choose INSERT.

Workbook Exercise 5

Group Quiz

Recap Exercise 6 A-D

**Finish quickly** – www.lizcurrie.orgQuizzes – Spreadsheet Word Search (interactive)

The End