LibreOffice Calc Quiz

What key can be pressed to execute the Module from the IDE?

• F3

• F4

• F5

• F6

What is the default name of the Macro?

• Default

• Main

• Macro1

• Main_Macro

Which tool is used to create an outline for the selected data?

• Goal Seek

• Scenario

• Consolidate

• Track Changes

What is the purpose of the Goal Seek tool?

• To find input for specific output

• To consolidate data

• To track changes

• To create scenarios

What feature is used to review changes made by team members in a spreadsheet?

• Track Changes

• Goal Seek

• Consolidate

• Scenario

What is the first step to create a scenario in LibreOffice Calc?

• Select the cells which contain values

• Click on Tools > Scenarios

• Enter a name for the new scenario

• Click on OK button

What should you do to accept or reject changes in a spreadsheet?

• Click on Edit > Track Changes > Manage

• Use the Goal Seek tool

• Click on Data > Group and Outline

• Use the Macro recorder

Which option allows you to consolidate data by rows and columns?

• Link to source data

• Consolidate by Row labels

• Consolidate by Column labels

• Both B and C

What is the purpose of the fill handle in LibreOffice Calc?

• To drag the function for other cells

• To create a new sheet

• To save the document

• To track changes

What feature is used to record all keyboard and mouse actions in Calc?

• Record Macro

• Track Changes

• Scenario Manager

• Goal Seek