Electronic Spreadsheet (Advanced) using LibreOffice Calc

Topics in this chapter

• Formulas and Cell References
• What-If Analysis Tools
• Data Consolidation and Subtotals
• Macros and Automation
• Collaborative Spreadsheet Sharing
• Worksheets and Hyperlinks

Cheat sheet

Practice questions

1. Question 1Q-E89185

   Which feature in LibreOffice Calc is used to combine data from multiple worksheets into a single summary worksheet?

   1. A.Goal Seek
   2. B.Consolidate
   3. C.Scenario Manager
   4. D.Solver
   See the answer and solution
2. Question 2Q-91FF32

   What is the primary purpose of using 'Subtotals' in LibreOffice Calc?

   1. A.To create graphical charts of data ranges
   2. B.To automatically group data and calculate summary functions like sum or average for specific categories
   3. C.To record a sequence of formatting steps into a macro
   4. D.To link data between two entirely different spreadsheet files
   See the answer and solution
3. Question 3Q-D8B0FB

   Which 'What-If' analysis tool in LibreOffice Calc is best suited when you want to find the optimal (maximum or minimum) value for a formula by changing multiple independent input cells subject to specific constraints?

   1. A.Goal Seek
   2. B.Scenario Manager
   3. C.Solver
   4. D.Subtotals
   See the answer and solution
4. Question 4Q-416081

   When you want to reference a cell from another worksheet named 'Sales2023' in the current worksheet, which syntax is correct in LibreOffice Calc?

   1. A.#Sales2023.A1
   2. B.Sales2023!A1
   3. C.Sales2023.A1
   4. D.$Sales2023(A1)
   See the answer and solution
5. Question 5Q-1ED897

   Which feature allows you to save different sets of input values (scenarios) within the same range of cells and easily switch between them to view outcomes?

   1. A.Consolidation
   2. B.Scenario Manager
   3. C.Data Pilot
   4. D.Hyperlink Manager
   See the answer and solution