. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?


Options: =A1 + “@” + B1 B. =A1 # “@” # B1 C. =A1 & “@” & B1 D. =A1 $ “@” $ B1

Ans:– C ,

More MS-Excel Related questions:


Which is the oldest monuments?
Options: Qutub Minar,    Ajanta Caves,    Khajurah,    Taj Mahal

Ans:B,B


The main properties of cosmic ray particles are
Options: its electric charge,    its rest mass,    its energy,    All of these are its properties

Ans:D,D


who made Tank Sanghwana and was made by whome
Options: heera chand, jai chand, jagat singh, Vijay chand

Ans:D,Vijay chand


. The personal computer industry was started by
Options: A) IBM B) Apple C) Compaq D) HCL

Ans:A,A


1.Use of Email instead of post & telegraph is due to
Options: (A)Technology changes (B) Requirement changes (C) Users access (D) All the above 6

Ans:61. (D),61. (D)


A distributed data processing configuration in which all activities must pass through a centrally located computer is called a:
Options: ring network,    spider network,    hierarchical network,    data control network

Ans:B ,B


. You can check the conditions against __________ when applying conditional formatting
Options: a. Cell value b. Formula c. Both of above d. None of above

Ans:– c,– c


A NOR gate recognizes only the input word whose bits are _____
Options: 0's and 1's,    1's,    0's,    0's or 1's

Ans:C ,C


What will be the output of the program (sample.c) given below if it is executed from the command line (turbo c under DOS)? cmd> sample Good Morning /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%d %s", argc, argv[1]); return 0; }
Options: 3 Good,    2 Good,    Good Morning,    3 Morning

Ans:A ,A


When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995

Ans:A ,A


Repeaters are often used on an 802.3 network to help strengthen the signals being transmitted. As with the length of segments and the number of segments, a limit exists as to how many repeaters can be used between any two nodes. What is the maximum number of repeaters that can be used?
Options: Five,    Two,    Four,    Six

Ans:C ,C


What is the main reason the OSI model was created?
Options: To create a layered model larger than the DoD model.,    So application developers can change only one layer's protocols at a time.,    So different networks could communicate.,    So Cisco could use the model.

Ans:C ,C


1.A policy in memory management referred as clock policy because one can visualize the page frames as laid out in
Options: (A)Straight line (B) Rectangle (C) Circle (D) Square 11

Ans:111. (C),111. (C)


7.Physical address (absolute address) in memory partitioning is
Options: (A)Actual location in main memory (B) A reference to memory location independent of current assignment (C) A logical address (D) None of these. 6

Ans:67. (A),67. (A)


Pipeline implement
Options: A . fetch operand B . calculate operand C . execute instruction D . all of above

Ans:D, all of above


To be successful in implementing DSS, organizations should have the following characteristics except:
Options: a well-controlled data-processing system,    willingness to commit dollars and personnel to the project.,    education and training by the organization,    powerful central computer groups to initiate and manage system projects

Ans:D ,D


Point out the correct statement which correctly free the memory pointed to by 's' and 'p' in the following program? #include<stdio.h> #include<stdlib.h> int main() { struct ex { int i; float j; char *s }; struct ex *p; p = (struct ex *)malloc(sizeof(struct ex)); p->s = (char*)malloc(20); return 0; }
Options: free(p); , free(p->s);,    free(p->s); , free(p);,    free(p->s);,    free(p);

Ans:B ,B


A bus is a group of _____ carrying digital signals.
Options: wires,    gates,    transistors,    registers

Ans:A ,A


Which of the following provides a storage mechanism for incoming mail but does not allow a user to download messages selectively?
Options: SMTP,    DHCP,    IMAP,    POP3

Ans:D ,D


Which one of the following phrases most accurately describes a purely capacitive circuit?
Options: Resistances provide the only opposition to current flow,    Capacitive reactance provides the only opposition to current flow,    The ac voltage leads the current by 90 degree,    Combinations of resistance and capacitive reactance provide any opposition to current flow

Ans:B ,B


The book 'The Man who knew Infinity' by Robert Kanigel is the biography of
Options: Srinivasa Ramanujan,    Sir C. V. Raman,    Homi Bhabha,    Vikram Sarabhai

Ans:A,A


The Norton current is sometimes called the
Options: Shorted-load current,    Open-load current,    Thevenin current,    Thevenin voltage

Ans:A ,A


What is the IP Address range of APIPA?
Options: 169.254.0.1 to 169.254.0.254 B. 169.254.0.1 to 169.254.0.255 C. 169.254.0.1 to 169.254.255.254 D. 169.254.0.1 to 169.254.255.255

Ans:– C ,


1.Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Options: (A)Option buttons (B) List boxes (C) Text boxes (D) Combo boxes 16

