Starter task Can you label the cells highlighted

Starter task: Can you label the cells highlighted on your worksheet? B 2 B 18 H 9 E 7 I 25 F 23 S 28 Sheet 1 We do not know, we can’t see the name of the file!

Spreadsheets with Microsoft Excel Learning Objectives: All: Use Microsoft Excel to create spreadsheets and manipulate numerical data. Apply a variety of professional editing, formatting and layout techniques. (Level 1 and 2) Most: Learn the best tools and features to solve a range of everyday problems. (Level 1 and 2) Some: Learn more advanced formula to help solve the given problem (absolutely cell referencing, IF statements, VLOOKUPs, etc. ) (Level 2)

Name box containing a cell Selected cell reference or active cell Heading bars Worksheet A spreadsheet stores information in a grid of cells. Generally, they contain text, numbers or formulas. Cells are arranged in rows (across the screen) and columns (down the screen), forming a worksheet. One or more worksheets are together known as a workbook. When referring to a cell, the column letter always comes before the row number.

Activity 1: Creating a spreadsheet. When creating a spreadsheet you should start on Sheet 1 and begin entering data in the top left corner. Also, remember that adding a title and labels help describe the contents of the spreadsheet and give the information meaning. It is very important that you enter the numbers correctly and accurately. There is a common quote when using an ICT system – GIGO: Garbage In, Garbage Out – when you make mistakes in your spreadsheet you will produce the wrong results. All: Use the worksheet to create the given spreadsheet. (Level 1) Most: Update your skills checklist as you progress. Some: Experiment with changing values, aim to predict what effects this will have on your spreadsheet. (Level 2)

What am I? I am the name of a box which contains text, numbers or a formula. I am what you type in to get the spreadsheet to work out a calculation for you. Cell or Cell Reference A Formula My name is always a letter in the alphabet. I go down the spreadsheet. Columns My name is always a number. I go across the spreadsheet. Rows I am what you should do to your spreadsheet to make the data clearer and easier to read. Formatting