Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?

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?

Which function repeats text a given number of times?

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?