Access Analytic: financial modelling, management reporting and training to help companies make decisions with confidence
<IMG SRC="/images/bw_images1.gif" WIDTH=312 HEIGHT=62 usemap="#bw_images1" BORDER=0>
decisions with confidence
financial modelling, management reporting and Excel auditing services in-house and public training courses knowledge, research and whitepapers contact us about us
 

Services

> Services Home
> Financial Modelling
> Management Reporting
> Spreadsheet Auditing
> Training Courses
> Excel Mentoring
> What is Financial Modelling?
> Spreadsheet Professional
> How to Engage us
> White Papers
> Success Stories
> Newsletter
> Free Excel Test
> Links

"Some people see things as they are, and say 'Why?' I dream of things that never were, and say 'Why not?'"

-- George Bernard Shaw




 

Test your Excel Knowledge - FREE!

You Might Win Some Free Consulting Time!

How well do you know Excel? 

Take our free online test and find out!  There are 10 challenging questions in our test (5 per page).  For your own benefit, try to complete the test 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 at the end, and you might learn something!

If you're looking for more in-depth, professional training, visit our training resource.

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

Questions

Q1: 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.

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



 Note: the formula in C3 has been copied to C4:C6
 
B3 is an empty cell.
B3 contains one or more space characters.
The formulas have used brackets incorrectly.
None of the above

Q3: 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.

Q4: 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

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



 
The spreadsheet needs re-calculating.
Automatic re-calculation has been turned off.
The active cell needs to be re-calculated.
A calculation on the current sheet is incorrect.

 Privacy Policy | IP Policy
top


Copyright © Access Analytic Solutions Pty Ltd 2002-2009 ACN 091 625 697
Access Analytic® is a registered trademark of Access Analytic Solutions Pty Ltd
Ground Floor, Unit 110/131 Adelaide Tce, East Perth WA 6004, Australia. Phone +61 8 6210 8500

Excel® is a registered trademark of Microsoft Corporation

Javascript must be enabled to use this site as all e-mail addresses have been encrypted
to protect against spam-bots. Details