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

GCSE AQA B Setting Up A Spreadsheet Model

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    had got and the gift voucher amount each child had received depending on how many merits the child had gained; how many students had exceeded targets, and the bonus amount the teacher will receive depending on the number of exceeded targets; comparisons of class averages from this year and previous

  2. 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.

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

    more sophisticated, I will include validation checks and include a feature to alert the user when they need to Re-stock. TASK D: Spreadsheet coursework page 1 D: Design Of Solution: My design of solution is to design a spreadsheet that will organise all the association's files in a limited amount

  2. 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.

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

    whether it was a professional performance or an amateur, and price it accordingly showing the overall cost. It will also allow detailed reference of how many children were there, the amount of adults and concessions, and allow their prices to be changed in an easy change of data Chapter 2:

  2. Produce a spreadsheet for a successful and potential company

    I will also be asking about the network they use and the type of software that is available to me this will be researched by interviewing the technical director of the company. I will also be conducting a survey for the staff at employees asking what they would like to

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