. What is the correct way to refer the cell A10 on sheet3 from sheet1?

Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Ans: – A ,

More MS-Excel Related questions:

8.In the threads model of parallel programming
Options: (A)A single process can have multiple, concurrent execution paths (B) A single process can have single, concurrent execution paths. (C) A multiple process can have single concurrent execution paths. (D) None of these 2

Ans:28. (A),28. (A)

Bera Siyul


The management information system (MIS) structure with one main computer system is called a
Options: a. hierarchical MIS structure b. distributed MIS structure c. centralized MIS structure d. decentralized MIS structure

Ans:C,centralized MIS structure

Which of the following conditions should exist if you want to convert a relationship to an associative entity?
Options: Some of the relationships for the participating entities are "many".,    The resulting associative entity has an independent meaning.,    The resulting associative entity has no attributes.,    All of the above

Ans:B ,B

The Indian Red Cross Society was established in the year
Options: 1932,    1920,    1945,    1890


MS-Word automatically moves the text to the next line when it reaches the right edge of the screen and is called?
Options: Carriage Return B. Enter C. Word Wrap D. None of the above

Ans:– C ,

What is the name of the CalTech seismologist who invented the scale used to measure the magnitude of earthquakes?
Options: Charles Richter,    Hiram Walker,    Giuseppe Mercalli,    Joshua Rumble


5.The volatility of a file refers to
Options: (A)The number of records added or deleted from a file composed to the original number of records in that file (B) Efficiency with which non-sequential files are processed(C) The extent where the records of the file are contiguous and in proximity to others (D) Percentage of records that has changed in a given time period 26

Ans:265. (A),265. (A)

A transitive dependency is which of the following?
Options: A functional dependency between two or more key attributes.,    A functional dependency between two or more nonkey attributes.,    A relation that is in first normal form.,    A relation that is in second normal form.

Ans:B ,B

6.In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Options: (A)Unfreeze panes command on the window menu (B) Freeze panes command on the window menu (C) Hold titles command on the edit menu (D) Split command on the window menu 9

Ans:96. (B),96. (B)

Which of the following characteristic(s) is/are suited to the PSS applications?
Options: bursty traffic and low communications intensity,    widely dispersed terminals and access to international packets switched services,    Multiple remote host or applications accessed by a single local access circuit terminal and circuit,    All of the above

Ans:D ,D

9.EFF sites allows anonymous FTP that
Options: (A)Do not require a password or access (B) Requires password or access (C) Is a none access file (D) None of these 8

Ans:79. (A),79. (A)

The mass of P4O10 that will be obtained from the reaction of 1.33 gram of P4 and 5.07 of oxygen is
Options: 2.05 gram,    3.05 gram,    4.05 gram,    5.05 gram


8.The number of process states recognized by UNIX
Options: (A)Two (B) Nine (C) Eight (D) Seven. 19

Ans:198. (B),198. (B)

Robert Koch worked on
Options: tuberculosis,    cholera,    malaria,    diabetes


. Binary circuit elements have
Options: A) One stable state B) Two stable state C) Three stable state D) None of above


The chairman of 21st Law Commission is
Options: NA

Ans:Justice Balbir Singh Chauhan,Justice Balbir Singh Chauhan

. You can load character map by
Options: a. Program >> accessories >> system tools >> character map b. Program >> Microsoft >> System tools >> character map c. Both of above d. None of above

Ans:9 – a ,9 – a

. The _____ is a short horizontal line indicating the conclusion of a document.
Options: a. insertion point b. end mark c. status indicator d. scroll box

Ans:– B,– B

The longest method of conversion is
Options: direct,    parallel,    phased,    pilot

Ans:A ,A

The device that can both feed data into and accept data from a computer is
Options: ALU,    CPU,    Input-Output device,    All of the above


AutoCorrect was originally designed to replace _________ words as you type.
Options:  A) Short, repetitive, B) Grammatically incorrect, C) Misspelled, D) None of the above,


205. sanvidhaan kee 8veen anusoochee mein kitanee bhaarateey bhaashaon ko maanyata dee gayee hai ?
Options: NA

Ans: 22, 22

6.The following command is used for sorting
Options: (A)list (B) browse (C) index (D) sort 3

