Spreadsheets Advanced

What will this expression achieve

• Merge two cells together into one cell

• Separate a cell into two cells

• Add up the value of two cells

• Divide the value of two cells

What will happen when OK is pressed?

• The data will be filtered by Pathway and Grades

• The data will be Sorted by Pathway and then Grades

• The data will be Sorted by Grades and then Pathway

• The data will return to its original state

The graphic is an example of...

• Using the Sort function

• Using the filter function

• Multiplying data

• Using the multiplication function

Which is an example of an absolute cell reference?

• A15

• A*15

• A$15

• $A$15

Which of these VLOOKUP functions is searching for an exact match?

• =VLOOKUP (True, A2:B6, 2, C16)

• = VLOOKUP (C16, A2:B6,3, TRUE)

• =VLOOKUP (C16, A2:B6, 3, FALSE)

• =VLOOKUP (C16, A2:B6,1, $C$4:$D$15)

We want to make a Payment Type Column (cash, credit card, bank transfer) as a drop-down list. Which feature should we use?

• Conditional Formatting

• Data Validation

• Sort

• Filter

I want a formula to return "yes" in a cell if a customer has paid at least £20. Which formula is correct?

• =CONDITIONAL(B2>=20, "No","Yes")

• =IF(B2>=20, "Yes","No")

• =IF(B2=20, "Yes","No")

• =CONDITIONAL(B2>20, "No", "Yes")

The IF function makes use of something called...

• Functional operators

• Relational Database

• Absolute referencing

• Relational Operators

Which of the following operators do you use to begin typing a formula?

• *

• +

• =

• /

f the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')

• Pass

• Fail

• 60