â—» $1,750
Question 3 (1 point)
In the "L2V1 - Boolean Comparisons and IF Statements - Start" Excel file, we used formula with multiple nested "If" statements to assign grades for various student marks. A new function in Excel "Ifs" can be used instead. What formula would you enter in cell D23 to determine the appropriate grade for Mike. We will want to copy this formula down to find the grades for the other students as well - so relative vs. absolute referencing is important. Select all that apply.
= IFS(B23<$G$24,$H$23,B23<$G$25,$H$24,B23<$G$26,$H$25,B23<$G$27,$H$26,1.
= IFS(B$23<$G$24,$H$23,B$23<$G$25,$H$24,B$23<$G$26,$H$25,B$23<$G$27,$H$26
= IFS(B23<$G$24,$H$23,B23<$G$25,$H$24,B23<$G$26,$H$25,B23<$G$27,$H$26,B23
Question 4 (1 point)