Chapter Review

I. IDENTIFICATION: Identify the following: Write your answer on the space provided below.

• __________________1. It is a data entry capable of performing mathematical and logical operations automatically.

• __________________2. It is a moving broken-dashed line that goes around the cell you click, its cell reference will be entered into the active cell and in the formula bar as shown in the illustration.

• __________________3. Formulas always begin with this sign followed by a cell address, operators, and numbers needed.

• __________________4. It identifies a cell or range on a worksheet and tells MS Excel where to look for the values or data you want to use in a formula.

• __________________5. It allows you to quickly add a range of cells together.

• __________________6. It means that when a formula is copied, the cell reference remains constant.

• __________________7. It means that when a formula is copied, the cell address in the formula changes to its new location.

• __________________8. It displays the arguments that the function needs.

• __________________9. This function gets the average of the values in range.

• __________________10. It indicates the lowest value in a range.

• __________________11. The number between the middle of a set of numbers.

• __________________12. It indicates the highest value in a range

• __________________13. It requires three integer arguments (that is, Year, Month, and Day).

• __________________14. It helps make decisions regarding borrowing and lending money.

• __________________15. It allows you to compute the periodic payment amount for a loan on a car, house, or any other item.