Free Excel Test

Client Success Stories

  • The owners of Nubax required a flexible and user friendly financial model to present information to potential investors.... Read more »
  • Chevron Perth was required by its US head office to implement measures that would meet the Sarbanes-Oxley (SOX) Section 404 requirements.... Read more »
  • Technip reqired a solution to secure detailed information on the inventory of parts that each of its suppliers can access to ensure project design specifications could be met for the Wheatstone...... Read more »
  • TFS needed an investment model to help them compete effectively against other agribusiness investment schemes.... Read more »
  • Terrex was rapidly expanding its business and the process of gathering time-keeping information from employee teams that were geographically dispersed, processing this, then uploading everything...... Read more »
  • Staff in Leighton’s Perth Office needed a tool that would enable them to keep track of personnel capabilities and availabilities to enable them to design rosters to meet the requirements of the...... Read more »
  • A consultant worked with the business to design a range of strategic initiatives that would help the business trade out of difficulty and communicate this effectively to the bank. ... Read more »
  • Acuity Coaching, a highly-regarded firm of business coaches, required a model that would allow their clients to conduct “what-if” analyses on a range of variables in their businesses to...... Read more »
  • As the result of a strategic review, the company wanted to implement a new accounting system, and redevelop its management reporting and budgeting systems.... Read more »
  • The Council wanted to change the parking charges on its various car parks plus construct some new ones. As such, they needed to model a range of different scenarios to test which would result in an...... Read more »
  • One of their international mining projects required a feasibility study financial model to use for raising debt funding from the company’s financiers.... Read more »

Famous Quotes

  • "Business is going to change more in the next ten years than it has in the last fifty." Bill Gates
  • "Some people see things as they are, and say 'Why?' I dream of things that never were, and say 'Why not?'" George Bernard Shaw
  • "I pray for opportunities, wisdom, courage and resources." The Entrepreneur's Prayer
 
 

Test your Excel Knowledge - FREE!

Test Your Excel Knowledge

... Then Brag to your Friends on Facebook!


Exams Available:

- Advanced Excel
- Excel 2007


How well do you know Excel and Financial Modelling?

Take one of our free online exams and find out!  There are 10 challenging questions in each test.  For your own benefit, try to complete the exam with Excel (and its online help) closed.

Even if you don't know the answers, have a guess anyway ... we'll tell you all the answers anyway, and you might learn something!

At the end, you'll also get a beautiful certificate you can print!

Post your score on Facebook so all your friends know how great you are!  Challenge them to see if they can beat you!

Looking for more in-depth training?  Visit our other training resources.

Now ... bring on the questions!  (but watch out ... they're not as easy as they look)!

 

Advanced Excel Online Exam:


Questions

Each green cell contains exactly the same formula (ie =CellAbove ). How come each one displays a different result?



 
This is what the CellAbove function does.
CellAbove is a relative range reference.
CellAbove is an external indirect function.
This is only possible in Excel 95 and below. Newer versions do not support this functionality.

The following formula should show "Fair", "Good" or "Excellent" depending on the value of A1 but there is an error in the logic. What value produces an incorrect result?



 
A value of 0 will display
A value of 500 will display
A value of 1500 will display
A value of -500 will display

The range name "EmployeeLookupTbl" has been correctly defined to refer to the shaded area. What needs to be fixed in B5 and B6 so the functions show Pierre Francois' information rather than Graeme Smith's.



 
The table should be sorted by employee ID so the values are in numerical order.
The VLOOKUP function should include FALSE as the 4th argument e.g. =VLOOKUP(B4,EmployeeLookupTbl,2,FALSE) in B5.
Either of the above will fix the problem.
The employee ID column of numbers should be formatted in yellow.

I have a spreadsheet with many rows and columns of data as shown below. Yet when I print the entire sheet, only the highlighted range is printed. Why?



 
There is probably a problem with my printer driver.
I may have incorrect page margins.
A1:E8 has been set as the print area for this sheet.
Because I\'ve selected this area, that is the only part that will print.

What's wrong with the function in B7 below?



 
The function itself is correct but it will be confusing later on because unless you look into function, it looks like the function uses the numbers in the cells above it ... but it doesn't.
Everything is fine - this is a trick question.
The function gives an incorrect result because it defaults to interest charged in advance.
The 100,000 should also be multiplied by 12.

What does the word "Calculate" indicate when displayed in the status bar?



 
Calculation is set to manual and something in the spreadsheet has changed.
The calculation option has been set to Automatic Except Tables.
The active cell needs to be re-calculated.
A calculation on the current sheet is incorrect.

Cell B10 is being edited. B8 contains the formula =SUBTOTAL(9,B4:B7). What number will appear in B10 once the user presses Enter?



 
0 because this will result in a circular reference.
2000
8000
6000

Why doesn't the SUM formula in E10 show an answer of $30,000?



 
The database has been filtered so there must be hidden rows containing other income figures.
The correct formula for this situation is SUMPRODUCT rather than SUM.
Conditional formatting has been applied to rows 3, 4, and 6 so that these rows are excluded from the SUM calculations.
Incorrect data validation has been used.

Why could the formulas in C3 and C4 cause #VALUE! errors?



 
B3 is an empty cell.
B3 contains one or more space characters.
The formulas have used brackets incorrectly.
None of the above

Why does the SUM function in B7 show zero?



 
Manual calculation is turned on and the cell has not been re-calculated.
Someone has keyed the number 0 into B7.
The function contains a circular reference.
The function is still being edited so hasn't calculated a result yet.


Share This: