Computer Operator Questions-Part 6

Here, you can read and text important MCQ of loksewa computer operator.

0

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

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

3. Short cut key to collapse the ribbon so that only the tab names show

Ctrl + F1
Ctrl + F2
Ctrl + F11
Ctrl + F12

4. To stack your open windows so you can see all of them at once you use

Switch windows
Split
New windows
Arrange all

5. Which of the following is not available in font spacing?

Normal
Condensed
Compact
Expanded

6. To create copyright symbol use

Ctrl+Shift+C
Ctrl+Alt+C
Ctrl+C
Shift+C

7. What is the function used to convert row data into column or column data into row?

Convert
Index
Transpose
Change

8. Which function can be used to calculate monthly mortgage payment?

PMT
NPER
PV
MORT

9. How do you rearrange the data in ascending or descending order?

Sort
Form
Table
Arrange

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

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

12. To return the remainder after a number is divided by a divisor in Excel we use the function

Round()
Fact()
Mod()
Remainder()

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

14. Maximum number of decimal places you can put in MS Excel is

32
16
30
8

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

16. Relationship in database is maintained through

Table
Index
Views
Keys

17. To record a sequence of keystrokes and mouse actions to play back later we use

Media Player
Sound recorder
Calculator
Macro reader

18. A function inside another function is called ..... function.

Nested
Rounded
Main
User defined

19. A numeric value can be treated as label value if ..... preceded it.

'
!
#
~

20. Which language is used to create macros in Excel?

C
Visual C++
Visual basic
Java

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

22. Which one is best suited to represent expenditure in different departments?

Column chart
Line chart
Pie chart
Dot chart

23. Which of the following contains the name of each record on the chart?

Cell
Title
Axis
Legend

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

25. In DBMS, column header is refer as

Table
Relation
Attribute
Domain

Tags: