• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  • Level: GCSE
  • Subject: ICT
  • Word count: 264

GCSE AQA B Setting Up A Spreadsheet Model

Extracts from this document...


Booking System User guide Key: Speech bubbles are telling you how to do things. The square boxes are hints on how to make it better. Section 1: Setting up the worksheets In this section, I am showing how I set up my sheets and named my cells and sheets. ...read more.


Section 4: Setting up Data Validation You also have to create a error message, so if somebody types in a letter that is not valid, a message comes up explaining why it isn't working. Section 6: Setting up Conditional Formatting To Set Up The Conditional Formatting You Have To. Section 7: Setting up the messageboard Section 8: Naming Cells (Naming Zones) ...read more.


Section 11: Not Needed. Section 12: Using CountIF statements to count the number of Adults, Teenagers & Children =COUNTIF(ZoneA,"C")+COUNTIF(ZoneB,"C") Section 13: Linking cells (e.g. linking floor 1 and floor 2) Section 14: Setting up the accounts page Section 15: Creating a menu Section 16: Creating macros to link the worksheets together Section 17: Decorating the booking system Section 18: Locking Cells ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. AQA GCSE ICT Specification B

    Background to the company The company specializes in personalized rubber ducks for young children. It offers a variety of colours and sizes of toy, each with a personalized name tag. The company was been running for approximately two years and now covers the whole of the UK from it's head branch in Bracknell.

  2. The aim of my project is to make the task of the allocation of ...

    See test 5 6) It will allow detailed examination of all characteristics of show, such as the catalogues, the bar, the type of show, and whether it was a professional performance or an amateur, and price it accordingly showing the overall cost.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    This then inserted the MAX function into the cell. Excel often inserts the cell range which it thinks you want to use, but it is important you check the range, as it could possibly be different to what you actually want it to be.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    * Should calculate the profit and loss of the company. * Will notify any mistyped data on the system. This will be accomplished by using validation checks. * Retrieve data rapidly TASK C: Spreadsheet coursework page 2 * Clear and simple instructions for both beginners and advanced users.

  1. Database Section

    that will need to be used for my database project. I am going to use a black and white laser printer, as it is fast and cheap to use. A black and white printer rather than a colour inkjet printer will be the most practical.

  2. Produce a spreadsheet for a successful and potential company

    * You can also produce graphs from the spreadsheet. These are more accurate. * You also save a lot of time as computer are more effective. I will set this spreadsheet up by using Microsoft excel. This is a software package that allows you to create financial spreadsheets and reports

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work