Exam 3: Cell References, named Ranges, and Functions

The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.

Excel's ________ returns the current date and time.

Excel's DAY function returns the day of the month.

There are how many different cell references?

A named range is a group of cells that have been given a name,which you can use when writing a formula or function.

You are likely to see the #NAME? error message if you typed =SIM(B4:D8)instead of =SUM(B4:D8).

A(n)________ is a named calculation which Excel uses to calculate the output based on the provided input.

Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?

You create a named range by using the ________.

Excel's RANDBETWEEN function returns a random number from 0 to less than 1.

When cell C3 containing the formula =B4*C6 is copied to cell D1,the formula in cell D1 is ________.

The result of =ROUNDDOWN(98.765,0)is 98.

The inputs used by an Excel function are called ________.

Which of the following is NOT a unit value option for the DATEDIF?

Excel's WEEKDAY function returns a number in the range 1-7 or ________.

The TODAY and NOW functions return the same result.

If you wanted to find which value occurs most often in a cell range,you would use the ________ function.

The result of =CONCATENATE("12","34")is ________.

Excel's AVERAGE function returns the mean of a set of numbers.

The comparison operator for less than or equal to is ________.