Exam 3: Cell References, named Ranges, and Functions

Excel's ________ function returns the smallest number from a set of numbers.

When cell C3 containing the formula =$C4-B$4 is copied to cell D8,the formula in cell D8 is ________.

The ________ logical function will return one of two values depending upon whether the logical test being evaluated is true or false.

A(n)________ function determines if a statement is either true or false.

Which of the following functions returns the number in the middle of a set of numbers?

The result of =ROUND(123.456,2)is ________.

Instead of typing the $ symbol in a cell reference,you can use the ________ keyboard shortcut.

A named range can begin with the / symbol.

The YEAR function returns the year in the range ________.

What is the error message when you attempt to divide a number by zero?

Given the following information: The result of =AND( A4<B4,C6>B2,B1=B5)is ________.

If you incorrectly name a range,you can rename it by selecting the data and naming the range again.

When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

The logical comparison operator for greater than or equal to is ≥.

Absolute cell referencing uses the # symbol.

Given the following information: What is the result of =IF( B4>65,"Passing","Failing")?

Which of the following is NOT a Lookup or Reference function?

Excel's ________ function rounds a number down to the nearest integer.

The result of =LEN("54")is 9.