Chapter 2. Analyse Data using Scenarios and Goal Seek

Chapter 2. Analyse Data using Scenarios and Goal Seek.

Introduction Analysing data is the process to extract useful information for making effective decisions. The spreadsheet is one of the best software used for data analysis. It is used to retrieve, correlate, explore and visualise data to identify patterns, trends and relationships. The spreadsheet component in LibreOffice known as Calc includes several tools used to manipulate the data in the spreadsheet. You can analyse the data and interpret the results from it. In this chapter, you will learn to analyse data using LibreOffice Calc. Consolidating Data Consolidate is a function used to combine information from multiple sheets of the spreadsheet into one place to summarize the information. It is used to view and compare variety of data in a single spreadsheet for identifying trends and relationships. You need to check the following before consolidating data. Open each sheet in the spreadsheet and check that the data types must match which you want to consolidate. Match the labels from all the sheets which are used for consolidating. Enter the first column as the primary column on the basis of which the data is to be consolidated. Steps to consolidate the data are as follows: Step 1. Open the spreadsheet which has the data to be consolidated. Step 2. Create a new sheet where the data has to be consolidated. Step 3. Choose Data > Consolidate option that will open Consolidate dialog as shown in Fig. 4.1..

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

Domestic Data Entry Operator – Class X. 88. Let us take an example that we have two branches of our shop namely ABC and XYZ. We have the Sales records for the month of January and February of both the branches in two different sheets named ABC_Branch and XYZ_Branch. Now we have to consolidate these two sheets to get the sum of both the sheets monthly to get the insight about the sale as per product and branch. Now let us create the following sheets in a spreadsheet sales..

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

90. The consolidated sheet will have all the consolidated data along with the original data. You can view the original data of both the sheets and by clicking on the ‘+’ sign in front of the consolidated row. Fig. 4.10 shows the original data and consolidated data..

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

Domestic Data Entry Operator – Class X. 92. To solve this, perform the following steps:.

93. Observe that outline to the left of the row numbers which is inserted after performing the subtotal tool. This outline shows the hierarchical structure which can be used to show or hide different levels by clicking on the group indicators ‘+’ sign to expand and ‘–’ sign to collapse the data. You can hide the low-level details and just look at the final totals and grand totals. If you want to remove the outline feature from the sheet at any point of time then it is possible by just clicking on Data > Group and Outline > Remove Outline..

Domestic Data Entry Operator – Class X. 94. For example, a person who is taking car loan has to decide on certain factors as given below: The number of years for which the car loan is taken. The total amount of car loan The above two factors, i.e. Principal amount and.

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

96. 12.5 to 15 lakhs >15 lakhs. 25% 30%. Fig. 4.21: Income tax sheet.

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

Domestic Data Entry Operator – Class X. 98. Step 5..

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

Domestic Data Entry Operator – Class X. 100. Step 2..

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

Domestic Data Entry Operator – Class X. 102. Which tool is used to predict the output while changing the input? Consolidate function What-if scenario Goal seek Fine and Replace 5. Which of the following is an example for absolute cell referencing? (a) C5 (b) $C$5 (c) $C (d) #C analysis tool works in reverse order, finding input based on the output. Consolidate function Goal seek What-if analysis Scenario.

Electronic Spreadsheet (Advanced) using LibreOffice Calc.

you FOR EVERY CONVERSATION, EVERY PAUSE, AND EVERY MINUTE OF YOUR TIME. YOU'VE MADE MY WORLD A LITTLE BRIGHTER..