Autofill is found in most spreadsheet packages and helps to quickly enter frequently used series of data. Examples include:

Dates

Days of the Week

Series of Numbers

Autofill works by dragging the bottom right-hand corner of a cell. As you hover the mouse over the corner, a cross will appear. Click and drag either down, or across to fill other cells. Autofill Spreadsheets A cell can be formatted to give the data meaning. Watch the video below to learn how to format cells in a spreadsheet. Formatting Cells Each box in the spreadsheet is called a cell. Each cell has its own reference label, named after the column and row that its positioned in.

In the spreadsheet below, the shaded cell is where column B and row 3 meet. This cells reference is B3. Columns, Rows & Cells This spreadsheet has nine rows and six columns A spreadsheet is made up of rows and columns.

Rows go across the page and are labelled with numbers.

Columns go down the page and are labelled at the top with letters. Columns, Rows & Cells However, typing in every cell you want to add together can be quite time consuming, so it’s better to use the SUM function:

=SUM(B4:D4)

(B4:D4) just means all the cells from B4 to D4. To find the total cost of buying the computer, computer desk and printer from Shop 3, you need to use the formulae:

=B4+C4+D4 Simplifying Formula You can use a simple addition formula to find out how much a computer and printer from Shop 1 would cost.

Price of Computer = Cell B2

Price of Printer = Cell D2

The formula to add these two together is B2 + D2 Below is a spreadsheet showing the cost of computer equipment from three shops. Calculations using Simple Formula You can use the average function to find out the average price of a computer:

=AVERAGE(B2:B4) Simplifying Formula All formulae in Spreadsheets need to begin with the = sign. This tells the cell to expect a formulae.

Other simple formulae you should know are listed in the table below. Type in: = B2+D2 Calculations using a Simple Formula

### Present Remotely

Send the link below via email or IM

CopyPresent to your audience

Start remote presentation- Invited audience members
**will follow you**as you navigate and present - People invited to a presentation
**do not need a Prezi account** - This link expires
**10 minutes**after you close the presentation - A maximum of
**30 users**can follow your presentation - Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

### Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.

You can change this under Settings & Account at any time.

# Spreadsheets - the basics

No description