Home FAQ Contact Us   

Int Spreadsheets EX 3 Ans

Home
Introduction
Courses
Course Exercises
What Is MOUS
FAQ
Links
Downloads
Contact Us

Intermediate Spreadsheet Concepts Exercise 3 Model Answer

horizontal rule

 

The following spreadsheet is an example of how your spreadsheet should look, you can feel free to try different colour combinations.

The following spreadsheet shows the formula's you need to complete the spreadsheet.

 

Note 1: The use of the $ symbol in a cell reference or address, indicates that the cell reference is Absolute or Constant, i.e. does not change a the formulas are copied down or across the spreadsheet.

Note 2: The results shown in this survey have been made up for the purposes of creating a training exercise, and bare no relation to actual fizzy drink preferences people may have. 

 
Download the Fizzy Drink Survey.zip file.  You need a Zip program like WinZip to extract the Excel file from the Zip file.  See our Links Page for a link to the WinZip web site.

Click the BACK button on your browser, to return to the previous page.

 

 

 

| BODMAS Exercises | Word Exercises | Excel Exercises |

| Home | Introduction | Courses | Course Exercises | What Is MOUS | FAQ | Links | Downloads | Contact Us | Site Map |

Copyright © 2001-2009  to Abacus Training College Ltd, All Rights Reserved.

Home