Spreadsheets - =COUNT(X#:Y#) a. Looks at all the cells and...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Spreadsheets Know how to write the built in functions 1. Sum can be written as =SUM(X#:Y#) 2. Average can be written as =AVERAGE(X#:Y#) 3. Max can be written as =MAX(X#:Y#) a. Finds the largest number in the range of cells 4. Min can be written as =MIN(X#:Y#) a. Finds the smallest number in the range of cells 5. Count can be written as
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: =COUNT(X#:Y#) a. Looks at all the cells and counts how many have a number in it 6. CountA can be written as a. Looks at all the cells and counts how many have something in it 7. CountIf 8. If Absolute Reference Sorting Primary vs. Secondarys Increasing vs. Decreasing Print area prints the selected area...
View Full Document

This note was uploaded on 04/03/2008 for the course COMP APPS 170 taught by Professor Gayatreeganu during the Spring '08 term at Rutgers.

Ask a homework question - tutors are online