INTO Essentials End of Year Quiz

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