Y7: Spreadsheets Retrieval- Lesson 3

Formulas always starts with:

• -

• =

• (

• ()

The first test in an IF statement is always:

• False

• True

• In the middle

• Both

The second test in an IF statement is always:

• True

• False

• Both

• None

Which one of the follow is a correct format to query an IF statement?

• IF(C1 = D1, True, False)

• =IF(C1 = D1, True, False)

• IF(C1 = D1, False , True)

• =IF(C1 = D1, False , True)

Which of the following are comparison operators?

• +

• =

• -

• &

Which operator is equal to?

• =

• >

• <

• >=

Which operator is less than?

• =

• >

• <

• >=

Which operator is more than?

• =

• >

• <

• >=

Rather than outputting TRUE or False we can change these values to our own by using what?

• "_____ "

• (_____)

• *_____*

• !_____!