To discover how many cells in a range contain values that meet a single criterion, use the _ function.

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?

The Solver in MS Excel is used for what?

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?