1 / 16

Spreadsheets

Spreadsheets. Lesson 3: Formatting and formulas. Lesson Objectives. To understand how to format a spreadsheet to improve the appearance To understand more complex formulas to find the average, minimum and maximum totals. Formulas. Which formulas do we already know?

vanya
Download Presentation

Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheets Lesson 3: Formatting and formulas

  2. Lesson Objectives • To understand how to format a spreadsheet to improve the appearance • To understand more complex formulas to find the average, minimum and maximum totals

  3. Formulas • Which formulas do we already know? • Why do we use these formulas? • Go to Common K>ICT>Year 7>Spreadsheets • Open the file called Games

  4. Average • How would you work out the average of these numbers? Average = sum of elements/number of elements Average = (7+8+5+9+10+10+9+8)/8

  5. Games • You need to fill in the income column (From F5 to F14) • When you have worked out individual totals, use a formula to fill in the TOTAL INCOME cell

  6. http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/ • Section 3 – Formulas and functions

  7. Average • In excel we can make this process a lot easier. =AVERAGE(A1:A9) All formulas start with an = The name of the formula is AVERAGE The range of cells that we want to find the average for is A1 to A9

  8. Max and Min • You can work out the maximum number and the minimum number in the same way. =MAX(A1:A9) =MIN(A1:A9) Fill in the Average, Min and Max cells on your sheet

  9. http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/ • Section 2 – formatting

  10. Formatting • Formatting is when you use presentation tools to make something look more presentable. • Which tools would you use to make the spreadsheet more presentable?

  11. Borders and shading • At the top of your page you have options to add a border. • Select the cells you want to alter, then select the border you want to use. • You can fill with the paint bucket and change the font colour too

  12. Merge and Wrap • If you want to merge some cells togeher, so that they become one big cell you need to • Highlight the cells. Click MERGE AND CETNRE at the top. • You might also want to wrap text. This puts the text onto more than one line

  13. Data Type • You should have noticed that the costs in spreadsheet do not have £ signs. • Alter the type of data in the cell by highlighting all the ones that need changing • Right click and select Format Cells • Select the Currency type.

  14. Your task • Format your spreadsheet so that it looks more presentable. • You may want to • Add a border • Change heading colours • Bold/Underline • Change costs to currency • Rezietext

  15. An example

  16. Extension • Open the spreadsheet called Susie’s Sweet Shop. • Complete the exercises

More Related