Back to the full dot-point answer
SingaporeComputer ScienceQuick questions
Spreadsheets and Data Processing
Quick questions on Logical and lookup functions explained: O-Level Computing
6short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is the IF function?Show answer
The IF function chooses between two results based on a condition. It takes three parts:
What are comparison operators?Show answer
IF conditions use comparison operators: = (equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to) and <> (not equal to).
What are nesting IF for more than two outcomes?Show answer
For three or more outcomes, put another IF in the false part. The conditions are checked from the outside in:
What is the VLOOKUP function?Show answer
VLOOKUP (vertical lookup) finds a value in the first column of a table and returns a value from another column in the same row. It takes four parts:
What is q1?Show answer
Write an IF function in B2 that shows "Yes" if A2 is greater than , otherwise "No". [2 marks]
What is q3?Show answer
Explain why the search value for VLOOKUP must be in the first column of the table. [2 marks]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.