indiamcq-blog

[indiamcq-blog]

Microsoft Excel Set-11

101. You can zoom a worksheet

a. With the mouse pointer in Print Preview

b. With the zoom button on the Print Preview toolbar

c. With the Zoom command on the view menu

d. All of the above

102. You can not link Excel worksheet data to a Word document

a. With the right drag method

b. With a hyperlink

c. With the copy and paste special commands

d. With the copy…

[indiamcq-blog]

Microsoft Excel Set-10

91. The Chart wizard term data categories refers to;

a. A chart plot area

b. A horizontal axis

c. The organization of individual values with a chart’s data series

d. The data range that supply chart data

92. A worksheet range is a

a. A command used for data modeling

b. A range of values such as from 23 to 234

c. A group of cells

d. A group of worksheets

93…

[indiamcq-blog]

Microsoft Excel Set-9

81. Which of the following is an absolute cell reference?

a. !A!1

b. $A$1

c. #a#1

d. A1

82. What symbol is used before a number to make it a label?

a. “ (quote)

b. = (equal)

c. _ (underscore)

d. ‘ (apostrophe)

83. Which symbol must all formula begin with?

a. =

b. +

c. (

d.

84. Which of the following formulas is not entered correctly?

[indiamcq-blog]

Microsoft Excel Set-8

71. Documentation should include

a. Destination and users of the output data

b. Source of input data

c. Information on the purpose of the workbook

d. All of the above

72. Files created with Lotus 1-2-3 have an extension

a. DOC

b. XLS

c. 123

d. WK1

73. To delete an embedded objects, first

a. Double click the object

b. Select the object by clicking it

[indiamcq-blog]

Microsoft Excel Set-7

61. to view a cell comment

a. click the edit comment command on the insert menu

b. click the display comment command on the window menu

c. position the mouse pointer over the cell

d. click the comment command on the view menu

62. When you want to insert a blank imbedded excel object in a word document you can

a. Click the object command on the insert menu

b. Click the…

[indiamcq-blog]

Microsoft Excel Set-6

51. Which of the following is a correct order of precedence in formula calculation?

a. Multiplication and division exponentiation positive and negative values

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation

d. All of above

53. The numbers in our worksheet look like…

[indiamcq-blog]

Microsoft Excel Set-5

41. You can use the formula palette to

a. Format cells containing numbers

b. Create and edit formulas containing functions

c. Enter assumptions data

d. Copy a range of cells

42. You can convert existing excel worksheet data an charts to an HTML document by using

a. FTP wizard

b. Internet assistant wizard

c. Intranet wizard

d. Import wizard

43. A circular…

[indiamcq-blog]

Fundamental Set -19

Which American computer company is called Big Blue? A) Microsoft B) Compaq Corp C) IBM D) Tandy Svenson

It was in 2028 BS the _ was brought in to calculate census data. A) IBM 1400 B) IBM 1401 C) ICL 2950 D) None of above

Who is the inventor of ABC Computer? A) John v. Atanasoff B) Clifford Berry C) Both of above D) None of above

Which of the following is the largest unit? A) data B) field C) record

[indiamcq-blog]

Fundamental Set -18

201.Which of the following is not valid statement?

A) Hard is referred to mean something temporary

B) Hard is used to mean something tangible

C) Soft is used to mean something permanent

D) Soft is used to mean something tangible

202. Digital devices are

A) Digital Clock

B) Automobile speed meter

C) Clock with a dial and two hands

D) All of them

[indiamcq-blog]

Fundamental Set -17

191. A term associated with the comparison of processing speeds of different computer system is: A) EFTS B) MPG C) MIPS D) CPS

192. which of the following is problem oriented language? A) High level language B) Machine language C) Assembly language D) Low level language

193. A 32 bit microprocessor has the word length equal to A) 2 byte B) 32 byte C) 4 byte D) 8 byte

194. The term GIGO is related…

[indiamcq-blog]

Fundamental Set -16

181. A system is A) an integration of different units so as to achieve an objective B) input unit C) input and output unit D) input, output and storage units

182. Which of the following programming language started from second generation? A) Cobol B) BASIC C) C D) LISP

183. The translator program used in assembly language is called A) Compiler B) Interpreter C) Assembler D) Translator

184. EEPROM…

[indiamcq-blog]

Fundamental Set -15

171. Which part of the computer is used for calculating and comparing? A) Disk unit B) Control unit C) ALU D) Modem

172. ABC is a A) Special purpose computer B) General purpose computer C) All Purpose Computer D) None of above

173. The computer code for the interchange of information between terminals is A) ASCII B) BCD C) EBCDIC D) All of above

174. When was the X window system born? A) 1984 B)…

[indiamcq-blog]

Fundamental Set -14

161. Which unit converts computer data into human readable form? A) Input unit B) Output unit C) ALU D) Control Unit

162. The full form of ALU is A) Arithmetic Logic Unit B) Array Logic Unit C) Application Logic Unit D) None of above

163. What produces useful information out of data? A) Computer B) Processing C) Programming D) none of above

164. Which of the following device was not invented by…

[indiamcq-blog]

Fundamental Set -13

151. Which is the highest form? A) Data B) Information C) Knowledge D) All of above

152. Who is credited with the idea of using punch cards to control patterns in a waving machine? A) Pascal B) Hollerith C) Babbage D) Jacquard

153. What is an interpreter? A) An interpreter does the conversion line by line as the program is run B) An interpreter is the representation of the system being designed C)…

[indiamcq-blog]

Fundamental Set -12

141. What was the main disadvantage of vacuum tubes? A) They were larger in size B) They consumed a lot of electricity C) They produced heat and often burned out D) The operation cost was high

142. Registers, which are partially visible to users and used to hold conditional, are known as A) PC B) Memory address registers C) General purpose register D) Flags

143. Which is not a computer of first…

[indiamcq-blog]

Fundamental Set -11

131. Who invented Integrated Circuits? A) Jack Kilby B) Robert Noyce C) Both of above D) None of above

132. Operating system, editors, and debuggers comes under? A) System Software B) Application Software C) Utilities D) None of the above

133. One computer that is not considered a portable is A) Minicomputer B) Laptop computer C) Notebook computer D) All of above

134. Which of the following is…

[indiamcq-blog]

Fundamental Set -10

121. The advantage of COM are its __ and __ A) Compact size; speed readability B) Compact size, speed C) Readability; speed D) Low cost; readability

122. The BIOS is the abbreviation of ________. A) Basic Input Output System B) Best Input Output System C) Basic Input Output Symbol D) Base Input Output System

123. Which printer is very commonly used for desktop publishing? A) Laser printer B)…