Hi, I need help with solving the below 2 questions

Problem 3: Movies Recreate the model below that searches the Top IMDB Rated Movies table and returns the attributes of the Rank holding movie. The model works by having the user enter the rank # and Excel returns the details stored in the database table. The solution should be a single 'master' formula that would work for any attribute i.e., the formula that returns the Rating in the searcher is appropriate for being AutoFilled down the column. Download database file Top10.csv and import into your workbook. Hint: The solution should use the rank number input as the lookup value for VLOOKUP and the result vector number should be generated using the MATCH of the identical field names in the appropriately

Enter Rank# to Search: Rating Title Year Genre Director

Problem 4: Estimates A company purchases Olive oil according to this price schedule: For the first 1000 Litres, $7.20 per Litre For any of the next 4000 Litres $6.30 per Litre For any oil beyond 5,000 Litres, $5.50 per Litre The purchase estimate spreadsheet calculates the total price of buying x Litres of oil, where x is a number entered into a cell (Order_Qty) on the worksheet. The example below shows the result of several Order_Qty values (C3:E3) and corresponding schedule results (C4:E6) and the Total_Price (C7:E7). 1. Recreate the model using the price schedule above. 2. Construct IF formulas to handle the three-tier pricing structure for any Order_Qty entered. 3. Maximize use of named ranges