Free Excel Test

Client Success Stories

  • 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 »
  • 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 »
  • 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 »
  • Chevron Perth was required by its US head office to implement measures that would meet the Sarbanes-Oxley (SOX) Section 404 requirements.... Read more »
  • TFS needed an investment model to help them compete effectively against other agribusiness investment schemes.... 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 »
  • Chevron needed better reporting on its changing workforce and be able to present this information to management for decision-making. The information was stored in a variety of different systems and...... Read more »
  • The owners of Nubax required a flexible and user friendly financial model to present information to potential investors.... Read more »
  • Technip required 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 »
  • 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 »
  • 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 »
  • 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

  • "Imagination is everything. It is the preview of life's coming attractions." Albert Einstein
  • "A good decision is based on knowledge and not on numbers." Plato
  • "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
 

FREE Excel Test

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 closed (including the online help).

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?



 
File > Options > Add-ins > Excel – Add ins
File > Options > Customise Ribbon > New Tab (Name as Developer)
Right Click on the Ribbon > Customise the Ribbon > Main Tabs > Tick Developer Box
Right Click on Ribbon > Customise Quick Access Toolbar > Choose Commands from > Developer tab

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

How do you restore the fill handle?



 
Unprotect Sheet
Unprotect Workbook
File > Options > Formulas
File > Options > Advanced

Even though the word “Heading” appears to be highlighted it is not showing up in the formula bar, why not?



 
The formula bar has been formatted to show white text on a white background
The word has been typed in A1 and then the 3 blue cells have been formatted using Centre Across Selection
There is a glitch when using certain fonts
B1 is not actually highlighted, it’s just a border around the cell


Share This: