Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE

## What do I need to Learn?

 I need to learn how to identify the different parts of a spreadsheet eg. row, column, worksheet etc. I need to learn how to save and share workbooks I need to learn how to adjust and modify cells and use the fill handle

## Getting Started with Excel

### Introduction

Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

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.

Note: Make sure that you memorise this as there will be a test on it at the end.

## Saving and Sharing Workbooks

Whenever you create a new workbook in Excel, you'll need to know how to save it in order to access and edit it later. As with previous versions of Excel, you can save files locally to your computer. You can also save a workbook to the cloud using OneDrive, as well as export and share workbooks with others directly from Excel.

Click on the link below complete the exercise in Saving and Sharing Excel Workbooks and then complete the challange at the end.

## Cell basics

Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.

Click on the link below and complete the exercise in Cell Basics and then complete the challange at the end.

By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.

Click on the image below to complete the Modifying Worksheets challenge.

### Summing it all up

Lets look at the learning outcomes and decide which one best describes our current level of understanding :

Tick the one you feel is closest to your level

## Learning Outcomes I need to learn how to identify the different parts of a spreadsheet eg. row, column, worksheet etc.

• I have a basic understanding of how I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. with a little help from my teacher
• I can show my teacher that I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. without their help.
• I can identify the different parts of a spreadsheet eg. row, column, worksheet etc. independently and I can also explain it to others and can complete any extension tasks I am given.