Jon Rogers
Quiz by , created more than 1 year ago

Quiz on Year 9 Spreadsheet Project Scenario Quiz, created by Jon Rogers on 19/10/2017.

294
0
0
Jon Rogers
Created by Jon Rogers over 6 years ago
Close

Year 9 Spreadsheet Project Scenario Quiz

Question 1 of 8

1

What is the name of the company in the scenario?

Select one of the following:

  • PB's Boutique

  • BP's Boutique

  • JB's Boutique

  • JP's Boutique

Explanation

Question 2 of 8

1

What kind of shop is the company in the scenario?

Select one of the following:

  • Art supplies store

  • Cupcake shop

  • Clothing store

Explanation

Question 3 of 8

1

Which of these things need to be stored in the solution? (Select more than one)

Select one or more of the following:

  • Sale price

  • Cost price

  • Ingredients

  • Names of item

  • Designer

  • Barcode number

Explanation

Question 4 of 8

1

Which of these things need to be calculated in the solution? (Select more than one)

Select one or more of the following:

  • Number of items

  • Profit

  • Remaining stock

  • Nothing

  • Size

Explanation

Question 5 of 8

1

You will need to create an information sheet for the company

Select one of the following:

  • True
  • False

Explanation

Question 6 of 8

1

You will probably need to use the following features of Excel to complete the project: (Select more than one)

Select one or more of the following:

  • Formulas

  • Functions

  • Graphs/charts

  • Formatting

Explanation

Question 7 of 8

1

Which of the following stages of the Project Life Cycle will you complete in this project? (Select more than one)

Select one or more of the following:

  • Initiation

  • Planning

  • Execution

  • Evaluation

Explanation

Question 8 of 8

1

Presenting your work well using formatting, colours, layouts etc IS important

Select one of the following:

  • True
  • False

Explanation