Question

Mr. Amit, Sales Manager of ABC Sales Corporation, has created a spreadsheet in LibreOffice Calc that lists Sales for different years in different regions in different worksheets. He wants to summarise and make certain decisions based on it.

Help him by answering the following questions:

1. Which tool in Calc can be used to combine the sales data from multiple sheets into a single summary sheet?
2. Name the Menu Option and Sub-Menu Option that can be used to generate a combined summary of all the worksheets.
3. Name the function that can be used to display the total of all sales.
4. He wants to open a summary document stored at a different location from within the sheet by clicking on a text stored in a cell. How can it be done?

Answer 1

1. Through Calc’s “Consolidate” tool, you can combine sales data from several sheets into a single summary sheet. This makes it easier to look at the data and make decisions.
2. You can summarize all of Calc’s files using the Data menu and the Consolidate sub menu.
3. You can see the total sales by adding the numbers from different sheets and cells using the sum function.
4. He can use Insert → Hyperlink to make a hyperlink in a cell. If he clicks the linked text, it will take him to the summary document stored elsewhere.