What function call will create the following chessboard when ‘Q’ is the first character printed? There are 4 rows printed and each row contains 4 characters.  Q # # ## #  # #

What does this expression evaluate to: “hi” + “5”

Which of the following code snippets will produce this output: CS220    is “great” Please note that the spaces between “220” and “is” is equivalent to one tab.

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

If you have a formula in Excel as =MAXIFS(A2:C2, A3:C3, “>50”), what will the formula return if the values in row 2 are: A2 = 40, B2 = 60, C2 = 80 and the values in row 3 are: A3 = 45, B3 = 55, C3 = 30?

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?