Answer all questions on your excel sheet and save your work with your student ID number Question 1 Pass' Fail Test The Financial Modeling test is a Pass/Fail test that requires participants to meet a minimum number of qualifications to pass. Scores of less than 70 percent fail, and those scores greater than that, pass Column A lists the participants' names, column B shows their scores, and column C displays whether they passed or failed the course. With the help of excel tools, determine the whether students passed or fail. Participant Grade PASS/FAIL Ama Karko 54 Osom Kofi 78 Jefter Olu 85 Yaa Mansah 93 Tetteh Kumah 71 Baaba Dosu Faith Vicson Maame Ajo Maame Dunyo 72 56 70.1 69 89 Question 2 Kwame took a loan in 2019 valued at Gh30,000, with an annual interest rate of 14% to be paid in 2 years with equal payment. After one year, he needed to pay his son Ole's admission fee worth Gh8,500, so he approached his tank for help At an interest rate of 15.50, he secured a loan top-up and extended his repayment period to 4 years. Draft a loan table for the scenario, showing a zero balance at the end of the last year 2 Question 3 DATE 1-Feb-18 2-Feb-18 3-Feb-18 4-Feb-18 5-Feb-18 6-Feb-18 7-Feb-18 8-Feb-18 9-Feb-18 10-Feb-18 11-Feb-18 12-Feb-18 13-Feb-18 14-Feb-18 15-Feb-18 16-Feb-18 17-Feb-18 18-Feb-18 19-Feb-18 20-Feb-18 STOCK PRICE 31.20 31.10 31.00 34.30 32.40 32.10 33.40 31.20 31.20 31.20 32.20 31.20 32.30 32.20 32.10 31.70 29.00 30.10 30.10 31.20 STOCK SOLD 200.00 150.00 311.00 111.00 152.00 158.00 96.00 156.00 158.00 152.00 150.00 152.00 124.00 120.00 124.00 125.00 581.00 321.00 256.00 168.00 RETURNS 1.20% -1.00% 2.10% 1.00% 2.10% 3.00% -1.20% 1.00% -0.10% 2.00% 1.20% 1.20% 2.10% 2.80% 2.60% 1.30% 2.80% 2.70% 2.60% 2.80% CRITERIA 1 + CRITERIA 1 Answers SET CRITERIA HERE FIND 1. Number of returns 2. Returns above 2% 3. Returns below Zero (0) 4. Sum sales above 2% 5. Sum sales below Zero (0) 3