Embedded Files
Spreadsheet also allows us to link the cells from various worksheets and from various spreadsheets to summarize data from several sources. In this manner, we can create formulas that span different sources and make calculations using a combination of local and linked information. Multiple sheets help keep information organized and is an easier representation of data from several sources. In today's class we will understand the procedure of setting up multiple sheets to hold data from different sources.
Spreadsheet also allows us to link the cells from various worksheets and from various spreadsheets to summarize data from several sources. In this manner, we can create formulas that span different sources and make calculations using a combination of local and linked information. Multiple sheets help keep information organized and is an easier representation of data from several sources. In today's class we will understand the procedure of setting up multiple sheets to hold data from different sources.
Setting up multiple sheets
Setting up multiple sheets
Identifying sheets
Identifying sheets
When you open a new spreadsheet, by default, it has a sheet named Sheet1 which is managed using tabs at the bottom of the spreadsheet, as shown below.
When you open a new spreadsheet, by default, it has a sheet named Sheet1 which is managed using tabs at the bottom of the spreadsheet, as shown below.
There are three ways you can rename a worksheet, and the only difference between them is the way in which you start the renaming process. You can do any of the following:
Double-click on one of the existing worksheet names.
Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Please watch this video to understand the procedure of identifying sheets, inserting new sheets and renaming sheets in OpenOffice Calc.
Please watch this video to understand the procedure of identifying sheets, inserting new sheets and renaming sheets in OpenOffice Calc.
Answer the following questions:
Answer the following questions:
- Which Menu command will be used to access the 'Insert sheet' option?
- Although there are several ways to insert a new sheet, what is the first step in all cases?
- List any 2 methods of renaming a sheet in Open Office Calc.
Create or change a cell reference
Create or change a cell reference
A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
In one or several formulas, you can use a cell reference to refer to:
In one or several formulas, you can use a cell reference to refer to:
- Data from one or more continuous cells on the worksheet.
- Data contained in different areas of a worksheet.
- Data on other worksheets in the same workbook.
Creating reference to other sheets
Creating reference to other sheets
You can refer to cells that are on other worksheets in the same workbook by prepending the name of the worksheet followed by an exclamation point (!) to the start of the cell reference. In the following example, the worksheet function named AVERAGE calculates the average value for the range B1:B10 on the worksheet named Marketing in the same workbook.
You can refer to cells that are on other worksheets in the same workbook by prepending the name of the worksheet followed by an exclamation point (!) to the start of the cell reference. In the following example, the worksheet function named AVERAGE calculates the average value for the range B1:B10 on the worksheet named Marketing in the same workbook.
There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. Let's watch this video to understand both the ways of referencing cells from other sheets.
There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. Let's watch this video to understand both the ways of referencing cells from other sheets.
Note:
Note:
The sheet will be in single quotes because it contains a space, and the mandatory period (.) always falls outside any quotes.
Now let's answer the following questions in the classwork notebook.
Now let's answer the following questions in the classwork notebook.
- What are the two ways of referencing cells in the other sheet?
- How a cell reference is constructed using a keyboard? Explain with an example.
Now we know that data from one sheet can be used in the other sheet for any type of calculations. We don't have to indulge in the hassle of cut, copy or paste. Neither do we have to worry about the integrity of the data. Do you know that we can even hyperlink data of sheet 1 in sheet 2? Sound complicated? Let's explore it in the next class.
Now we know that data from one sheet can be used in the other sheet for any type of calculations. We don't have to indulge in the hassle of cut, copy or paste. Neither do we have to worry about the integrity of the data. Do you know that we can even hyperlink data of sheet 1 in sheet 2? Sound complicated? Let's explore it in the next class.
Page updated
Report abuse