Ans:161. (C),161. (C)


6.Which of the following criterion would find records whose personality field does not equal “Nice”?
Options: (A)<>Nice (B) NOT Nice (C) <>”Nice” (D) IS NOT Nice 9

Ans:96. (C),96. (C)


A Microsoft Windows is .....a(n)
Options: a. Operating system b. Graphic program c. Word Processing d. Database program

Ans:a,a


The _____ provides a path between the CPU and peripheral devices, which are connected via interface cards.
Options: computer,    expansion bus,    memory,    CPU

Ans:B ,B


The monitor power LED is 'on' but the monitor screen is completely dark. The least likely cause of the problem is:
Options: Defect in the computers video circuitry,    Disconnected video cable,    Defective monitor,    System RAM problem

Ans:D ,D


Which one of the following equations most directly determines the amount of current flowing through a resistor when you know the value of the resistor and the voltage drop across it?
Options: E = PR,    E = I2R,    I = E/R,    I = ER

Ans:C ,C


The fact that the same operation may apply to two or more classes is called what?
Options: Inheritance,    Polymorphism,    Encapsulation,    Multiple classification

Ans:B ,B


elbart aaeenstaeen
Options: NA

Ans: 761. vaayuyaan kee khoj kisane kee?, 761. vaayuyaan kee khoj kisane kee?


Who directed the famous TV Serial 'Tandoori Nights'?
Options: Farukh Dhondy,    Jon AMiel,    Zohra Sehgal,    Saeed Jaffrey

Ans:B,B


What do the following declaration signify? int (*pf)();
Options: pf is a pointer to function.,    pf is a function pointer.,    pf is a pointer to a function which return int,    pf is a function of pointer variable.

Ans:C ,C


who was founder of kulloot riyasat
Options: mani pal , jhet pal, gobind pal, jas pal

Ans:vihangam mani pal,vihangam mani pal


317. bhaarat ne pahala paramaanu pareekshan kab aur kahaan kiya tha?
Options: NA

Ans: 14 maee 1974 ko pokharan (raajasthaan) mein, 14 maee 1974 ko pokharan (raajasthaan) mein


gaay aur bhains
Options: NA

Ans: 909. soochana kee us sabase chhotee ikaee ko kya kahate hain jise kampyootar samajh aur proses ka, 909. soochana kee us sabase chhotee ikaee ko kya kahate hain jise kampyootar samajh aur proses ka


What could cause a fixed disk error?
Options: No-CD installed,    Bad RAM,    Slow processor,    Incorrect CMOS settings

Ans:D ,D


To display the list of all the file of the disk you would type
Options: a. DIR b.COPY c. DIR FILES d. DIR AUTOEXEC.BAT

Ans:12 a..  ,12 a.. 


. Which statement is valid about interpreter?
Options: A) It translates one instruction at a time B) Object code is saved for future use C) Repeated interpretation is not necessary D) All of above

Ans:A,A


A Winchester disk is a
Options: Disk Stack,    Removable disk,    Flexible disk,    All of the above

Ans:A ,A


9.In Excel which of the following formulas is not entered correctly?
Options: (A)=10+50 (B) =B7*B1 (C) =B7+14 (D) 10+50 5

Ans:49. (D),49. (D)


When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Options: Security procedure,    Safeguard procedure,    Identification procedure,    Log-on procedure

Ans:D ,D


ML2T-2 is the dimensional formula for
Options: moment of inertia,    pressure,    elasticity,    couple acting on a body

Ans:D,D


. Ctrl + J
Options: Align Justify B. Insert Hyperlink C. Search D. Print

Ans: – A ,


3.In Excel to edit in an embedded excel worksheet object in a word document
Options: (A)Use the excel menu bar and toolbars inside the word application (B) Edit the hyperlink (C) Edit the data in a excel source application (D) Use the word menu bar and toolbars 21

Ans:213. (A),213. (A)


To test the IP stack on your local host, which IP address would you ping?
Options: 127.0.0.0,    1.0.0.127,    127.0.0.1,    127.0.0.255

Ans:C ,C


Interrupts which are initiated by an instruction are
Options: a . internal b . external c . hardware d . software

Ans:9.d,9.d


The invention of the slide rule is attributed to
Options: Babbage,    Oughtred,    Pascal,    Napier

Ans:B ,B


732. ghana pakshee vihaar kahaan sthit hai?
Options: NA

Ans: bharatapur (raajasthaan), bharatapur (raajasthaan)


How can you find rows that do not match some specified condition?
Options: EXISTS,    Double use of NOT EXISTS,    NOT EXISTS,    None of the above is correct.

Ans:B ,B

www.000webhost.com