MCQs of Electronic Spreadsheet (Advanced) Set 1

Use ..................... Macro to start the macro recorder.

We can create only 3 scenarios for a given range of cells.

When you open a new spreadsheet, by default it has sheet named ........................ .

Click ....................... to stop the macro recorder.

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

SUBTOTALS ...................... data arranged in a group of cells.

Scenario option is available in ............................. menu.

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

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

Edited worksheet can be compared with the original worksheet by selecting.

We can consolidate data by ...................................... .

Define range option is available under ...................................... menu.

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

Hyperlink icon is present on ...................... .

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

We can shift from one scenario to another by ............................ .

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

The text in the row label or column label must be identical, otherwise, new row or column will be inserted.

We can give different colours to different scenarios?

Goal Seek Option available in .......................... menu.

Scenarios are tools to test ...................................... questions.

A ......................... link will stop working only if the start and target locations change relative to each other.

Consolidate option is available under ...................................... menu.

Worksheets can be merged from ........................... menu.

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

Seema is the author of shared worksheet so she has the right to accept or reject changes made by the reviewers.

Macros are especially useful to ........................ a task.

Share document option is available in .......................... menu.

In which option do we have to specify the target range?

Function names in Calc are not case sensitive.

A ..................... coloured border, appears around a cell where changes were made in shared worksheet.

Which option is used to name a range of cells?

..................... is more elaborate form of Goal Seek.

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

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