1 / 9

Enhance Spreadsheet Functionality: Add Discount Field & Calculate Cost

Learn to add a "Discount" field and convert to percentage in Excel spreadsheets. Calculate pre-discount costs to get final amounts. Use checkboxes for ease, and formulas to solve problems. Download examples from Gotoict.stwilfrids.com for KS3 ICT Spreadsheets. Access Tasks and Plenary on the website.

jaafar
Download Presentation

Enhance Spreadsheet Functionality: Add Discount Field & Calculate Cost

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. The Challenge

  2. Add a field called Discount and format to Percentage

  3. Now calculate Cost Before DiscountThe DiscountCost After Discout

  4. Outcomes • Used checkboxes to make spreadsheet more usable • Use formulas and functions (if) to solve a problem

  5. Gotoict.stwilfrids.comKS3 ICTSpreadsheetsDownload Checkbox Examples to your My Documents

  6. Add this to a new sheet called Extras

  7. The Rules

  8. Gotoict.stwilfrids.comKS3 ICTSpreadsheetsSpreadsheets Task 2 file to your My Documents

  9. Plenary • Have a go at the online wordsearch..... • Link on the website

More Related