OpenOffice Spreadsheet - Revision history

Laurel at 19:54, 14 June 2011

2011-06-14T19:54:45Z

2010-07-31T21:56:54Z

2010-07-06T22:47:13Z

categorized

2008-05-02T23:07:14Z

Converting text to numbers

2008-05-02T23:02:26Z

2008-05-02T14:59:06Z

Detailed Instructions

2008-05-02T14:52:11Z

Class Objectives

2008-04-26T21:54:52Z

2008-04-26T19:11:50Z

2008-03-20T22:11:39Z

← Older revision		Revision as of 19:54, 14 June 2011
Line 32:		Line 32:
	[[Image:Replacetextwithnumbers.png]]		[[Image:Replacetextwithnumbers.png]]

−	[[Category: ~~Current~~ Classes]]	+	[[Category: Classes]]

← Older revision		Revision as of 21:56, 31 July 2010
Line 32:		Line 32:
	[[Image:Replacetextwithnumbers.png]]		[[Image:Replacetextwithnumbers.png]]

−	[[Category: Classes]]	+	[[Category: Current Classes]]

← Older revision		Revision as of 22:47, 6 July 2010
Line 31:		Line 31:

	[[Image:Replacetextwithnumbers.png]]		[[Image:Replacetextwithnumbers.png]]
		+
		+	[[Category: Classes]]

← Older revision		Revision as of 23:07, 2 May 2008
Line 29:		Line 29:
	==Converting text to numbers==		==Converting text to numbers==
	If you paste a table into a spreadsheet, numbers will be inserted as text and will not sort or format correctly. These can be fixed with a "Find and Replace". Search for ".*" and replace with "&", making sure you have selected "Regular Expressions" under Options.		If you paste a table into a spreadsheet, numbers will be inserted as text and will not sort or format correctly. These can be fixed with a "Find and Replace". Search for ".*" and replace with "&", making sure you have selected "Regular Expressions" under Options.
		+
		+	[[Image:Replacetextwithnumbers.png]]

← Older revision		Revision as of 23:02, 2 May 2008
Line 25:		Line 25:
	#change cell height and width		#change cell height and width
	#Make cells automatically count		#Make cells automatically count
		+
		+
		+	==Converting text to numbers==
		+	If you paste a table into a spreadsheet, numbers will be inserted as text and will not sort or format correctly. These can be fixed with a "Find and Replace". Search for ".*" and replace with "&", making sure you have selected "Regular Expressions" under Options.

@@ 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.
 #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.
-#**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
 #*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
-some functions and how they are useful
+#Make cells automatically count

@@ Line 9: / Line 9: @@
 *Save as Excel
 *Save on desktop and in home folder
-*Perform mathematical functions
+*Create a sample budget performing mathematical functions
 ==Detailed Instructions==

← Older revision		Revision as of 21:54, 26 April 2008
Line 11:		Line 11:
	*Perform mathematical functions		*Perform 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
		+	#*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 "currency" and then choose whichever currency format you want.
		+	#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!

	some functions and how they are useful		some functions and how they are useful

@@ Line 1: / Line 1: @@
-oocalc
+==Introduction==
-Introduction - what is a spreadsheet
+==Class Objectives==
 some functions and how they are useful

@@ Line 7: / Line 7: @@
 some functions and how they are useful
 formatting
 saving a template