Computer Operator Questions-Part 6
Here, you can read and text important MCQ of loksewa computer operator.
1. Word wrap feature...
Set text inside the fixed margin
Appears at the bottom of the document
Mark the paragraph center
None of the above
Correct Answer
Wrong Answer
2. A4 size paper is
8.5 X 11 inches
8.5 X 11.5 inches
8.27 X 11.69 inches
8.5 X 14 inches
Correct Answer
Wrong Answer
3. Short cut key to collapse the ribbon so that only the tab names show
Ctrl + F1
Ctrl + F2
Ctrl + F11
Ctrl + F12
Correct Answer
Wrong Answer
4. To stack your open windows so you can see all of them at once you use
Switch windows
Split
New windows
Arrange all
Correct Answer
Wrong Answer
5. Which of the following is not available in font spacing?
Normal
Condensed
Compact
Expanded
Correct Answer
Wrong Answer
6. To create copyright symbol use
Ctrl+Shift+C
Ctrl+Alt+C
Ctrl+C
Shift+C
Correct Answer
Wrong Answer
7. What is the function used to convert row data into column or column data into row?
Convert
Index
Transpose
Change
Correct Answer
Wrong Answer
8. Which function can be used to calculate monthly mortgage payment?
PMT
NPER
PV
MORT
Correct Answer
Wrong Answer
9. How do you rearrange the data in ascending or descending order?
Sort
Form
Table
Arrange
Correct Answer
Wrong Answer
10. Which of the following is not the correct method of editing cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Correct Answer
Wrong Answer
11. Selecting the rows 5 and 6 then choose Insert>>Row. What will happen?
2 rows will be inserted after row 4
2 rows will be inserted after row 5
2 rows will be inserted after row 6
2 rows will be inserted after row 7
Correct Answer
Wrong Answer
12. To return the remainder after a number is divided by a divisor in Excel we use the function
Round()
Fact()
Mod()
Remainder()
Correct Answer
Wrong Answer
13. In excel, a data series is defined as
A type of chart
A cell reference
A collection of related data
A division of result
Correct Answer
Wrong Answer
14. Maximum number of decimal places you can put in MS Excel is
32
16
30
8
Correct Answer
Wrong Answer
15. What degree of text alignment orientation is possible in MS Excel Cells?
0 to 90
-90 to +90
0 to 180
0 to 360
Correct Answer
Wrong Answer
16. Relationship in database is maintained through
Table
Index
Views
Keys
Correct Answer
Wrong Answer
17. To record a sequence of keystrokes and mouse actions to play back later we use
Media Player
Sound recorder
Calculator
Macro reader
Correct Answer
Wrong Answer
18. A function inside another function is called ..... function.
Nested
Rounded
Main
User defined
Correct Answer
Wrong Answer
19. A numeric value can be treated as label value if ..... preceded it.
'
!
#
~
Correct Answer
Wrong Answer
20. Which language is used to create macros in Excel?
C
Visual C++
Visual basic
Java
Correct Answer
Wrong Answer
21. How can you insert header or footer in MS Excel sheet?
Double clicking on header or footer area and type
Using insert>>header and footer
Both A and B
None of the above
Correct Answer
Wrong Answer
22. Which one is best suited to represent expenditure in different departments?
Column chart
Line chart
Pie chart
Dot chart
Correct Answer
Wrong Answer
23. Which of the following contains the name of each record on the chart?
Cell
Title
Axis
Legend
Correct Answer
Wrong Answer
24. In MS-Excel, to protect a worksheet, you can choose protection and the protect sheet from the .... menu.
Edit
Format
Tools
All the above
Correct Answer
Wrong Answer
25. In DBMS, column header is refer as
Table
Relation
Attribute
Domain
