WorksheetsINTO Essentials End of Year Quiz
Total questions: 9
Worksheet time: 4mins
Excel is which type of software?
Database
Wordprocessing
Spreadsheet
Graphics
What is the address of this cell?
B2
E6
E4
D9
What formula is needed in the yellow cell to work out the Sales Tax?
=A2+B2
=D4*J4
=D4*$J$4
=D3*J3
What formula is needed to Total the food ordered.
A7+B7
=SUM(B2:B6)
=SUM(B2:B6
=Average(B2:B6)
Spreadsheet software is used to...
Create models
Create graphs
Manipulate numbers
All of the above
The least effective revision method is...
Creating summarised notes
Reading through your notes and text book
Creating Mindmaps
Answering past exam questions
The most effective revision method is...
Reading through your notes
Using a variety of revision methods ie. summarised notes, answering past exam questions, revision cards, mindmaps
Answering past exam questions
Revising with a friend
A Pivot Table is used to...
Create tables
Merge data into one table
Look at several tables at the same time
Analyse a set of data
Using slicers in a pivot table allows you to...
Sort the fields in alphabetical order
Filter on fields that don't show in your pivot table
Filter and see what items have been chosen within the pivot table
Slice the data in to several sections within your pivot table
