Computer Operator Questions-Part 15
Here, you can read and text important MCQ of loksewa computer operator.
1. To monitor all document changes, we use .....
Edit
Monitor change
Track change
Navigator
Correct Answer
Wrong Answer
2. What keystroke combination is used to run spelling and grammar check ?
Alt+F7
Ctrl+F7
Shift+F5
F7
Correct Answer
Wrong Answer
3. Footnotes usually appear .... in MS Word.
At the top of the page
At the bottom of the page
At the end of the section
At the end of the document
Correct Answer
Wrong Answer
4. What keystroke combination is used to open an existing document?
Alt+O
Ctrl+N
Shift+O
Ctrl+O
Correct Answer
Wrong Answer
5. In which view Header and Footers are available?
Normal view
Page layout view
Print layout view
Draft view
Correct Answer
Wrong Answer
6. Which features is used to create newspaper like document?
Tap stops
Bullet and Numbering
Columns
Table
Correct Answer
Wrong Answer
7. The cell reference M$4 is a ....
Relative cell reference
Absolute cell reference
Mixed cell reference
Reflective reference
Correct Answer
Wrong Answer
8. Getting data from a cell located in a different sheet is called .....
Accessing
Referencing
Updating
Functioning
Correct Answer
Wrong Answer
9. When applying conditional formatting, we can check conditions against .....
Cell value
Formula
Formatting
All the above
Correct Answer
Wrong Answer
10. To create an interactive PIVOT table for the web, we use a MS office web component known as
Pivot table list
Pivot table report
HTML
Pivot table field list
Correct Answer
Wrong Answer
11. The function to convert row data to column and vice versa is
Convert
Index
Change
Transpose
Correct Answer
Wrong Answer
12. Which of the following is not associated with spelling dialog box in MS Excel?
Replace
Ignore once
Ignore all
Change
Correct Answer
Wrong Answer
13. Which of the following is absolute cell reference?
$A$1
#A$1
@A@1
#A#1
Correct Answer
Wrong Answer
14. Which function is used to calculate the monthly mortgage payment?
PMT
NPER
PV
MORT
Correct Answer
Wrong Answer
15. Database is generally .....
System centered
User centered
Company centered
Data centered
Correct Answer
Wrong Answer
16. Which of the following is not involved in DBMS?
End Users
Data
Application request
HTML
Correct Answer
Wrong Answer
17. Primary key field of a table included in another table is called
Surrogate key
Foreign key
Compound key
Composite key
Correct Answer
Wrong Answer
18. COMMIT and ROLLBACK command are ..... Control commands.
Data Access
Transactions
Table
File
Correct Answer
Wrong Answer
19. In Relational Model,Attributes are called
Rows
Column
Table
Relation
Correct Answer
Wrong Answer
20. The slide that is used to introduce a topic and set the tone for the presentation is called
Title slide
Bullet slide
Table slide
Graph slide
Correct Answer
Wrong Answer
21. The effect applied to display when slides change in slide show view is
Custom Animation
Slide Transition
Slide Animation
Slide Movement
Correct Answer
Wrong Answer
22. Animation can be applied on:
Slides
Objects
Views
Designs
Correct Answer
Wrong Answer
23. Which program is used by web clients to view the web pages?
Web browsers
Protocols
Web server
Search engine
Correct Answer
Wrong Answer
24. Relative URLs are used to
link other pages within the same site
link the same page with other sites
link other pages with other sites
does not linked
Correct Answer
Wrong Answer
25. Which of the following statement is false?
Develop a website without using PHP
Develop a website without using HTML
Develop a website without using CSS
Develop a website without using Javascript
