Lesson 29 ā Activity 1: Parts of a Spreadsheet
Completion requirements
Lesson 29 ā Activity 1:
Parts of a Spreadsheet
Lesson 29 ā Activity 1:
Parts of a Spreadsheet
In the lessons that follow, you will be learning about spreadsheets. A spreadsheet is a handy tool for keeping track of numbers in various forms.
Spreadsheets are used in various business functions on a daily, weekly, monthly, or even yearly bases. You might also use spreadsheets at home or at school. As you work through this lesson, you will become more familiar with the parts and functions of various spreadsheets.
In the lessons that follow, you will be learning about spreadsheets. A spreadsheet is a handy tool for keeping track of numbers in various forms.
Spreadsheets are used in various business functions on a daily, weekly, monthly, or even yearly bases. You might also use spreadsheets at home or at school. As you work through this lesson, you will become more familiar with the parts and functions of various spreadsheets.
Spreadsheets are used in various business functions on a daily, weekly, monthly, or even yearly bases. You might also use spreadsheets at home or at school. As you work through this lesson, you will become more familiar with the parts and functions of various spreadsheets.
In this first activity, you will look at what a spreadsheet is. Many of the lessons in this theme used tables to organize information. Computer spreadsheets are a special kind of table. Not only do they organize information, but they are also a handy tool for doing calculations with this information. With a computer, it is easy to make changes in spreadsheets. There is no need to redo the entire table.
Parts of a Spreadsheet
Look at the image below to learn about the different parts of a spreadsheet.
Viewing Your Spreadsheet
You can view your spreadsheet two different ways ā regular view and formula view.
Regular View
When you are in regular view in a spreadsheet, you can see everything that you typed in and how it will appear when you print it off.
Formula View
When you are in formula view in a spreadsheet, you can see the actual formulas that you entered into the spreadsheet that will do your calculations.
Questions
Use the spreadsheet below to answer the following questions. When you are finished, click on the tab below to check your answers.
- For cell D1, which is the column and which is the row?
- Give the column and the row for the active cell.
- Give an example of a value.
- Give an example of a label.
- What does the formula = SUM(C2:C4) mean?
-
Write a formula to subtract the value in cell E2 from the value in cell E4.
1. āDā is the column (it goes down the page) and ā1ā is the row (it goes across the page).
2. āAā is the column and ā2ā is the row for the active cell.
3. Any number is acceptable. $459.09 is one example.
4. Any cell entry that starts with a letter will be treated as a label and will not be included in calculations by the spreadsheet. One example would be Income.
5. The formula means you add the values of cells C2, C3, and C4 together (finding the sum).
6. The formula would be: =SUM(E4-E2) *Note: It must be written in that order.
Self-check!
Click on the Play button below to watch a video on how to create a basic spreadsheet in Microsoft Excel.