In this example, students with a score of 90 or above will receive a High Pass result. Otherwise, if their score is 70 or above, they will receive a Pass result. Below that, they’ll receive a Fail unless there is no grade at all, in which case they’ll receive an Incomplete. Which of these formulas in D3 would produce those results?

Given the following values in cells along with this formula, which value will the formula return? =IF(AND(A1=”YEL”, C3=”GRE”), IF(OR(B2 = “YEL”, AND(C3=”GRE”, A1=”YEL”)), “SAPPHIRE”, “RUBY”), “DIAMOND”)

If you have a formula in cell H6 that reads =A$10/2 and you copy this formula to cell H7, what will the formula in H7 be?

If you wanted to calculate the average of the values in a horizontal range from D5 to H5, what formula would you use?

What happens when you group selected items in a Row Label field?

Using structured references, if you had a table named Expenses with columns Category and Amount, how would you reference the entire Amount column in a formula outside the table?

How would you modify the expression 6 + 2 * 4 + 10 to get a result of 72 in Excel?

If you have a formula in Excel as =OR(A1=100, B110), what will the formula return if the value in A1 is 100, B1 is 60, and C1 is 5?

If you have a formula in Excel as =AND(A1=5, B1>0, C1

Using structured references, if you had a table named Orders with columns Date and Total, how would you reference the entire Total column in a formula outside the table?