CS 105 Spreadsheet Fundamentals

1
CS 105Spreadsheet Fundamentals
Pretest Questions
What is a range? How small can a range be?
How are dates handled? How many days have you
been alive? What is a string?
p. 123 in Course Guide
2
We Have No Excel Textbook

• You can use the links in the syllabus to find
  excellent online tutorials
• Learn to use Help. Its a great tool.
• Some helpful slides with tips are in your Course
  Guide as a supplement
• Go to your labs, ask questions in lecture, try
  things out!

3
Cell Ranges
G2 G8 Single Column Range
column letters
A1 Single cell
A3 E3
Single Row Range
Read as B6 to E13
Row numbers
4
Text Data (String)

• If the cell is not wide enough, the entry spills
  over into the next cell
• Text may be enhanced
• Example
• Macros, too

5
Numbers as strings

• Some numbers are entered as text (strings)
• zip codes
• phone numbers
• social security numbers
• Such numbers do not get involved in computation

6
Numerical Data

• Numerical data is any number (formatted or not)
• Numerical data can be used in calculation for
  other data
• Examples
• 5344
• -34.5209
• 75
• You can use
• Format/Conditional formatting with numbers.

7
(No Transcript)
8
Formulas

• A formula represents a mathematical calculation
• Always starts with
• A formula contains
• Numbers (e.g. 25.32, -56, 78)
• Cell addresses (e.g. A3 or G24)
• Mathematical operators (e.g. , , -, / )
• e.g. 100B5-D3

9
Learn to look at the formula bar!
10
Date Entries

• Dates are a special kind of number Try 01/01/22
• Two-digit year values 00 through 29 are
  interpreted as the years 2000 through 2029
• Year values 30 through 99 are interpreted as the
  years 1930 through 1999.

11
You can change that span

• Adjust the Windows OS
• Use the Control Panel/Regional Options

12
Formatting a two-digit date
13
More on date entries

• We can perform calculations on dates
• Depending on your computer, the dates start from
  1900 or 1904see Tools/Options/Calculations

14
Date calculations
Formula view
15
Today and Month functions

• TODAY()
• MONTH( March 7, 2006)
• MONTH(A1)

16
Undo

• The previous action can be undone by
• using the Undo Icon
• selecting Edit, Undo
• typing ctrl-z
• Using the Undo Icon allows you to undo several
  changes that you have made previously.

17
Save your work as a web page
Edit/Fill/Series