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

    specific range; it also allows you to put an error message on the cells if you enter a number which should not be entered in those cells. To complete a validation, you do the following: 1) High-light the cells you want to validation to be present within, and select "Data" from the top toolbar.

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

    Error messages when impossible data is typed e.g. an item is sold when the company has no more of that item left in stock. The spreadsheet itself is divided and split into many columns and sections. This section will for example include, a Description of Item column, Price, Trade Price, Profit or Loss and Validation checks like, Restock checks and validation checks, to check the quantity.

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

  2. Produce a spreadsheet for a successful and potential company "Belle Du Jour".

    and to put data into a chart to visually illustrate the relationship between different items. The research I will need to conduct is information about the sales services of the company. I will find out the information by interviewing the manager josh brown.

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