Excel Assessment

There is an IF function in D2. What is the correct formula?

• =IF(C2=75,”Pass”,”Fail”)

• =IF(C2>=75,”Pass”,”Fail”)

• =IF(C2>75,”Pass”,”Fail”)

1. There is an IF function in E2. If the pupil is in 11A then the teacher is Mrs Green otherwise it is Mr Jones. What is the correct formula?

• =IF(B2=”11A”,”Mrs Green”,”Mr Jones”)

• =IF(E2=”11A”,”Mrs Green”,”Mr Jones”)

• =IF(B2=”11B”,”Mrs Green”,”Mr Jones”)

1. The pass mark has been changed to greater than 78. What is the correct formula in D2 now?

• =IF(C2=78,”Pass”,”Fail”)

• =IF(C2>=78,”Pass”,”Fail”)

• =IF(C2>78,”Pass”,”Fail”)

There are now only 2 pupils who have passed with marks over 78. Who are they?

• Matthew, Karn

• Olivia, Jessica

• Patel, Asma

• Young, John

What symbol separates the 3 things in the brackets of an IF function?

• =

• ,

• "

• >

What symbol represents less than?

• >

• <

• <=

• >=

What symbol represents greater than or equal to?

• <=

• >=

• ==

• =

Which has the deliberate mistake:

• =IF(B2=”11A”,”Mrs Green” , , ”Mr Jones”)

• =IF(B2=”11A”,”Mrs Green” , ”Mr Jones”)

What is missing here

= (B2=”11A”,”Mrs Green”,”Mr Jones”)

• >=

• if

• ,

• "

What symbol is missing?

=IF(B2=”11A ,”Mrs Green”,”Mr Jones”)

• ,

• >

• <

• "