The Questions
An inbuilt formula is called a function status bar range name value
(The following 3 questions assume cell B2=9, B3=5 and B4=7)
What is the value of =sum(b2:b4) 21 10.5 16 none of the above
What is the value of =average(b2,b4) 8 10 16 none of the above
What is the value of =int(average(b2:b4)) 7 10 21 none of the above
=IF functions are an example of a logical database statistical financial
In correct order what are the arguments in an =IF function ? none of the above condition, false result, true result true result, false result, condition condition 1, condition 2, condition 3
Select the function which displays the word "Correct" when A1 is greater than 10 or less than 5 =IF(Or(A1<10,A1>5),"Correct","Incorrect") =IF(A1>10,IF(A1<5,"Correct","Incorrect"), "Incorrect") =IF(A1>10 and A1>5,"Correct","Incorrect") =And(A1=10,A1=5)
In correct order what arguments are used in a Lookup function ? lookup_value,table range, offset offset,selector, lookup_value lookup_value, table range, selector offset, lookup_value, table range
When the lookup value in the function does not match the one next lowest in the lookup_value range next highest in the offset range next lowest in the offset range next lowest in the table range
To total the values of cells B2 on worksheets named, Week1, Week2 and Week3, the formula is =Sum(Week1!B2,Week2!B2, Week3!B2) =Sumall(B2) =Total(Week(x)B2) Excel cant add cells on different sheets
The Rand() function returns a value in the range 0 -.9999 1 - 10 1 - 100 -10 to 10
The function =int(Rand()*7+1) returns a value in the range 1 to 7 0 to 8 0 to 7 1 to 8

Rules of Engagement:
To win you need to Destroy the Enemy Army
The Army consists of one Military Base (3 cells), one Missile Launcher (2 cells) and two Soldiers (1 cell).
Only Correct Answers win you a shot.
Fire a shot by clicking on the map below.
Aim carefully, there are more cells than questions!
Good Hunting !