Difference between revisions of "OpenOffice Spreadsheet"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
#*You will need to organize your rows and columns first. Take some time to think about the information you want to represent and go from there. Often, this is one of the most difficult steps. | #*You will need to organize your rows and columns first. Take some time to think about the information you want to represent and go from there. Often, this is one of the most difficult steps. | ||
#Name your rows and columns | #Name your rows and columns | ||
| − | #Format cells | + | #Format cells-Currency |
#*If you are entering monetary amounts, dates, or any other type of number, you can format the cell the automatically convert the numbers into the desired format. | #*If you are entering monetary amounts, dates, or any other type of number, you can format the cell the automatically convert the numbers into the desired format. | ||
| − | #**To do this: Highlight row/column of your choosing. Then: Click on the format menu at the top of the screen. Scroll down to "Cell." | + | #**To do this: Highlight row/column of your choosing. Then: Click on the format menu at the top of the screen. Scroll down to "Cell." Choose "Numbers." |
| − | #**Choose "currency" and then choose whichever currency format you want. | + | #**After choosing "Numbers" Choose "currency" and then choose whichever currency format you want. |
#Alignment | #Alignment | ||
#*Choose right, center, or left. Highlight column and then click on the alignment you choose at the top of the screen. | #*Choose right, center, or left. Highlight column and then click on the alignment you choose at the top of the screen. | ||
#Sum | #Sum | ||
#*You can add, subtract, multiply, divide, and do other crazier functions in your spreadsheet! | #*You can add, subtract, multiply, divide, and do other crazier functions in your spreadsheet! | ||
| − | + | #change cell height and width | |
| − | + | #Make cells automatically count | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 07:59, 2 May 2008
Introduction
- What is a spreadsheet?
- Who has used a spreadsheet before?
- What can you do with a spreadsheet?
Class Objectives
- Students will be able to:
- Create a spreadsheet
- Save as Excel
- Save on desktop and in home folder
- Create a sample budget performing mathematical functions
Detailed Instructions
- Getting Started
- You will need to organize your rows and columns first. Take some time to think about the information you want to represent and go from there. Often, this is one of the most difficult steps.
- Name your rows and columns
- Format cells-Currency
- If you are entering monetary amounts, dates, or any other type of number, you can format the cell the automatically convert the numbers into the desired format.
- To do this: Highlight row/column of your choosing. Then: Click on the format menu at the top of the screen. Scroll down to "Cell." Choose "Numbers."
- After choosing "Numbers" Choose "currency" and then choose whichever currency format you want.
- If you are entering monetary amounts, dates, or any other type of number, you can format the cell the automatically convert the numbers into the desired format.
- Alignment
- Choose right, center, or left. Highlight column and then click on the alignment you choose at the top of the screen.
- Sum
- You can add, subtract, multiply, divide, and do other crazier functions in your spreadsheet!
- change cell height and width
- Make cells automatically count