it has to be answered with microsoft execel

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 Osom Kofi Jefter Olu Yaa Mansah Tetteh Kumah Baaba Dosu Faith Vicson Maame Ajo Maame Dunyo 54 78 85 93 71 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 bank for help. At an interest rate of 15.50, he secured a loan top-up and extended his repayment period to 4 years Dratt 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)