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?

Which formula returns the value in cell A10 of the worksheet named Budget Variances?

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?

In Excel a ____ is an instruction in a spreadsheet to carry out a calculation