WorksheetsClass X Information Technology 402 CBSE Q3
Total questions: 21
Worksheet time: 11mins
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 (')
We can rename a new sheet in calc.
After inserting a new sheet
While inserting a new sheet
Both after inserting a new sheet and while inserting a new sheet
None of these
Record Changes feature of Calc help
to record the screen
Authors and other reviewers to know which cells were edited.
to make changes permanent
to prevent changes in sheet
Hyperlinking option is available in _____________ menu
Edit
File
Format
Insert
To edit a Macro, go to
Edit > Macros > Edit Macros
View > Macros > Edit Macros
Tools > Macros > Edit Macros
None of these
On an Excel/Calc sheet the active cell is indicated by :
A Dotted Border
By Italic Text
A Dark Wide Border
A Blinking Border
In Calc Share Document dialog box can be opened by clicking on __________ menu.
Edit
Tool
File
View
Excel / Calc uniquely identifies cells within a worksheet with a cell name :
Cell Names
Cell locator letter
Column letters and row numbers
Column numbers and row letters
Collection of related records in a database is known as :
File
Bench
Table
Relationship
What do you mean by the One to Many relationship between Student and Class Table?
Many classes may have many students
One class may have many students
One student can have many classes
Many students may have many classes.
A composite key is :
required when a table does not have any unique fields in it
the primary key with Auto Number as the field type
made up of two or more fields to uniquely identify records
a foreign key that uniquely identifies records.
In a database, the information is stored in the form of _____________.
Standards
Columns only
Rows only
Tables