Ans:36. (C),36. (C)

Rahul Dravid also made Test debut along with Sourav Ganguly in the same match.He scored 95 runs. How many fours did he hit in that innings of 95 runs?
Options: 6,    10,    5,    7


Which is considered a direct entry input device?
Options: Optical scanner,    Mouse,    Light pen,    Digitizer

Ans:E ,E

The first step of the implementation phase is
Options: select the computer,    announce the implementation project,    implementation planning,    prepare physical facilities

Ans:C ,C

0. “Ctrl + Down Arrow” is used to
Options: Moves the cursor one paragraph down B. Moves the cursor one line down C. Moves the cursor one page down D. Moves the cursor one screen down

Ans: – A ,

What is the jumper setting on a SCSI device to configure it to use the fourth SCSI id? Remember, SCSI ids start with zero.
Options: 010,    110,    011,    101

Ans:C ,C

7.Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
Options: (A)Relational (B) Structural (C) Network (D) All of the above 144 | 14

Ans:147. (B),147. (B)

A network with named nodes and labeled arcs that can be used to represent certain natural language grammars to facilitate parsing.
Options: Tree Network,    Star Network,    Transition Network,    Complete Network

Ans:C ,C

2.The following
Options: (A)Start? Fetch next instruction? Execute Instruction ? Halt, represents (B) Instruction cycle with interrupt (C) Instruction cycle without interrupt (D) Instruction cycle with two interrupts (E) None of these. 3

Ans:32. (C),32. (C)

Which device can be used to store charge?
Options: Transistor,    Diode,    Capacitor,    Resistor


. A set of rods where numbers were carved and used for multiplication and division aids is known as

Options: A) Pascaline B) Napier’s Bones C) Stepped Reckoner D) Slide Rule


Detected money errors are corrected with
Options: debit entries,    credit entries,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C

Which layer 1 devices can be used to enlarge the area covered by a single LAN segment? Switch NIC Hub Repeater RJ45 transceiver
Options: 1 only,    1 and 3,    3 and 4,    5 only

Ans:C ,C

Ozone holes are more pronounced at the
Options: NA


'Dizzy' is the nickname of what Australian player?
Options: Adam Gilchrist,    Jason Gillespie,    Glenn McGrath,    Brett Lee


. The command used to create logical drive for specific location of disk
Options: a. Fdisk b. Format c. Subst d. All of the above

Ans: c, c

4. bhaarat kee mukhy bhoomi ka dakshinatam kinaara kaunasa hai ?
Options: NA

Ans: kanyaakumaaree, kanyaakumaaree

The computer code for the interchange of information between terminals is
Options: ASCII,    BCD,    EBCDIC,    All of the above

Ans:A ,A

The major geological events of the Palaeozoic era include
Options: Caledonian mountain rise, life comes ashore,    Appalachians and Central European mountains come up,    both (a) and (b),    None of the above


What was the purpose of establishment of NATO?
Options: To maintain and develop individual and collective capacity to resist armed attack,    To defend economic and trade interests of the developing nations of the world,    TO provide collective defence and economic cooperation in south-east Asia,    None of the above


In SQL, the command(s) is(are) used to create an index for a table or cluster
Options: CREATE INDEX,    MODIFY INDEX,    SET INDEX TO FILE,    All of the above

Ans:A ,A

Which of the following is not true of the conversion phase of the development life cycle?
Options: the user and systems personnel must work closely together.,    steps must be taken to phase out the old system,    documentation should be emphasized,    the non machine components of the system should be considered

Ans:C ,C

. You can install fonts from
Options: a. Add from control program b. Font setup files c. Font .ext files d. All of above

Ans:3 – d ,3 – d

The complexity of merge sort algorithm is
Options: A)O(n) b.O(log n) c.O(n2) d.O(n log n)


. Assembly language started to be used from
Options: A) first generation computers B) second generation computers C) third generation computers D) fourth generation computers


Which of the following electronic component is not found in ordinary ICs?
Options: diodes,    resistors,    transistors,    inductors

Ans:D ,D

1st battle of pannipat was fought between

Ans:ibrahim lodhi and babur,ibrahim lodhi and babur