. Which of the following syntax is correct regarding to SUM function in Excel?

Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,

More MS-Excel Related questions:

What SQL command can be used to add columns to a table?
Options: MODIFY TABLE TableName ADD COLUMN ColumnName,    MODIFY TABLE TableName ADD ColumnName,    ALTER TABLE TableName ADD COLUMN ColumnName,    ALTER TABLE TableName ADD ColumnName

Ans:D ,D

The watershed between India and Myanmar is formed by
Options: the Naga hills,    the Garo hills,    Khasi hills,    the Jaintia hills


1.Artificial intelligence is
Options: (A)It uses machine-learning techniques. Here program can learn from past experience and adapt themselves to new situations (B) Computational procedure that takes some value as input and produces some value as output. (C) Science of making machines performs tasks that would require intelligence when performed by humans (D) None of these 1

Ans:11. (C),11. (C)

Reproductive cells in human beings are produced
Options: in greater numbers for a longer period of time in the male,    for a longer period in the female than in male,    in equal number in both sexes,    in greater numbers by the female than by the male


The Primary job of the operating system is A)  Manage Commands B)  Manage Users         C)  Manage Programs D)  Manage Resources

Ans:– D ,

vitaamin k
Options: NA

Ans: 92. hindee divas kab manaaya jaata hai ?, 92. hindee divas kab manaaya jaata hai ?

Which of the following is not process states?
Options: New B. Running C. Ready D. Finished

Ans:– D ,

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

Ans:E ,E

MISA stands for
Options: Maintenance of Internal Security Act,    Multinational Internal Society Authority,    Movement for Indian System Act,    None of the above


Sound travels with a different speed in media. In what order does the velocity of sound increase in these media?
Options: Water, iron and air,    Iron, air and water,    Air, water and iron,    Iron, water and air


This African-American woman physical therapist worked with soldiers disabled in World War II. She invented a device that helped the disabled to eat by delivering food through a tube to a mouthpiece.
Options: Bessie Blount,    Marjorie Joyner,    Mae Jamison,    Beulah Henry


. You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
Options: a. Insert b. Copy c. Undo d. Replace

Ans:– c,– c

In SQL, which command(s) is(are) used to enable/disable a database trigger?
Options: MODIFY USER,    CHANGE USER,    ALTER TRIGGER,    All of the above

Ans:C ,C

If you want all of the white cats grouped together in the database, you need to sort by ________.
Options: Color, then Gender B. Pet Type, then Color C. Pet Type, then Gender D. Color, then Pet Name

Ans:– B ,

When was Zoroaster, the founder of Zoroastrianism born in Media(Iran)?
Options: 2000 BC,    660 BC,    1075 BC,    740 BC


A medium access control technique for multiple access transmission media is
Options: Aloha,    Amplitude,    Angle modulation,    Attenuation

Ans:A ,A

who made Jagatkhana and Swarghat
Options: vijay chand, heera chand, jai chand, jagat singh

Ans:B,Heera Chand

What will be the output of the program in DOS (Compiler - Turbo C)? #include<stdio.h> double i; int main() { (int)(float)(char) i; printf("%d", sizeof((int)(float)(char)i)); return 0; }
Options: 1,    2,    4,    8

Ans:B ,B

where is state museum
Options: kangra, shimla, bilaspur, hamirpur, kullu


The members of a State Commission can be removed by the
Options: governor on a report by the Supreme Court,    governor on a resolution passed by Parliament,    president on a report by the Supreme Court,    president on a resolution passed by Parliament


What is the output of the program #include<stdio.h> int main() { struct emp { char name[20]; int age; float sal; }; struct emp e = {"Tiger"}; printf("%d, %f\n", e.age, e.sal); return 0; }
Options: 0, 0.000000,    Garbage values,    Error,    None of above

Ans:A ,A

. What does the expression [detail] ! [product] * 1.30 do?
Options: a. multiplies the contents of detail and product fields by 1.3 b. First divides detail by product and then multiplies by 1.3 c. multiplies the contents of detail in the product table by 1.3 d. multiplies the contents of product in the detail table by 1.3

Ans:– d,– d

The monitor of a computer is connected to it by a
Options: Wire,    Cable,    Bus,    Line driver

Ans:B ,B

