The document outlines practical exercises in data consolidation, subtotals, scenarios, and goal seeking using OpenOffice Calc. It provides step-by-step instructions for each practical, including how to consolidate sales data, calculate subtotals for different accounts, create scenarios for what-if analysis, and use goal seek to determine input values based on output targets. Each section includes specific actions to perform within the software to achieve the desired results.
The document outlines practical exercises in data consolidation, subtotals, scenarios, and goal seeking using OpenOffice Calc. It provides step-by-step instructions for each practical, including how to consolidate sales data, calculate subtotals for different accounts, create scenarios for what-if analysis, and use goal seek to determine input values based on output targets. Each section includes specific actions to perform within the software to achieve the desired results.
The document outlines practical exercises in data consolidation, subtotals, scenarios, and goal seeking using OpenOffice Calc. It provides step-by-step instructions for each practical, including how to consolidate sales data, calculate subtotals for different accounts, create scenarios for what-if analysis, and use goal seek to determine input values based on output targets. Each section includes specific actions to perform within the software to achieve the desired results.
The document outlines practical exercises in data consolidation, subtotals, scenarios, and goal seeking using OpenOffice Calc. It provides step-by-step instructions for each practical, including how to consolidate sales data, calculate subtotals for different accounts, create scenarios for what-if analysis, and use goal seek to determine input values based on output targets. Each section includes specific actions to perform within the software to achieve the desired results.
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 10
PRACTICAL FILE
-RIDHIMA SHARMA - X-C - 32 PRACTICAL 1 – CONSOLIDATION There are four sheets with same structure – quarterly results of sales of a stationery shop. A total yearly sales sheet has been made. The steps are: - 1. Go to Data in menu bar → Click on Consolidate.
2.
The Consolidate dialog box appears. Here, we can select the
function we need to apply (Here, SUM).
Then we have to specify the ranges for consolidation. To do so,
choose the range while the Source data range text box in focus, then click on Add.
4. Choose the desired cell for the results to copy in Copy results to text box. → Click on OK
We will the final output as shown in the screenshot below
PRACTICAL 3 – SUBTOTALS In this table, different accounts are recorded and other important fields (Amount, Time, Category etc.) are present. Here,
Here, we use Subtotal to find the total amount in different branches
or number of branches. To perform subtotals, the steps are: - 1. Select the range of cells as shown below.
2. Go to Data menu → choose subtotals.
3. Choose AcctType in Group by drop box menu → Calculate
subtotals for Amount → Use function Sum The output turns out as the following- PRACTICAL 7 – SCENARIOS Scenarios in OpenOffice Calc comes under what-if analysis tools, where we are able to get different values for output by changing the input cells. Here, we have a table with cost price, selling price and profit percentage.
Now we will perform scenarios, the steps are: -
1. Select the range of cells that are input and will be changed, here, Cost Price and Selling Price. → Go to Tools → Scenarios.
Give the scenario desired name, check Prevent changes and
uncheck Copy back. → Click on OK. Repeat step 2 to add more scenarios and we can see the output changing. PRACTICAL 9 – GOAL SEEKThis option is used to find the value of input cells by giving the value of the output cell.
In the other cases, the discount %age is given and we
have to find the Selling Price. We can use Goal Seek in the following ways: - 1. Go to Tools → Goal Seek.
2. Set the formula cell as Discount %age cell, target as specified,
