Self-Check 3.1
1. Multiple Choice. Read and analyze carefully each item. Choose the letter with the best answer to
the following statement.
1. it is the other quick wat to enter a function. This button inserts the SUM () function.
a. AutoSum
c. mixed reference
b. relative reference
d absolute reference
2. it is a mixture of an absolute and a relative reference. It can be absolute in column and relative in
row, or relative in column an absolute in row
a. AutoSum
C mixed reference
b. relative reference
d. absolute reference
3. It refers to a cell's position relative to the cell that contains the formula.
a. AutoSum
c. mixed reference
b. relative reference
d. absolute reference
4. it always refers to the same cell even when you move or copy the formula to another cell or range
a. AutoSum
c. mixed reference
b. relative reference
d. absolute reference
5. this function is probably the most common function in Excel. It adds a range of numbers.
a. database function
c.insert function
b. sum function
d. date and time function
6. these functions are for identifying which values in an excel database or list match certain criteria.
a database function
c.insert function
b. sum function
d. date and time function
7. these functions are widely useful in worksheets for a variety of operations.
a. database function
c.insert function
b. sum function
d. date and time function
8. these function is located by the Formula Bar. By clicking this button, the Insert Function dialog
window will be activated.
a. database function
c.insert function
b. sum function
d. date and time function
9. these function is used for returning about the contents and formatting of the current cell or range.
a. financial function
c. informational function
b. sum function
d. edit function
10. these functions is for common calculations, and the Analysis ToolPak adds about three dozen
extra financial functions for more arcane calculations.
a financial function
c. informational function
b. sum function
d. edit function​