ICT Exam: Suggested formula for calculating TOUR

These are the formula that is needed to be learn by 22th May 2013 for a pass in AS ICT (Part 2)

HideShow resource information

1. No. of climbs

  • =COUNTIF(I7:7,"Yes")
  • =COUNTIF(I7:N7,"Yes")
  • =IF(I7:N7,"Yes")
  • =COUNTIF(I7:N7,"Yes","No")
  • =IF(I1:N7,"Yes")
  • =COUNTIF(I7:N117,"Yes")
  • =COUNTIF(I7;N7,"Yes")
1 of 6

Other questions in this quiz

2. 1 sprint

  • =IF(COUNTIF(I12:N12,"Sprint")=1,"Yes","No")
  • =IF(COUNTIF(I12:N12,"Sprint")"Yes","No")
  • =IF(COUNT(I117:N12,"Sprint")=1,"Yes","No")
  • =IF(COUNTIF(I12:N12,"Sprint End")=1,"Yes","No")
  • =IF(COUNTIF(I12:N12,"Sprint")=1,"No")
  • =IF(I12:N12,"Sprint")=1,"Yes","No")
  • =COUNTIF(I12:N12,'Sprint')=1,'Yes','No')

3. 2 climbs

  • =IF(COUNTIF(I12:N12,"Climb")=2,"No")
  • =IF(COUNTIF(I12:N12,"Climb")=2,"Yes","No")
  • =IF(COUNTIF(N12,"Climb")=2,"Yes","No")
  • =COUNTIF(I12:N12,"Climb")=2,"Yes","No")
  • =IF(COUNTIF(I7:N12,"Climb")=2,"Yes","No")
  • =IF(COUNT(I12:N12,"Climb")
  • =IF(I2:N12,"Climb")=2,"Yes","No")

4. No. of Sprints

  • =IF(I9:N9,"Yes")
  • =COUNTIF(I9+N9,"Yes")
  • =COUNT(I9:N9,"No")
  • =COUNTIF(I7:N12,"Yes")
  • =COUNTIF(I9:N9,"Yes","No")
  • =COUNTIF(I9:N9,"Yes")
  • =COUNTIF(I9;N9,"Yes")

5. All towns visited

  • =IF(I7=0,"Yes","No")
  • =IF(I15=0,"Yes","No")
  • =COUNTIF(I15=0,"Yes","No")
  • =IF(I15+0,"Yes","No")
  • =COUNTIF(I15=0,"Yes","No")
  • =COUNTIF(I15=0,"Yes","No")
  • =IF(I15=0,"No")

Comments

Tohkadots

c00l

Similar ICT resources:

See all ICT resources »See all Data and Information resources »