Computer Operator Questions-Part 2

1

1. When a formatted number does not fit within a cell, it displays

#####
#DIV/0
#DIV@
None of the above

2. Each excel file is called a workbook because

It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it

3. Which of the following is concantenating operator?

Apostrophe(')
Exclamation(!)
Ampersand(&)
Hash(#)

4. Which of the following formulas will Excel not be able to calculate?

=sum(sell)-A4
=sum(A1:A5)*6
=sum(A1:A5)/12
=sum(A1:A5)-10

5. When data changes in multiple lists and all lists are not updated, this causes

data redundancy
duplicate data
information overload
data inconsistency

6. The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

Order by
View
Group By
Sort

7. Which query command does not change any data in the database?

UPDATE
DELETE
INSERT
SELECT

8. Relationship between entities Office to Staff is

Many to one
One to one
One to many
Many to Many

9. Which of these is not an operating system ?

Linux
iOS
Java
Android

10. Which of them is a Cloud storage srrvices ?

Google meet
Google drive
Outlook
Teams

11. Ethernet cards are used for

Scanning
Internet connection
Graphics design
Printing

12. Ms excel is an example of

DBMS
Presentation software
Workbook software
spreadsheet software

13. Which of the following is not a web browser?

Google
Safari
Opera
Brave

14. Trojan virus is a malware that

Affects OS
Make computer slow
Create network traffic
Encrypt data

15. How can you merge the selected cells in same row in Ms excel?

Selected>Merge cells
Select cell>Merge & center
Select cell>Merge across
Selecy cell>Unmerged

16. There are maximum of …rows in Ms excel 2021.

1048576
16364
Unlimited
As per user requirement

17. ……is software which is freely available on internet with source code for further improvement

Pirated software
Open source software
Liscensed software
Free software

18. The concept in PPT which controls how presentation moves from one slide to next slide

Animation
Effects
Transition
Section break

19. Deleting a table from database can be done using

Delete statement
Remove statement
Drop table statement
All the above

20. Creating a different numbering style based on chapter of a book typed in Ms word can be achieve by using

Footer setting
Line break
Page break
Section break

21. A page needs a watermark. We can create watermark by setting

Page layout
Format painter
Ruler
Section break

22. Full form of GUI is

Graphical User Integration
Graphical User Interface
Graphical User Identification
Geometrical User Integration

23. A three layer switch is a kind of

Repeater
Bridge
Router
None of the above

24. How do you display current date and time in MS Excel?

=today()
=now()
=date()
=present()

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

<td>
<tr>
<th>
<row>

Tags: