WorksheetsSkill Competition (IT Quiz) Class X
Total questions: 25
Worksheet time: 13mins
The Table of Contents (TOC) list will create a link to which paragraph feature?
Heading Styles
None, TOC is not a paragraph feature
Fancy Formats
Don’t know
Styles & Formatting window is available in __________ menu
Format
Insert
Tools
View
Ananya wants that her company’s logo should automatically appear on the top of the Writer document whenever she opens a new document. Which feature of Writer will help her to do so?
Style
Automatic
Template
All of the above
________________ is a set of formats that we can apply to a selected text, paragraphs, frames
Style
Format
Image
Graphics
Q 74. Macros are especially useful to ___________ a task.
a. do
b. repeat
c. simplify
d. complicate
Q 76. Click _____________ to stop the macro recorder
a. Close Recording
b. End Recording
c. Stop Recording
d. None of the above
Q 69. “Accept or Reject Changes” dialog box (for shared worksheet) can be opened by clicking on
a. File > Changes > Accept or Reject.
b. Edit > Changes > Accept or Reject.
c. View > Changes > Accept or Reject.
d. None of the above
Q 65. Which of the following changes are not recorded in shared worksheet?
a. Changes any number
b. Changes any text
c. Cell Formatting
d. None of the above
Q 59. Any cells modified by the other user in shared worksheet are shown with a ________ border.
a. Blue
b. Green
c. Red
d. Yellow
Q 53. In Calc “Share Document” dialog box can open by clicking on ______________ menu.
a. File
b. Edit
c. View
d. Tool
Q 43. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert
Q 37. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =’S1′.A3
d. None of the above
Q24. Goal Seek Option available in __ menu.
a. Tools
b. Format
c. Data
d. Insert
Q27. ____________ is more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above
_______ is a link on clicking opens the linked documents.
interlinking
connecting link
hyperlink
superlink
We can shift from one SCENARIO to another by _________
Navigator
Find and Replace
Data Source
None of the above
Scenarios are tool to test ______ questions.
if else
what if
what else
do while
In SUBTOTALS we can select up to ________ groups of arrays.
3
6
2
4
Which option is used to name a range of cells?
Range name
Cell Range
Define Range
Select Range
____means combining data in a sreadsheet from different worksheets into master worksheet
hyperlink
consolidating
filter
none
