The Questions
1. An inbuilt formula is called a
(The following 3 questions assume cell B2=9, B3=5 and B4=7)
2. What is the value of =sum(b2:b4)
3. What is the value of =average(b2,b4)
4. What is the value of =int(average(b2:b4))
5. =IF functions are an example of a
function.
6. In correct order what are the arguments in an =IF function?
7. Select the function which displays the word "Correct" when A1 is greater than 10 or less than 5
8. In correct order what arguments are used in a Lookup function ?
9. When the lookup value in the function does not match the one
in the table, which value is used ?
10. To total the values of cells B2 on worksheets named, Week1, Week2 and Week3, the formula is
11. The Rand() function returns a value in the range
12. The function =int(Rand()*7+1) returns a value in the range
|
Rules of Engagement
To win you need to destroy the enemy Army
Only Correct Answers win you a shot.
Fire a shot by clicking on the map below.
There are more cells than questions, Soldier, so aim carefully !
The Army consists of one Military Base (4 cells), one Missile Launcher (2 cells) and
one Tank (1 cell each).
Good luck!
x |
x |
T |
x |
x |
x |
x |
M |
B |
B |
x |
M |
B |
B |
x |
x |
|