Computer Operator Questions-Part 10

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

2

1. If you combine B5,B6,C5 and C6 clls,you will get a big cell. What address will be reflected for this big cell?

B5C5
B5
C5
B5C5B6C6

2. To run a presentation from the slide where the slide was previously stopped at, the short cut key is:

Shift+F5
F5
Ctrl+Shift+F5
Alt+Shift+F5

3. A ... is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes and primary keys and foreign keys?

Schema diagram
Relational algebra
Database diagram
Schema flow

4. How do you generate "Table of Contents" in word file?

Go to References and select Table of Contents
Go to References and select Update Table
Go to Insert and select Table of Contents
Go to Insert and select Update Table

5. Which of the following is not an open source software?

Libre office
Open Office
Microsoft office
Linux

6. FOSS is the

Open Source Software
Free and Open Source Software
Proprietary Software
Public Domain Software

7. Which of the following support presentation application?

Google slides
Microsoft Powerpoint
Libre Office Impress
All the above

8. Which of the following is not the advantage of database?

Increase data dependency
Reduce data redundancy
Increase data consistency
Data security

9. SQL data type to denote a character string value is

Char
Varchar
Text
All the above

10. Libre Office Base is a

Database Management Application
Word processing Application
Spreadsheet Application
Presentation Application

11. A COUNTIF can be used to

Count specific values
Count based on a condition
Both A and B
None of the above

12. An operator gives a range C30:L100.The cell that doesn't fall in this range is:

J31
L30
F99
N33

13. When you click on a spreadsheet, a rectangular box with thick outlines becomes prominent.Its is called

Workbook
Active cell
Cell
Locked cell

14. To return a remainder after a number is divided by a divisor in Excel, which function is used?

Animation scheme
Slide transition
Animation objects
Slide Design

15. An image editor which is similar to Adobe Photoshop is

NVU
Open office
Blue fish
GIMP shop

16. Which of the following tag is used to add rows in the table?

<td>
<tr>
<th>
None of the above

17. What should be the first tag in any HTML document?

&lt;head&gt;
&lt;title&gt;
&lt;html&gt;
<document>

18. The arrangement of name list in sequential order is called:

Formatting
Sorting
Ordering
Listing

19. The formula to add number in cell A3 upto cell A7 is:

=avg(A3:A7)
=sum(A3:A7)
=add(A3:A7)
=sum(A3-A7)

20. The feature in word processor that enables to send same letter by addressing different persons:

Template
Mail Merge
Hyperlink
Macros

21. Gutter margin is

Margin that is added to left margin when printing
Margin that is added to right margin when printing
Margin that is added to binding side of page
Margin that is added to the outside of the page when printing

22. A computer operator needs to search all files hose file name starts with 'H' and ends in 'X'. It has an extension of docx. The correct search text is:

H*X.docx
*H*X.docx
*H*X.*
H-X.docx

23. The command used by an user to create a new directory is

mkdir
dir
chdir
chkdsk

24. Which of the operating system is not open source?

Linux Operating System
Apple macOs
Free BSD operating system
All the above

25. ..... is the process to copy data from one location and store in another location as an alternative in case the original data is lost.

Restore
Backup
Format
Duplicate

Tags: