Class X Information Technology 402 CBSE Q3

The edited documents can be saved by using.

• Ctrl + S

• File -> Save As

• File -> Save

• All of these

When we right click on drawing object, a _____________ menu opens.

• Context Menu

• Pop up Menu

• Shortcut Menu

• All of these

Which of the following is a set of formats consisting of such things as fonts, colors, etc?

• Margin

• Indent

• Header

• Style

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

• Sheet1

• Sheets1

• Sheet-1

• None of these

We can consolidate data by ______________.

• Column Label

• Row Label

• Both Row and Column Label

• None of these

Which one is not a function in MS Excel/Calc?

• MIN

• MAX

• SUM

• AVG

Which of the following is not the information you can specify using the solver?

• Changing cells

• Constraints

• Input cells

• Target Cells

Consolidate option is available under ____________ menu.

• Data

• Insert

• View

• Tool

If you select ______________ then any values modified in the source range are automatically updated in the target range.

• Link to original data

• Link to sheet data

• Link to source data

• Link to source range

A numeric value can be treated as a label value if it precedes with :

• Ampersand (&)

• Exclamation (!)

• Hash (#)

• Apostrophe (')