Spreadsheet+L+4

**Lesson Four: More Cell Attributes**

Enter the following data into a spreadsheet and then use a formula to find the total dollars earned by each car salesman for the year, and the total dollars earned in each month by all three salesmen. To do this you must first select the cell in which you want the answer to go, and then type the correct formula. You will have to set two different groups of cell attributes, both the __date__, and the __currency__ cell attributes. Don't forget tot total the sales in cell F-15, but don't add the two totals together! Please ensure that you have provided a yearly total for all three salesmen in cell F-15. Remember you only add up the values in column F **or** the totals in row 15, but not both, or you will have twice the correct answer.