. To change the screen saver you can go from
Options: a. Control panel display b. Right click in desktop and properties c. Both of above d. None of these

Ans:0 – c ,0 – c

How many bit code is used by Murray code for TELEPRINTER machines.
Options: 4,    5,    9,    25


8.Risk Management is
Options: (A)Here each identified risk is analyzed and prioritized (B) It begins after all hazards are identified. For each hazard, the outcome of the risk assessment process is a statement of acceptability. (C) The anticipate risks which night affect the project schedule or the quality of the software being developed and to take action to avoid these risks. (D) None of these 22

Ans:228. (C),228. (C)

To conquer and annex Peshawar and Punjab, Mahmud of Ghazni defeated
Options: Ghurids,    Arabs,    Karkotakas,    Hindushahis


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C ,C

1.Fault is
Options: (A)It is the process of modifying the state space of the system so that the effects of the fault are minimized and system can continue in operation in some degraded state. (B) Capacity of a system or component to continue normal operation despite the presence of hardware or software faults. (C) It is the widely used hazard technique (D) Incorrect step, process, or data definition in a computer program 18

Ans:181. (D),181. (D)

What is the circumference of table tennis ball?
Options: 3.71-3.82 cm,    4.72-4.82 cm,    2.72-2.82 cm,    None of the above


_____ use standardized symbols to represent an algorithm.
Options: Flowcharts,    Flow diagrams,    IPO charts,    Pseudocharts

Ans:A ,A

. What is an intersection of a row and a column?
Options: a. Form b. Cursor c. Cell d. Record

Ans:– c,– c

The tropical cyclones do not occur to the equator because of
Options: weak coriolis force,    light and variable width,    excessive humidity,    connective activity


10. kaagaj ka aavishkaar kis desh mein hua ?
Options: NA

Ans: cheen, cheen

9.RDBMS stands for
Options: (A)Relational Database Management System (B) Relation Data Module System (C) Right Data Base Management System (D) None of the above 5

Ans:49. (A),49. (A)

. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a

Which of the following layer of OSI model also called end-to-end layer?
Options: Presentation layer B. Network layer C. Session layer D. Transport layer

Ans: – D ,

Which of the following is directry controlled from a keyboard.
Options: Card punch,    Punched paper tape,    Magnetic disk,    Magnetic tape

Ans:A ,A

In which of the following, each data item contains at most 2 points
Options: List structure,    LISP,    List sorting,    List head

Ans:B ,B

87. sanyukt raashtr sangh ke vartamaan mahaasachiv kaun hai ?
Options: NA

Ans: baan-kee-moon , baan-kee-moon

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
Options: IDMS,    DB2,    dBase-II,    R:base

Ans:B ,B

Options: NA

Ans: 838. panchaayat sadasy banane ke lie nyoonatam aayu kitanee honee chaahie?, 838. panchaayat sadasy banane ke lie nyoonatam aayu kitanee honee chaahie?

Suppose the peak value of a sinusoidal voltage is 50 V. What is the rms value?
Options: 37.4 V,    35.4 V,    38.74 V,    30.4 V

Ans:B ,B

Using a microcomputer as a controller allows:
Options: faster cycle time,    simpler mechanical hardware,    more self diagnostics of the machine operation,    All of the above

Ans:D ,D

Who won the maximum number of gold medals in Hiroshima Asian Games?
Options: China,    India,    South Korea,    Japan


The landmass of which of the following continents is the least?
Options: Africa,    Asia,    Australia,    Europe


0.In Microsoft PowerPoint which of the following should you do to bring a bullet back to a previous level?
Options: (A)Press the shift + tab keys (B) Press the shift key (C) Press the enter key (D) Press the tab key 13

Ans:130. (A),130. (A)

3.Binary search algorithm cannot be applied to
Options: (A)Sorted binary trees (B) Sorted linear array (C) Pointer array (D) Sorted linked list

Ans:3. (D),3. (D)

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
Options: Network database,    Relational database,    Distributed database,    Hierarchical database

Ans:D ,D

19. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.
Options: a. 1-inch left, right, top, and bottom b. 1.25-inch left, right, top, and bottom c. 1.25-inch left and right margins and 1-inch top and bottom d. 1-inch left and right margins and 1.25-inch top and bottom

Ans:– C ,– C