Calc Scenario and Subtotal Quiz

Which menu option provides access to the Scenario Manager?

• Tools > Scenario Manager

• Data > Scenarios

• Edit > Scenarios

• Insert > Scenario

Which tool automatically creates groups in Calc for subtotals?

• Consolidate

• Group and Outline

• Subtotal tool

• Format tool

Which key allows the selection of multiple cells in Calc?

• ALT

• SHIFT

• CTRL

• ESC

What is displayed in the Subtotal dialog under "Group by"?

• Rows to be hidden

• Columns for applying functions

• The column used for grouping data

• Available formatting styles

What is the purpose of the "Calculate subtotals for" checkbox?

• To lock cells

• To choose columns for applying subtotal functions

• To delete unused columns

• To apply conditional formatting

How does the "Link to source data" option affect consolidation?

• Prevents errors in formulas

• Maintains a dynamic connection with source sheets

• Enhances formatting options

• Locks the target sheet for editing

Which function calculates the average in Calc?

• =AVERAGE()

• =SUM()

• =COUNT()

• =TOTAL()

Which component shows hierarchical structure after applying Subtotals?

• Row header

• Group indicators (+/-)

• Data menu

• Filter options

What can be achieved using the Count function in Calc?

• Summing values

• Averaging values

• Counting rows in a range

• Sorting data

Which step is crucial before creating a scenario?

• Formatting the entire sheet

• Selecting the cells containing values

• Renaming the sheet

• Applying conditional formatting