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 Formulas
Section 5 - Entering a Formula

To enter a formula, click on the cell to hold the value/formula. Type the formula. In the image below, the formula is in cell C1.

Entering a Formula

To accept the value of the formula click the Green Check Mark in the formula bar (cursor remains in the cell) or press Return. Once the formula is entered and you have hit the return key, a value will appear in the selected cell. The value is the number resulting from the execution of the formula.

Accepting formula

NOTE: Instead of typing in the cell references, you can also click on the cells to enter cell references.

 

Module 5 Lesson 3 Section 4
Module 5 Lesson 3 Section 6

 

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