1. Which of the following is an absolute cell reference?
$C$1
$D1$
#B$1
#E#1
Correct Answer
Wrong Answer
2. The four types of mail merge main document in MS word are
Form letters,directories,catalogues and envelops
Form letters,envelops, and mailing labels,directories and lists
Basic letters,envelops,labels and lists
Form letters,envelops,mailing labels and directory
Correct Answer
Wrong Answer
3. Comments can be added to cells using
Review->Comments
Insert->Comments
File->Comments
View->Comments
Correct Answer
Wrong Answer
4. What is the maximum number of columns in worksheet?
256
255
65536
131072
Correct Answer
Wrong Answer
5. Getting data from cell located in different sheet is called
Referencing
Updating
Functioning
Validating
Correct Answer
Wrong Answer
6. Which function allows user to repeat certain rows and column on each page while printing
Print repeat
Print header
Print title
Print cells
Correct Answer
Wrong Answer
7. The shortcut to shift active to one screen right
Alt+ Page Up
Alt+ Page Down
Ctrl+ Page Up
Ctrl+ Page Down
Correct Answer
Wrong Answer
8. Which of the following is conditional function?
Round
And
If
Then
Correct Answer
Wrong Answer
9. What divides windows into two different panes that cache scrool separately
Mirror
Slide
Split
Pane manager
Correct Answer
Wrong Answer
10. The candidate key is that you choose to identify each row uniquely is
Alternate key
Foreign Key
Both A and B
Primary key
Correct Answer
Wrong Answer
11. The topology which requires a central controller or hub is called as
Mesh topology
Star topology
Bush topology
Ring topology
Correct Answer
Wrong Answer
12. Which of the following data types can be used to store unstructured data?
Raw
Char
Numeric
Varchar
Correct Answer
Wrong Answer
13. Which of the following eliminates duplicate records?
No duplicate
Eliminate
Distinct
None of the above
Correct Answer
Wrong Answer
14. Which of them is not a network topology?
Star
Mesh
Ring
Peer to peer
Correct Answer
Wrong Answer
15. The ASCII value of letter 'A' is
97
67
65
95
Correct Answer
Wrong Answer
16. As per the electronic transaction act 2008, the digital signature and certificate may be revoked for
Death of the subscriber
Upon proving that requirements were not fulfilled completely
If false information were provided during issuance
All of the above
Correct Answer
Wrong Answer
17. Which of the following is the high speed memory used in computer?
RAM
Hard disk
Cache memory
SSD
Correct Answer
Wrong Answer
18. Pasting a website content to MS word to reflect the style of word documents cursor can be achieved by
Ctrl+V
Ctrl+Alt+V
Ctrl+Shift+V
Alt+Shift+V
Correct Answer
Wrong Answer
19. A computer operator is writing in Preeti font. Same characters do changes while being typed. The correct location to customized the setting to disable auto changing is
Symbols
Macros
Spelling and Grammar
Auto correct
Correct Answer
Wrong Answer
20. Example of computer font is
Bold
Italic
Arial
40pt
Correct Answer
Wrong Answer
21. The default page size can be changed by setting:
Page layout
Ruler
Insert
Design layout
Correct Answer
Wrong Answer
22. Choose the applications which provide the facilities of word processing:
Microsoft word
Ope office writer
Wordpad
All the above
Correct Answer
Wrong Answer
23. When designing an HTML page,the title bar text can be changed by using: