1 / 6

Excel Spreadsheet Improvement Guide for a Higher Mark

Enhance your spreadsheet skills in 2 hours by seeking and implementing feedback, testing calculations, and adding features like color schemes and charts. Learn how to draw a break-even chart in Excel.

tamal
Download Presentation

Excel Spreadsheet Improvement Guide for a Higher Mark

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. CAB ACTIVITY 2 HOUR FOUR

  2. COMPLETE MORE SECTIONS OF ACTIVITY 2 REVIEW SHEET

  3. SEEK FEEDBACK ON YOUR SPREADSHEET • Seek feedback • Record feedback on Activity 2 review sheet • Take “before” screenshots and paste into review sheet

  4. MAKE IMPROVEMENTS • Make improvements • Take “after” screenshots • Paste into Activity 2 review sheet

  5. SOME QUESTIONS TO RECORD • Have you… • How do you know if your spreadsheet is calculating correctly? • Would it be a good idea to test your spreadsheet? • How could you test your spreadsheet? • Have you put enough features into your spreadsheet to get a high mark? • Does your spreadheet do what it’s supposed to? Have you checked what it says on the VLE? • FEATURES: Five Functions; colour-schemes; cell formatting; break-even chart; navigation system; 3-d version;

  6. HOW CAN YOU FIND OUT HOW TO DRAW A BREAK EVEN CHART IN EXCEL?

More Related