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 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").

Which of the following is not among the Logical functions category of excel?

If a plumber knows the rate he charges per hour, the cost of his tools and travel, the cost of purchasing items, and other subsidiaries, he can figure out how much he will make in a week via a formula.  If he were to choose to target a specific number and then work backwards to figure out how much he should charge for each hour, which Excel tool would he use to get the most direct and quickest result?conditional formattingtables with subtotalsgoal seekdatabase formulas

In the following truth table, V = 1if and only if the input is valid.What function does the truth table represent?

Which of the following is not among the Logical functions category of excel?  IFNA IFERROR AND DAVERAGE