For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?

What does this formula do? =Sum(Sheet1:Sheet4!D18)

What is the term for an expression that is entered into a worksheet cell and begins with an equal sign?

How does the appearance of an array formula differ from that of a standard formula?

In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?

After typing data or a formula into a cell and hitting ENTER, the default action is:

Can Excel open two documents with the same file name simultaneously?

In a large data set with 121,005 rows, You are on the top row (row 1) of the data set. What is the fastest way to get to row 121,005?

Which worksheet function returns the individual term binomial distribution probability?

What will the formula =A1*C1 return?