Introduction To Computer Science 62
One of the strips below the menu bar is the formula bar. It tells you which cell you are working
on and gives you space to enter your formula. The picture below shows the cell A2 being
selected. The formula bar indicates that A2 is the cell the data will go into. The formula being
entered into that cell is “1+1”. The result of that formula, 2, will be shown in that cell. Hit enter
or click at the check mark if the formula is correct. Click the X to clear the formula you have just
entered if you want to re-enter the formula.
Figure 2- Spreadsheet Screenshot ( taken from
http://www.mech.
utah.edu/~rusmeeha/references/SpreadSheetBasic.pdf
)
You can enter text, a number, or a formula in any cell. Think of them as placeholders for your
data. Text and numbers can be typed in directly but formulae must start with an “=” sign. You
enter a formula in the same way you enter a formula in a “normal” calculator (not HP). To enter
a more advanced mathematical function, go to the
Insert menu and select
Function … Select
the desired function, e.g.,
SIN(), SQRT(), PI() , etc. The function you selected will be pasted
into the formula bar.
You can use any combination of numbers and cell references in a formula. As in the picture
below, to take a square root of the result of the formula in cell A2, enter the formula and
indicate the cell where the spreadsheet should get the number from by clicking that cell or by
typing in the cell name directly in the “( )” part of the formula.
A formula can be copied and pasted using the usual
Copy and Paste commands so that you
can perform a similar operation on some other number without having to retype the formula.
The spreadsheet is smart enough to index the cell reference for you. For example, if you
select and copy cell
