Welcome to your free Advanced Excel test


1)

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



excel-adv-q1


2)

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?





excel-adv-q2


3)

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





excel-adv-q3


4)

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?




excel-adv-q4


5)

What's wrong with the function in B7 below?




excel-adv-q5


6)

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




excel-adv-q6


7)

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




excel-adv-q7


8)

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



excel-adv-q8


9)

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




excel-adv-q9


10)

Why does the SUM function in B7 show zero?



excel-adv-q10



Be sure to click the button below to check your answers!