Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 2 - Index
Exercise 1

This exercise is designed to test your knowledge of the different way to select data in Excel.

A cell is an intersection between a row and a column.

 
Columns are labeled automatically 1 - 65,536 and rows are labeled automatically A - IV.
 
When a cell is active the cell border will darken.
 
You can add data to the cell by typing directly in the cell or in the formula bar.
 
AutoFill allows you to automatically delete cells.
 
The Fill Handle can be used to fill consecutive cells or adjacent cells.
 
Inserting a row shifts existing rows up and inserting a column shifts columns to the left.
 
To delete a row or a column highlight the row or column and select Delete from the Edit menu.
 
To select an entire sheet click on the upper left hand corner of the worksheet.
 
To highlight an entire row click on the row number and to highlight an entire column click on the column letter.
 
Cut and copy can be performed on single cells or a range of cells.

 

Module 5 Lesson 2 Summary
Module 5 Lesson 3 Index

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 07/18/2005
© 2003, St. Edward's University