AIIMS Office Assistant Previous Year Question Paper- 2017 (Computer Questions)

Board Name: AIIMS Bhubaneswar

Post Name: Office Assistant (NS)

Time: 3 Hours

Total Questions: 120

Full Marks: 480

Each Question Carries: 4 Mark

Exam Year: 2017

AIIMS Office Assistant Previous Year Question Paper:-

96. The Basic Input/Output System (BIOS) software is stored in:

1. ROM
2. CPU
3. Hard Drive
4. RAM
Ans: (1)



97. Which browser was introduced by Microsoft in 1995

1. Chrome
2. Mozilla
3. Internet Explorer
4. Mosaic
Ans: (3)



98. From menu, bar which menu gives the options to cut, copy and paste the selected document?

1. Format menu
2. File menu
3. Home tab menu
4. View tab menu
Ans: (3)



99. What will be the result of the EXCEL expression = MONTH ("4/4/1977")?

1. April
2. #Value!
3. 1
4. 4
Ans: (4)



100. Which of the following is NOT an Excel file extension?

1. .xlsx
2. .xls
3. .slx
4. .xlw
Ans: (3)



101. The value of the EXCEL expression = POWER(2, 10) would be:

1. 1024
2. 1000
3. 20
4. 5
Ans: (1)



102. Which is the first computer network of the world?

1. I net
2. Intranet
3. V net
4. Arpanet
Ans: (4)



103. Which is NOT among the 4 keys being used in RDBMS?

1. Unique key
2. Primary key
3. Domestic key
4. Foreign key
Ans: (3)





104. ATM facility being given by banks is a very good example of:

1. LAN
2. CAN
3. WAN
4. MAN
Ans: (3)



105. Which protocol is used for communication between browser and server?

1. DNS
2. HTTP
3. FTP
4. SMTP
Ans: (2)



106. What is the outcome of the EXCEL function = Trim("Excel Data")?

1. Trims the white spaces from both ends; also strips extra spaces from text, leaving only single spaces between words - "Excel Data"
2. Trims only the spaces between the words - "ExcelData"
3. Trims the white spaces from both ends, including the spaces between the words - "ExcelData"
4. Trims the string at the first occurrence of a white space - ""
Ans: (1)



107. When more computers are connected with each other at a single location, it is called as:

1. LAN
2. WAN
3. TREE
4. MAN
Ans: (1)



108. An electrical connector used to carry audio and video signals in computer systems is:

1. ARC Connector
2. AVC Connector
3. RCA Connector
4. Photo Connector
Ans: (3)



109. Considering the date format as "dd/mm/yyyy", the Excel expression =DATEDIF("11/5/1984","5/11/2016","Y") would return:

1. 11694
2. 0
3. 32
4. #Num!
Ans: (3)



110. Computer Monitor is also known as:

1. DVD
2. CCT
3. VDU
4. CPU
Ans: (3)



111. Which of the following is NOT a part of MS Office Suite?

1. Excel
2. Power Point
3. Word
4. WordPad
Ans: (4)



112. What does BCC stand for with respect to email communication?

1. Blind Carbon Copy
2. Bold Care Copy
3. Blue Carbon Copy
4. Bold Carbon Copy
Ans: (1)



113. In 1932, who invented the magnetic data storage device (Drum Memory)?

1. Jack Kilby
2. Alexander Bain
3. Gustav Tauschek
4. Jacob Rabinow
Ans: (3)





114. Which of the following is an Excel template file extension?

1. .aspx
2. .xslt
3. .xltx
4. .ppsx
Ans: (1)



115. The EXCEL function =LEN("Hello") returns which of the following results?

1. Whether the text is a part of Latin Encyclopaedia
2. The length of a string including spaces
3. The length of a string ignoring spaces
4. Whether the language of the text is English
Ans: (2)



116. ______ was the first commercial service provider to offer email facility on a large scale.

1. Yahoo
2. Hotmail
3. CompuServe
4. Gmail
Ans: (1)



117. An assembler is _______.

1. machine-depedent
2. data-dependent
3. programming-language-dependent
4. syntax-dependent
Ans: (1)



118. How to make text Bold in Word using short-cut keys?

1. Ctrl + U
2. Ctrl + F
3. Ctrl + I
4. Ctrl + B
Ans: (4)





119. Which one of the following is NOT correct about the Ruler in MS Word?

1. It is located just below the title bar
2. You can change setting to show or hide ruler
3. It is located just below the ribbon
4. It is located for document layout purpose
Ans: (1)



120. In a blank MS-Excel sheet, which of the following keyboard shortcuts is used to jump from the first column to the last column and vice-versa?

1. CTRL + >, CTRL + <
2. CTRL + Right Arrow, CTRL + Left Arrow
3. CTRL + PgUp, CTRL + PgDn
4. CTRL + Down Arrow, CTRL + Up Arrow
Ans: (2)

PART-I: English (20 Q)

PART-II: Mathematics (25 Q)

PART-III: GK (25 Q)

PART-IV: Reasoning (25 Q)

PART-V: Computer (25 Q)