Procedures

Spreadsheet Procedures

Table of Contents:

Tutorials

Excel Features

Elements of Spreadsheet (Word)

Moving the Active Cell using the Keyboard (Word)

How to turn in Exercises

Formulas

Tutorials:

Functions:

PMT

Excel Features:

Listed below are some commonly-used procedures found in your textbook.

Procedure	Keywords	Page No.
Change Active Cell Using Go To	Edit
Change Active Cell Using Keyboard	Edit
Change Active Cell Using Mouse	Edit
Change Active Cell Using Name Box	Edit
Correct Data while Typing	Edit
Delete Cell Contents	Edit
Enable Cell Editing	Edit
Replace Cell Contents in Typeover Mode	Edit
AutoComplete	Entry
Enter Numeric Label	Entry
Enter Value	Entry
Pick from List	Entry
Exit Excel	Exit
Align Entry Using Formatting Toolbar	Format
Align Labels Using Format Cells Dialog Box	Format
Change Column Width Using Menu	Format
Change Column Width Using Mouse	Format
Merge and Center Entry Using Formatting Toolbar	Format
Set Column Width to Fit Longest Entry	Format
Set Standard Column Width	Format
Enter Formula Using Mathematical Operators	Formula
Display or Hide Formula Bar	Formula Bar
Enter Labels	Labels
Scroll using Mouse	Scroll
Create a Series Using Mouse	Series
Create an Incremental Series Using Mouse	Series
Start Excel	Start
Display or Hide Status Bar	Status Bar
Display or Hide Task Pane	Task Pane
Display or Hide Toolbar	Toolbar
Redo Last Reversed Action	Undo
Undo Last Action	Undo
Undo Multiple Actions	Undo
Customize View of Standard and Formatting Toolbars	View
Arrange Open Workbooks	Workbook
Change to Different Open Workbook	Workbook
Close Workbook	Workbook
Create a New Workbook from a Template	Workbook
Create a New, Blank Workbook	Workbook
Exit Excel and Save Files	Workbook
Open Recent Workbook	Workbook
Open Workbook	Workbook
Recover a Workbook	Workbook
Save Workbook	Workbook
Change to a Different Worksheet	Worksheet
Set Zoom Percentage	Zoom
Set Zoom Percentage with Zoom Button	Zoom

How to Turn In Exercises

Save and name your exercise file as directed in the textbook. For example, instead of EE1_0102, save as EE1_P1drill.

Compare your exercise to the Solution Key in the Blue Book.

On scratch paper, note any errors that you find on your assignment.

Do not hold onto the Blue Book; someone else might need it.

Determine what you did wrong. (Don't just change it to the correct answer.) This step is very important. You need to know how to arrive at the correct solution -- the concept may appear on a test.

Correct your errors. (Make sure you know why you are making the changes.)

Save.

Email the file as an attachment to dkamarainen@sccd.ctc.edu

On the Subject box, enter "Assignment:" and then add the filename(s) of the assignments that you are sending."

Optionally, you should save your printout (indicating the errors) as to review for the Final Test.

Formulas

Mathematical Operators in Formulas

Operator	Example	Comments
+ (addition)	=B7+B11	Adds the values in B7 and B11.
- (subtraction)	=B7-B11	Subtracts the value in B11 from B7.
* (multiplication)	=B7*B11	Multiplies the values in B7 and B11.
/ (division)	=B7/B11	Divides the value in B7 by the value in B11.
^ (exponentiation)	=B7^3	Raises the value in B7 to the third power (B7B7B7).
% (percent)	=B7*10%	Multiplies the value in B7 by 10% (.10).
( ) (calculations)	=B7/(C4-C2)	Parentheses change the order of calculations -- parentheses are calculated first. In this example, C2 would be subtracted from C4, and then B7 would be divided by the result.

Microsoft Excel
Tips and Tutorials using spreadsheets.
See tutorial on Goal Seek

http://www.mistupid.com/viewlets/excel/xlgoalseek.htm