Practice Quiz-2(IT)

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

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

• Record changes

• solver

• subtotal

• none of the above

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

• Data Consolidation

• Goal Seek

• Solver

• Subtotal

To activate the record changes feature in shared worksheet ___________

• Select File > Changes > Record from the menu bar

• Select Edit > Changes > Record from the menu bar.

• Select View > Changes > Record from the menu bar