Unformatted text preview: To easily determine the arithmetic mean of range of cells, use the average function. 9. To find the smallest number in a range of cells, use the min function. 10. If you need to determine how many cells in a range are NOT blank, use the CountA function. 11. The Now function obtains its time and date from the computers clock. 12. The if function returns a result based on a condition. 13. The column index number is the number of columns in the lookup tale that contains the return values. 14. To find info in rows based on values in a table of data, you can use the Hlookup function. 15. The PMT function has 3 arguments number of periods 16. To find out how much money you would make on an investment of 1,000 dollars with a periodic interest rate of 5%, use the FV function. 17. Parameters in an IF function can be text...
View Full Document
- Fall '10
- mixed references QUIZ, mixed cell reference