Electronic Spreadsheet-Class10-CBSE

Name the shortcut key to create a hyperlink.

• Ctrl+M

• Ctrl+K

• Ctrl+N

• Ctrl+L

During ____________ the contents of the cells from several sheets can be combined.

• Solver

• Consolidation

• Scenerio

• SubTotal

What is the default file extension of a MS Excel Workbook?

• .ods

• .xlsx

• .odt

• .xlw

What is the default file extension of Open Office Calc?

• .ods

• .odt

• .obd

• .odb

Which tool is used to test What-If Questions?

• Solver

• SubTotal

• Scenerio

• Multiple Operations

Which of the following deals with equation with multiple unknown variables?

• Subtotal

• Scenerio

• Solver

• Goal Seek

How many ways you can rename a worksheet?

• 1

• 2

• 3

• 4

Shared workbook don't allow:

• Merging Cells

• Conditional formatting

• Inserting pictures or graphs

• All of the above

________ is a saved sequence of commands and keystrokes that are stored for future use.

• MACROS

• Goal Seek

• Solver

• Consolidation

Subtotal is a function listed under which category?

• Mathematical

• Logical

• General

• All of the above