This is the question asked:

USE DATA FILTERING AND APPROPRIATE SUBTOTAL FUNCTIONS TO
CALCULATE                       
THE FOLLOWING AMOUNTS.                       
NOTE: YOU MUST TYPE YOUR ANSWERS IN TO THE YELLOW HIGHLIGHTED AREAS
AFTER                       
YOU HAVE WRITTEN THE FORMULAE AND PERFORMED THE FILTER ELSEWHERE                       
IN THE SHEET. DO NOT ENTER FORMULAE TO THE YELLOW AREAS - ANSWERS
ONLY.                       
                       
THE AVERAGE PRICE OF ALL SHARES WITH A DIVIDEND OF MORE THAN
£0.20                       
THAT WERE NOT UK OWNED. ANSWER TO G8.                        1.95
ENTER THE TEXT VERSION OF THE FORMULA USED TO G9 (NO EQUALS OR $
SIGNS).                       
THE TOTAL DIVIDEND ON ALL SHARES WITH A PRICE OF LESS THAN £2.50                       
THAT WERE PURCHASED BEFORE 1994. ANSWER TO G11                        0.85
ENTER THE TEXT VERSION OF THE FORMULA USED TO G12 (NO EQUALS OR $
SIGNS)                       
                       
Share name    Price (£)    No. held    Dividend (£)    Purchase Year    UK owned = 1   
Agricola    0.65    1    0.12    1990    1   
Cathedral Life    2.43    1    0.34    1990    1   
Commercial Plus    1.67    1    0.21    1989    0   
MBI    0.99    1    0.18    1990    1