ICT - Spreadsheet

1) What cell is Cell A4.

• 45

• Math 

• Subject 

• Science

• None of the above

2) Note Cell C6.

• Term 1

• Math

• 34

• 23

• None of above

3) How do we calculate "Total marks ( /100)" in E4?

• B4+C4+D4

• =B4 C4 D4

• =B4+C4+D4

• =(B4+C4+D4)

• = B4 + C4 + D4

4) How to type out the 'IF' statement in spreadsheet?

• if(3D-45, 'Pass', 'Fail')

• if D3=45, 'Pass', 'Fail')

• =IF(D3<45, "Pass", "Fail")

• =iF(D3>45, 'Pass', 'Fail')

• None of above

5) What cell is this?

• D3

• E6

• C2

• E5

• None of above

6) What row is it in?

• A

• E

• 6

• 1

• None of above

7) What column is it in?

• E

• A

• 3

• 8

• None of above

8) What cell is this?

• D5

• A6

• E5

• B3

• None of above

9) What row is the cell in?

• E

• A

• 3

• 4

• None of above

10) What column is it in?

• E

• 6

• B

• 9

• None of above