Free Excel Test

Client Success Stories

  • 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 »
  • 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 »
  • The owners of Nubax required a flexible and user friendly financial model to present information to potential investors.... 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 »
  • Chevron Perth was required by its US head office to implement measures that would meet the Sarbanes-Oxley (SOX) Section 404 requirements.... 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 »
  • TFS needed an investment model to help them compete effectively against other agribusiness investment schemes.... 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 »
  • 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 »
  • 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 »

Famous Quotes

  • "Don't dwell on what went wrong. Instead, focus on what to do next. Spend your energies on moving forward toward finding the answer." Denis Waitley
  • "Do not let what you cannot do interfere with what you can do." John Wooden
  • "I find that the harder I work, the luckier I seem to get." Thomas Jefferson
 
 

Test your Excel Knowledge - FREE!

Test Your Excel Knowledge

... Then Brag to your Friends on Facebook!


Exams Available:

- Excel 2007/2010/2013
- Advanced Excel


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)!

 

Excel 2007/2010/2013 Online Exam:


Questions

I have an Excel 2003 file that uses the range names Qtr1, Qtr2 and Qtr3. Why does my file produce incorrect results in Excel 2007+?



 
Excel 2007+ range names must refer to months or years, not quarters
In Excel 2007+, QTR1, QTR2 and QTR3 are cell references
Excel 2007+ does not allow a mixture of alpha and numeric characters in range names
Excel 2007+ automatically assigns these range names when it recognises quarterly data

What formula would you enter in B16 to show the total for just the person selected on only the date entered?



 
=SUMIFS(Sales,Name,B15,SaleDate,B14)
=SUMIFS(Sales,SaleDate,B14,Name,B15)
=SUMPRODUCT((SaleDate=B14)*(Name=B15)*Sales)
All of the above will produce the correct answer

The Developer Ribbon is hidden by default. Where would you go to make it visible?



 
2007: Office button > Excel Options > Advanced. 2010+: File Menu > Excel Options > Advanced
2007: Office button > Excel Options > Popular. 2010+: Right-click any Ribbon
2007: Office button > Excel Options > Trust Centre. 2010+: File Menu > Excel Options > Advanced
2007: Office button > Excel Options > Formulas. 2010+: Right-click any Ribbon

What has happened to Excel?



 
It's operating in Page Layout view
It's operating in Word compatibility mode
It's operating in Page Break Preview mode
It\'s showing the sheet in Print Preview mode

Why is there such a big gap between the Ribbon and Excel cells?



 
A long formula has been entered, causing the Formula Bar to automatically re-size itself
Excel has crashed
Excel is operating in 2003 compatibility mode
The Formula Bar has been re-sized to make it taller

(i) Why do these dots show in the Name Box and (ii) what can you do about it?



 
(i) they indicate a dynamic range name (ii) change the range name to static
(i) they indicate a worksheet range name scope, rather than Workbook scope (ii) change all names to Workbook scope
(i) they indicate a range name that is based on a table (ii) change the range name to use cell references instead
(i) they indicate the range name is too long to be displayed (ii) drag the edge of the Name Box to make it wider

The headings for columns A, B and C have been changed. How has this been done?



 
Using the R1C1 reference style
Using an Excel table. This is what happens when you scroll down the page.
Using Find and Replace advanced settings
By applying Excel\'s new Conditional Formatting rules

The range A2:C12 has consistent cell background and font formatting across all cells. Why do some cells appear different?



 
A conditional formatting rule has been applied using the formula =COUNTA($A2:$C2)=COLUMNS($A2:$C2)
A dynamic range name has been used
Volatile VBA Macro formatting is being used
These cells are formatted using a user-defined VBA function

When you change the color scheme in Excel 2007+, what will be affected?



 
All Excel ribbons will automatically change to the new color scheme
All sheets will be formatted to the new default background color
All cells, drawing objects, smart art, and charts that use the scheme colors
All programs in the Microsoft Office suite

What do these little green icons on the Excel Recent Documents list menu mean?



 
Always show the document at that location on the Recent Documents list
Always show the document on the Recent Documents list
Always show the Recent Documents list
Increase the number of documents shown in the Recent Documents list by one


Share This: