MIST Excel Checks questions and answers 2023

MIST Excel Checks questions and answers 2023 What is the average hammer price of "Birkin" shape handbags in the dataset? (rounded to nearest dollar) $60,289 How many bags in the dataset were sold at Christies auctions? 768 What is the total cost of all crocodile bags in the dataset? (to the nearest million dollars) $59 million What is the average price of red Birkin bags with gold hardware? (do not include Brushed Gold) $47,926.34 What is the total price of all Kelly bags sold by Sotheby's? $485,192.12 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? $62,731.00 Consider the following VLOOKUP. What should you use as your lookup value? (assume that you plan to complete the entire column) H3 Consider the following VLOOKUP. What should you use as your table array? (assume that you plan to complete the entire column) $A$3:$B$4 Consider the following VLOOKUP. What should you use as your col_index_num? (assume that you plan to complete the entire column) 2 Consider the following XLOOKUP. What should you use as your lookup array? (assume that you plan to complete the entire column) $A$3:$A$4 Consider the following XLOOKUP. What should you use as your return array? (assume that you plan to complete the entire column) $B$3:$B$4 What is the future value of $1250 (today) after 5 years at 6% APR compounded annually? Round to the nearest dollar. $1,673 What is the present value of a single payment of $245 at the end of the third year? The interest rate (APR) is 4%, compounded yearly. Round to the nearest dollar. $218 What is the future value of $1250 (today) after 5 years at 6% APR compounded monthly? Round to the nearest dollar. $1,686 What is the future value of $245 in six years? The interest rate (APR) is 4%, compounded monthly. Round to the nearest dollar. $311 What is the present value of $300 monthly payments paid over three years at an APR of 6% compounded monthly? Round to the nearest dollar. $9,861