CS 105 Spreadsheet Fundamentals

1
CS 105Spreadsheet Fundamentals
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?
Course Guide p. 137
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

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)
• Which of the following is NOT numerical data?
• a. 5344
• b. -34.5209
• c. 75
• d. 400.00
• e. 34.5-98.7

7
Conditional Formatting

• You can use
• Format/Conditional formatting with numbers

8
(No Transcript)
9
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

10
Learn to look at the formula bar!
11
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.

12
You can change that span

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

13
Formatting a two-digit date
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
18
To Summarize

• 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?

19
Which choice is NOT numerical data?
You need to tell Excel to subtract with an
sign. Otherwise, it thinks the dash is like the
ones in phone numbers!

• 5344
• -34.5209
• c. 75
• d. 400.00
• e. 34.5-98.7