ICT IGCSE Quiz

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Zoe wants to add together a range of cells in her spreadsheet. She would like Excel to add only the cells in the range that are greater than 50. What function should she use?

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

If you see this code, what do you need to do?
#####

• Check your function syntax
• Re-enter the function formula
• Widen the column
• Use a different function

If a student scores over 20 in the exam, the adjacent cell must state PASS otherwise it should say FAIL.

Select the correct formula that must be typed in cell C4.

• =IF(B4>20,"PASS","FAIL")

• =IF("PASS"=>20,B4,"FAIL)

• =IF(<20,B4,"PASS","FAIL")

• =IF(B4<20 "PASS","FAIL")

You've been asked to Extract a list of countries that use dollar as their currency. How would you do this?

• Use a filter

• Use a formula

• Use a function

• Use a chart

You have been asked In cell D10 enter a function to lookup the destination for Robert Maxwell.

What function would you use?

• VLOOKUP

• IF

• AVERAGE

• SUMIF

You have been asked In Cell D2 use a count formula that counts the frequency of AQA in cell range E3 to E25.

Which is the most appropriate function to use?

• COUNTIF

• SUMIF

• VLOOKUP

• IF

Which of the below formulae includes absolute cell referencing?

• =B7*$D$21

• =SUM(A2:D5)

• =IF(D5=5,"MET","FAIL")

• =AVERAGE(H7:H20)

What is the correct format of an IF statement

• =IF (TEST, VALUE IF TRUE, VALUE IF FALSE)

  =IF(A1>B1,"YES","NO")

• =IF (TEST VALUE IF FALSE VALUE IF TRUE)

  =IF(A1>B1,NO, YES)

• =IF TEST,VALUE IF TRUE, VALUE IF FALSE

  =IFA1>B1,"YES","NO"

What is the difference between HTML and CSS

• HTML is the content and CSS is the styles

• HTML and CSS can do the same

• CSS is the content and HTML is the styles