Open Office Calc

1 _________ allows you to gather data from different worksheets into a master worksheet.

• Data Consolidation

• Goal Seek

• Solver

• Subtotal

Which of the following functions are available in consolidate window?

• Max

• Min

• Count

• All of the above

Subtotals is available in __________ menu.

• Data

• Tools

• Format

• Insert

In Subtotals we can select up to _______ groups of arrays.

• 1

• 2

• 3

• 4

Scenarios are tool to test _________ analysis questions.

• if else

• what else

• what if

• none of these

By default ________________ sheets are present in Spreadsheet

• 1

• 2

• 3

• 4

. Formula to refer a cell A3 in sheet named S1 is

• S1.A3

• S1A3

• A3

• 'S1.A3

Hyperlink option is available in ______ menu.

• DATA

• TOOLS

• FORMAT

• INSERT

Hyperlink in Calc can be used to

• to jump from one sheet to another sheet.

• to jump from one sheet to website

• to link to an email or news

• all of the above

Which feature of Calc help to see the changes made in the shared worksheet

• Record changes

• solver

• subtotal

• none of the above