Spreadsheet Advanced Quiz 3

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

• Consolidate

• Subtotal

• Scenario

• None of the above

Default name of first scenario created in Sheet1 of Calc is _________

• Sheet_1_Scenario_1

• Sheet_1_Scenario1

• Sheet1_Scenario_1

• Sheet1_Scenario1

To select random multiple cell hold down ____ key as you click on each cell.

• All of the above

• Ctrl

• Shift

• Alt

Goal Seek Option available in ________ menu.

• Tools

• Format

• Data

• Insert

Comment in Create Scenario dialog box is Optional(T/F)

• False

• True

• None

We can give different colors to different scenario?(T/F)

• False

• True

• None

__________ is more elaborate form of Goal Seek.

• Scenario

• Solver

• All of the above

• Subtotal

Solver option is available under _______ menu.

• Edit

• Insert

• Tools

• Format

We can link one worksheet to another worksheet.(T/F)

• True

• False

• None

We can not add/insert more sheets in a spreadsheet.(T/F)

• None

• True

• False