IF Bob got an average score of 54 which is stored in the third row of the sixth column in a spreadsheet, What would be the outcome of the following function? "=if(F3>54,"Passed","Try again").

What is the purpose of the IF function in Excel?a.To perform logical tests and return one value if the condition is true and another value if it's falseb.To count the number of cells in a rangec.To calculate the average of a range of cellsd.To add up the values in a range of cells

_____ Excel function returns TRUE or FALSE based on two or more conditionsGroup of answer choices=CONCAT=AVERAGEIFS=COUNTA=AND

Sophie is working on payroll and has data on the weekly hours for each employee. She wishes to create a new column in her table to classify each employee as F for “Full time” if they worked 40 or more hours, or P for “Part-time” if they worked less than 40 hours. What function would she write for the first cell (E3) of the column?1 point=IF(D3=40,"F","P")=IF(D3<40,"F","P")=IF(D3>=40,"F","P")=IF(D3>40,P,F)

If cell range A1:A3 contains the numbers 5, 6 and 7, then =AVERAGE(A1:A3, 10)  will return __________*1 point671.818

12 Fill the Status column if the student score less than 30 then Fail if the score is between 31 to 50 Pass If the score is between 51 to 60 Third_Class, 61 to 70 Second_Class, and above 70 First_class.write excel formula grade present in e5 cell