Lesson 13
Continuation of Spreadsheet
Welcome
In this lesson, we will learn some of the more advanced features of a spreadsheet. Spreadsheet can be a very powerful tool for analyzing data and even algebraic expressions.
Lesson Goals
- To understand cell referencing (relative and absolute)
- To become comfortable using formulas inside a spreadsheet
- To understand the meaning of a regression
In Lesson 13 you will learn how to:
- Use cell referencing in a spreadsheet
- Create a percentage table
- Use Fill Sequence and Fill Range
- Fit a regression curve to data
Upon completion of this lesson you will be able to answer the following questions:
- If cell C2 contains =3xB2 and we copy C2 to B5, what will B5 contain?
- If cell C2 contains =3x$B$2 and we copy C2 to B5, what will B5 contain?
- What does Fill Sequence do?
- How do you insert a row?
- How do you insert a column?
- What does the button
do?
Time Required
About 60 minutes.