What formula.... Spreadsheets

What formula would you use to find the information to go in the red highlighted cells?

• Nested IF

• = then click on the answer from the other sheet

• Lookup

If using a VLookup and I want to find out the price which column number would I put in?

• 1

• 2

• 3

• 4

If you seen this; what formula do you expect to be using?

• HLookup

• VLookup

What formula would you use to find out 20% VAT?

Match the following

• Pivot Table

• Used to summarise information

• Nested IF

• Used to organise information into a specific order

• Absolute Cell Reference

• Used to find information in another sheet in the spreadsheet

• Lookup

• Used to ask the spreadsheet a question with multiple outcomes

• Sorting

• Used to "lock" a cell in place

If you see this, what two formulas are you expecting to use?

• CountA

• CountIF

• Nested IF

• SumIF

Discount is subtracted from the cost

• True

• False

VAT is added to the cost

• True

• False

If you seen this on the spreadsheet or in the paper what formula would you expect to be using?

• Nested IF

• VLookup

• HLookup

• SumIF

If you are printing a spreadsheet in formula view what should you apply?

• Footer

• Gridlines

• Row & Column Headers

• All information on one page