Past Paper Questions - Higher Admin

What is this question asking you to do?

To help launch our new Mindfulness Escapes on Arran we are planning to offer a reduced price on accommodation at 4 and 5 star breakfasts to single travellers.

20% will be deducted from the usual cost of accommodation and you should add the cost of the Mindfulness Experience (£100) to work out the promotional price for those that choose to book a single room.

Prepare a report showing the names of the bed and breakfasts included in this offer. Group by star rating showing the promotional prices. Can you also include the number of bed bed and breakfasts included in this offer in the report footer?

• Database query

• Spreadsheet

• Calculated Report

• Aggregate query

What is this question asking you to do?

• Database query

• Spreadsheet

• Calculated report

• Aggregate query

What is this question asking you to do?

• Pivot Table

• Aggregate query

What should this pivot table look like?

• 
• 
• 
• 

What is this question asking you to do?

• Database query

• Spreadsheet

• Calculated report

• Aggregate query

What is this question asking you to do?

• Database query

• Spreadsheet

• Calculated report

• Aggregate query

What is this question asking you to do?

• Pivot table

• Spreadsheet

• Calculated report

• Aggregate query

What is this question asking you to do?

• Database query

• Spreadsheet

• Calculated report

• Aggregate query

If you had this question and were completing a spreadsheet - what formula could would you expect to be using?

• SumIF

• CountIF

• Nested IF Statement

• Lookup

If I was completing a lookup with this information - which one would you use?

• VLookup

• HLookup