Exam 9: Cell References, Named Ranges, and Functions

When constructing a formula,Excel's default reference type is relative cell referencing.

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

________ is the interest charged on both the principal and the interest that accumulates on a loan.

All arguments in a function are enclosed in a pair of ________.

The result of ==ABS(6*-2)is ________.

When cell D3 containing the formula =C4*B4 is copied to cell F2,the formula in cell F2 is =C4*B4.

The result of =LEFT("Dallas,Texas",9)is ________.

To find the greatest numerical value in a range of cells,you would use the ________ function.

The result of =MID("Tallahassee",6,3)is ________.

=$B$2 - C5 is an example of mixed cell referencing.

Given a student's numerical average and a table that lists the grades and percent needed to obtain the grades in column format,which Excel function would be used to determine the student's letter grade?

When cell B3 containing the formula =$B4-C$5 is copied to cell D6,the formula in cell D6 is =$B7-E$5.

To modify a named range,you select its name in the Name Box,then click Name Manager in the ________ tab.

$C$8 is an example of a(n)________ cell reference.

Excel's ________ function returns only the current date.

Functions can be created by using the Function Arguments dialog box or by typing the function in the cell.

Excel's Text function category provides data about cell content within a worksheet.

If more than one number occurs multiple times in a range of data,the ________ function can be used to return a vertical array,or list,of the most frequently occurring values in a range of data.

Excel's WEEKDAY function returns a number from 1-7 or 0-6.