There are two ways to reference cells in other sheets :ġ) By entering the formula directly using the keyboard. This displays a submenu from which you should select the Rename option.Ĭell Reference : A cell reference refers to a cell or a range of cells on a worksheet that can be used in a formula to calculate values. Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu.Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.Double-click on one of the existing worksheet names.There are three ways you can rename a worksheet. Click in an empty space at the end of the line of sheet tabs.Įach method opens the Insert Sheet dialog box where you can choose to put the new sheet before or after the selected sheet and how many sheets to insert.Right-click on the tab and select Insert Sheet, or.Select Insert > Sheet from the menu bar, or.The first step, in all cases, is to select the sheet that will be next to the new sheet. There are several ways to insert a new sheet. When you open a new spreadsheet, by default, it has a sheet named Sheet1. Multiple sheets help to keep the information organized. In this manner, you can create formulas using a combination of local and linked information. Spreadsheet allows you to link the cells from various worksheets to summarize data from several sources. Session 2 : Link Data and Spreadsheets Using Multiple Workbooks and Linking Cells It is specifically designed to minimize or maximize the result according to a set of rules that you define. The difference is that the Solver deals with equations with multiple unknown variables. Solver option under Tools menu amounts to a more elaborate form of Goal Seek. So how much must the company earn in Q4 to reach its goal? Then Chief Financial Officer runs a goal seek on the empty cell for Q4 sales and receives the answer Solver : For the fourth quarter, however, no definite income is available. for exampleĬhief Financial Officer has a good idea of the company’s income in the first three quarters, because of the contracts that are already signed. By contrast Goal Seek option under Tools menu, helps to find values which will produce the result that you want. Usually, you run a formula to calculate a result based upon existing values. NOTE : You can create several scenarios for any given range of cells Goal Seek This name is displayed in the Navigator and on the title bar of the scenario.Ĥ) Optionally add some information to the Comment box.ĥ) Optionally select or deselect the options in the Settings section. Creating Scenarios :ġ) Select the cells that contain the values that will change between scenarios.ģ) On the Create Scenario dialog, enter a name for the new scenario. For example, if you wanted to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results. You can easily switch between different scenarios by using the Navigator. Each scenario is named, and can be edited and formatted separately. Scenarios are a tool to test “what-if” questions. Steps to insert subtotal values into a sheet:Ģ) In the Subtotals dialog, in the Group by box, select the column that you want to add the subtotals to.ģ) In the Calculate subtotals for box, select the columns that you want to subtotal.Ĥ) In the Use function box, select the function. Using the Subtotals dialog, you can select arrays, and then choose a statistical function to apply to them. SUBTOTAL, totals/adds data arranged in an array-that is, a group of cells with labels for columns and/or rows. NOTE : Use Data > Define Range to give name to a range Creating Subtotals : The text in the labels must be identical in all the specified Source range. The Sum function is the default setting.ħ) Select either Row labels or Column labels. The selected range now appears on the Consolidation ranges list.Ĥ) Select additional ranges and click Add after each selection.ĥ) Specify where you want to display the result by selecting a target range from the Copy results to box.Ħ) Select a function from the Function list. In other words, the Data Consolidation function takes data from a series of worksheets and summaries it into a single worksheet.ġ) Open the worksheet that contains the cell ranges to be consolidated.Ģ) Choose the Consolidate option under the Data menu.ģ) Select Source data range and click Add. SESSION 1: Analyze data using SCENARIOS AND GOAL SEEKĭata Consolidation allows you to gather together your data from separate worksheets into a master worksheet. SESSION 1: ANALYSE DATA USING SCENARIOS AND GOAL SEEK SESSION 2: LINK DATA AND SPREADSHEETS SESSION 3: SHARE AND REVIEW A SPREADSHEET SESSION 4: CREATE AND USE MACROS IN SPREADSHEET Spreadsheet Class 10 Notes UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |