Procedures

Spreadsheet Production Procedures

Table of Contents:

How to Turn In Exercises

Spreadsheet Procedures

Moving the Active Cell using the Keyboard (Word)

Elements of Spreadsheet (Word)

Creating a Chart (Windows Media file)

Tutorials:

Functions:

PMT

How to Turn In Exercises

Save and name your exercise file as directed in the textbook except leave the exercise number on the filename. For example, instead of OVERDUE, save as 05OVERDUE.
Print your exercise. (Always check Print Preview before printing. Try to save on the paper used.)
Compare your printout to the Solution Key in the Blue Book.
Circle or note any errors that you find on your assignment.
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.
Open your exercise file and correct the errors. Save.
Email the file as an attachment to dkamarainen@sccd.ctc.edu
1. 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.

Procedures from the Learning Office XP Textbook

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

Spreadsheet Procedures
Procedure	Keywords	Page No.
Create a chart with chart wizard	Chart
Select embedded chart	Chart
Select chart sheet	Chart
Change charts type	Chart
Resize embedded chart	Chart
Move chart	Chart
Switch from them been charged to chart sheet	Chart
Copy charge	Chart
Delete embedded chart	Chart
Delete chart sheet	Chart
Select chart object	Chart
Resize chart object	Chart
Move chart object	Chart
Delete chart object	Chart
Change chart text	Chart
Enhance chart background	Chart
Format category axis	Chart
Format value axis	Chart
Create comment	Comment
Display comment	Comment
Edit comment	Comment
Delete comment	Comment
Copy data	Copy
Paste data	Copy
Paste formula results	Copy
Copy formula using AutoFill	Copy
Paste data	Copy
Move selection with drag-and-drop editing	Copy
Copy selection with drag-and-drop editing	Copy
Paste special using paste special Dialog box	Copy
Paste special using paste menu	Copy
Copying formats with format painter	Copy
Transpose data	Copy
Combine data with paste special	Copy
Use Drag-and-Drop editing between workbooks	Copy
Cut data	Copy
Delete Cell Contents	Delete
Delete columns/rows with many of	Delete
Delete sheets	Delete
Freeze and unfreeze labels	Display
Split worksheets into panes with menu	Display
Split worksheet into panes with split boxes	Display
Remove split	Display
Adjust panes	Display
Move between panes	Display
Freeze and unfreeze panes in split window	Display
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
Enable Cell Editing	Edit
Replace Cell Contents in Typeover Mode	Edit
AutoComplete	Entry
Pick from List	Entry
Enter Numeric Label	Entry
Enter Value	Entry
Range entry using collapse button	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
Change font using font box	Format
Change font size using font size box	Format
Percent number format	Format
Comma number format	Format
Currency number format	Format
Accounting number format	Format
Decimal places, increase or decrease	Format
Add a color fill	Format
Add text color	Format
Use AutoFormat	Format
Enter Formula Using Mathematical Operators	Formula
Accept labels in formulas	Formula
Create natural language formula	Formula
Create 3-D formula	Formula
3-D references in formulas and ranges of worksheets	Formula
Display or Hide Formula Bar	Formula
Enter a function manually	Function
Insert a function	Function
Enter a common function	Function
Edit a function	Function
Enter a function into a formula	Function
Use AutoCalculate	Function
Enter IF function	Function
Enter SUMIF function	Function
Enter COUNTIF function	Function
Hide columns or rows	Hide
Unhide columns or rows	Hide
Insert columns/rows with menu	Insert
Insert columns/rows with mouse	Insert
insert data between cells	Insert
Insert list of named ranges in worksheet	Insert
Enter Labels	Labels
Link workbooks using Paste Link	Link
Print worksheet	Print
Print preview	Print
Set print area for named range	Print
Print named range	Print
Print entire workbook	Print
Print multiple copies	Print
Page break preview	Print
Normal view	Print
Set manual page breaks	Print
Set print area with file menu	Print
Clear print area with file menu	Print
Scroll using Mouse	Scroll
Select range of adjacent cells	Select
Select an entire column	Select
Select adjacent rows	Select
Select worksheet from top-left cell to bottom-right cell	Select
Select non contiguous cells and ranges	Select
Select entire row	Select
Select one sheet	Select
Select all sheets	Select
Select consecutive sheets	Select
Select non consecutive sheets	Select
Name range with menu	Select
Name range with name box	Select
Modify named range	Select
Select cells in a named range	Select
Select adjacent data, charts	Select
Select nonadjacent data, charts	Select
Create a Series Using Mouse	Series
Create an Incremental Series Using Mouse	Series
Access page setup	Setup
Create header or footer	Setup
Repeat row and column labels	Setup
Print gridlines	Setup
Select sheet tab options	Setup
Ungroup sheets	Sheets
Rename sheet	Sheets
Insert sheets	Sheets
Move sheets within workbooks	Sheets
Copy sheet	Sheets
Change tab color	Sheets
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
Create a New Workbook from a Template	Workbook
Create a New, Blank Workbook	Workbook
Save Workbook	Workbook
Close Workbook	Workbook
Exit Excel and Save Files	Workbook
Recover a Workbook	Workbook
Arrange Open Workbooks	Workbook
Change to Different Open Workbook	Workbook
Open Recent Workbook	Workbook
Open Workbook	Workbook
Open duplicate workbook window	Workbook
Change to a Different Worksheet	Worksheet
Set Zoom Percentage	Zoom
Set Zoom Percentage with Zoom Button	Zoom

Spreadsheet Screen Elements

Introduction to Spreadsheets

PowerPoint presentation of the first steps in using an Excel spreadsheet.