WHS-Y10-EXCEL-L14

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”)

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”)

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

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, Asma

• Olivia, Jessica

• John, Brian

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?

• >

• <>

• <=

What is the "Active Cell" in Excel?

• The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

• The current cell in a worksheet. It is indicated by a dark border onscreen.

• The top cell in a worksheet. It is indicated by a dark border onscreen.

• The past cell in a worksheet. It is indicated by a dark border onscreen.

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

Tags

CCSS.6.SP.B.5C

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =