Test: Electronic Spreadsheet (Advanced) - 2 - Class 10 MCQ

A deleted column or row in shared worksheet is marked by a ________ colored bar.

In which option we have to specify the target range(Where we want the result to be displayed)

We can consolidate data by ________

Goal Seek Option available in ________menu.

Use _________ Macro to start the macro recorder.

When a document is created and saved, it automatically contains a library named _______

Hyperlink in Calc can be used

Define range option is available under ________ menu.

Which of the following buttons are present on “Resolve Conflict” dialog box which appear during saving shared worksheet.

After sharing a worksheet, ________ is seen in the title bar after the worksheet’s title.

_______ is more elaborate form of Goal Seek.

After sharing the worksheet, the word ________ is then shown on the title bar after the worksheet’s title

cenarios are tools to test _________ questions.

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

Which option is suitable to calculate the effect of different interest rates on an investment.

Subtotals is available in __________ menu.

Raman and his friends wants to work together in a spreadsheet. They can do so by