Knowledge Excel Level 3 (Advanced)
1
2
3
4
1
2
3
4
True
False
A report
An advanced filter
A filter
Vlookup
True
False
The result will return an exact match
The result will return the nearest match
It will return a negative
None of the above
True
False
Figures which switch between varying amounts
A conditional format
A macro
An IF statement
True
False
True
False
Wait!
Here's an interesting quiz for you.