GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)

Lucy Hayfield 20 questions 4.0 (1 rating)

Take the quiz

Questions in this quiz (20)

  1. 1What are four advantages of using a spreadsheet to answer 'what-if?' questions?
    1. AIt is quicker and easier than using a physical model, saving time and money.
    2. BIt is less risky, as lots of questions can be asked within the spreadsheet model to test many scenarios, before they are tested in real life.
    3. COnly one model needs to be built, which can then be changed. If a physical model is built, then a different one will be needed each time a change is made.
    4. DNo-additional software is required: spreadsheets are standard business software. Most people are able or have the knowledge on how to use a spreadsheet, so there is no need for additional specialist training.
    5. EUsing lots of 'what-if?' questions could slow down the spreadsheet's performance, making if more difficult to carry out other tasks.
    6. FYou can use these questions to test out physical models as well as spreadsheet models.
    7. GYou can choose from a drop down menu of personalised 'what-if?' questions within the spreadsheet model, so you don't have to type out the whole question yourself, which therefore saves you time and money.
  2. 2Absolute cell referencing is when a cell referenced in a formula changes when it is copied to other cells.
    1. ATrue
    2. BFalse
  3. 3What are two advantages of using ranges in a spreadsheet model?
    1. AThere is less chance of an error if you use ranges, rather than highlighting individual cells
    2. BThe ranges can be named so are easier to remember when writing a formula.
    3. CUsing ranges is safer, because clicking on lots of individual cells could slow down your computer's performance and make you become tired.
    4. DLots of ranges can be given the same identical name, so you can have lots of choice when it comes to choosing a range to include in a formula.
  4. 4What are two advantages of storing data across multiple worksheets in the same workbook?
    1. AYou can give access rights to certain worksheets, so only certain people could look at certain worksheets.
    2. BThe different worksheets can be saved individually as a separate file, so you don't have to look at data within other worksheets if you don't need to.
    3. CThe data can be organised into separate worksheets, but could still be used in formulas across the whole workbook.
    4. DData that is not used often can be deleted entirely and never seen again, aiding with the organisation process.
  5. 5Relative cell referencing is when a cell referenced in a formula changes when the formula is copied to other cells.
    1. ATrue
    2. BFalse
  6. 6What could absolute cell referencing be used for in a financial spreadsheet model?
    1. AChanging price values of products
    2. BVAT Rate
    3. CTotal sales
  7. 7What are two advantages of using modelling software to create a model of the expansion of a building?
    1. AYou can look at various layers and angles of the building, giving you a clear idea of what the building would look like in real life.
    2. BAllows 'what if?' questions to be used, so different scenarios can be tried to find the best one.
    3. CSoftware add-ons are free of charge so you can every possible feature within the modelling software to create the building model.
    4. DVariables can be used and can be changed to try different scenarios without rebuilding the model.
    5. EYou can view the model of the building on many different electronic devices, allowing for easy editing on-the-go.
  8. 8A variable is the name of a cell/the cell reference.
    1. ATrue
    2. BFalse
  9. 9A function uses made up words to work/carry out a particular task.
    1. ATrue
    2. BFalse
  10. 10What are four elements that could be tailored in a spreadsheet?
    1. AA menu bar, with a drop down menu which can have options added or removed.
    2. BCells, which can be made secure with different access rights.
    3. CIcons, which can be added/removed/edited.
    4. DButtons, to press/toggle and carry out commands.
    5. EError messages, specific to the spreadsheet being used can be created to tell the user that they have done something wrong.
    6. FScreen resolution, which can be set to high so that the user can view the spreadsheet at a high quality with no obvious pixels.
    7. GSound, which can be turned on and off when they user is carrying out a certain task.

Information

Description
Quiz foe Spreadsheet concepts (chapter 4) of OCR ICT AS Level
Language
English
Views
72
Rating
4.0 out of 5 · 1 rating
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?