This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 11/16/2010 for the course CIS 105 taught by Professor Mccarthy during the Fall '10 term at University of Arizona Tucson.
 Fall '10
 MCCARTHY

Click to edit the document details