Topics in this chapter

• Worksheet Basics and Data Entry
• Formulas, References, and Operators
• Functions and Logical Formulas
• Cell Formatting and Fill Tools
• Data Management and Analysis
• Charts and Data Visualisation
• What-If Analysis and Automation

Cheat sheet

Practice questions

1. Question 1Q-4F5338

   What is the default extension of a workbook saved in LibreOffice Calc?

   1. A..xlsx
   2. B..ods
   3. C..odt
   4. D..odp
   See the answer and solution
2. Question 2Q-729A77

   Which symbol must every formula begin with in LibreOffice Calc?

   1. A.

   2. B.@
   3. C.=
   4. D.$
   See the answer and solution
3. Question 3Q-7F8BDB

   Which of the following cell references is an example of an absolute cell reference?

   1. A.A1
   2. B.$A$1
   3. C.$A1
   4. D.A$1
   See the answer and solution
4. Question 4Q-BCB934

   What is the primary function of the Scenario tool in LibreOffice Calc?

   1. A.To merge multiple worksheets into a single summary sheet
   2. B.To save different sets of values in a worksheet and switch between them to test 'what-if' questions
   3. C.To lock specific cells against accidental modification
   4. D.To automatically format data based on specific cell values
   See the answer and solution
5. Question 5Q-7F9182

   Which feature in LibreOffice Calc allows a user to combine data from multiple worksheets or ranges into a single master summary range?

   1. A.Goal Seek
   2. B.Consolidate
   3. C.Subtotal
   4. D.Filter
   See the answer and solution