MIST EXCEL CHECKS 2025
ANSWER ALL QUESTIONS IN THIS SECTION
QUESTION 1
What is the total price of all Kelly bags sold by Sotheby's? - ANSWERS-
$485,192.12
QUESTION 2
Create a column that categorizes bags <26 cm as "small", 26-34 cm as "med", and
>34 cm as "large". What is the average price of medium bags? - ANSWERS-
$62,731.00
QUESTION 3
Consider the following VLOOKUP. What should you use as your lookup value?
(assume that you plan to complete the entire column) - ANSWERS-H3
QUESTION 4
Consider the following VLOOKUP. What should you use as your table array?
(assume that you plan to complete the entire column) - ANSWERS-$A$3:$B$4
END OF
PAGE 1
ANSWER ALL QUESTIONS IN THIS SECTION
QUESTION 1
What is the total price of all Kelly bags sold by Sotheby's? - ANSWERS-
$485,192.12
QUESTION 2
Create a column that categorizes bags <26 cm as "small", 26-34 cm as "med", and
>34 cm as "large". What is the average price of medium bags? - ANSWERS-
$62,731.00
QUESTION 3
Consider the following VLOOKUP. What should you use as your lookup value?
(assume that you plan to complete the entire column) - ANSWERS-H3
QUESTION 4
Consider the following VLOOKUP. What should you use as your table array?
(assume that you plan to complete the entire column) - ANSWERS-$A$3:$B$4
END OF
PAGE 1
