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
 MCCARTHY
 mixed references QUIZ, mixed cell reference

Click to edit the document details