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 3 - Index
Exercise 1

This exercise is designed to test your knowledge functions and their uses.

Formulas are used to perform calculations; they always begin with a plus (+) sign.

 
The order of precedence for operators is parentheses, exponents, multiplication, division, addition, subtraction.
 
After you type in a formula you can enter the formula by clicking the enter box, pressing return or pressing tab.
 
One way to display a formula in a cell is by holding down the Ctrl and Grave accent mark.
 
By default all cell references are absolute.
 
Absolute addresses change during copying.
 
The Insert Function button can be used to access functions.
 
AutoSum allows you to automatically create a formula that adds a range using the sum function.

 
Module 5 Lesson 3 Summary
Module 5 Lesson 4 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