Access Analytic - Financial Modelling, Management Reporting, Business Analysis
<IMG SRC="/images/bw_images1.gif" WIDTH=312 HEIGHT=62 usemap="#bw_images1" BORDER=0>
we excel
home services success stories contact information about us
 

Services

> Services Home
> Financial Modelling
> Management Reporting
> Spreadsheet Auditing
> Training
> Spreadsheet Professional
> How to Engage us
> Accounting Systems Selection
> White Papers
> Success Stories
> Preventing Spreadsheet Problems
> Newsletter
> Free Excel Test
> Links

"We are what and where we are because we have first imagined it."

-- Donald Curtis




 

Test your Excel Knowledge - FREE!

You Might Win a Prize!

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 take a look at our training site.  We provide you with unlimited access to over 525 online training courses!

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-2008 ACN 091 625 697
Access Analytic® is a registered trademark of Access Analytic Solutions Pty Ltd

Excel® is a registered trademark of Microsoft

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