What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)


Options: An absolute cell address is created. B. Cell address will change when it is copied to another cell. C. The sheet tab is changed. D. The status bar does not display the cell address.

Ans:– A ,

More MS-Excel Related questions:


The great Victoria Desert is located in
Options: Canada,    West Africa,    Australia,    North America

Ans:C,C


What was the total number of UNIVAC-I sold eventually and by which company?
Options: A -30 British Tabulating Machine Co. (BTM), B -40 International Business Machines (IBM), C - 48 Remington Rand, D- 40 International Computer Ltd. (ICL)

Ans:C ,48


. “Ctrl + Left Arrow” is used to
Options: Moves the cursor beginning of the Line B. Moves the cursor one word left C. Moves the cursor one paragraph up D. Moves the cursor one paragraph down

Ans:– B ,


Deficit financing leads to inflation in general, but it can be checked if
Options: government expenditure leads to increase in the aggregate supply in ratio of aggregate demand,    only aggregate demand is increased,    all the expenditure is denoted national debt payment only,    All of the above

Ans:D,D


516. uparaashtrapati ka chunaav kaun karata hai?
Options: NA

Ans: sansad sadasy, sansad sadasy


The shape of earth is
Options: sphere,    oblate spheroid,    circular,    spheroid

Ans:B,B


977. ilektrik heetar kee kundalee kis dhaatu se banaee jaatee hai?
Options: NA

Ans: naikrom, naikrom


The uppermost epoch of the Neogene period is
Options: the Pliocene epoch,    the Pleistocen epoch,    the Miocene epoch,    the Oligocene epoch

Ans:A,A


The umbra is
Options: the inner portion of the moon's shadow,    formed by tangents to the sun and moon,    both (a) and (b),    None of the above

Ans:C,C


639. bhaarat kee pahalee bolatee philm kaunasee thee?
Options: NA

Ans: aalamaara, aalamaara


The first BRICS film festival was organised in
Options: NA

Ans:New Delhi,New Delhi


. The
Options: A) Analog Computers B) Digital Computers C) Hybrid Computers D) Mainframe Computers

Ans:C,C


Aggregation is which of the following?
Options: Expresses a part-of relationship and is a stronger form of an association relationship.,    Expresses a part-of relationship and is a weaker form of an association relationship.,    Expresses an is-a relationship and is a stronger form of an association relationship.,    Expresses an is-a relationship and is a weaker form of an association relationship.

Ans:A ,A


Which of the following commands is used to rename a file?
Options: rename,    remove,    mv,    ren

Ans:C ,C


The president can expend out of the Contingency Fund of India
Options: only with the approval of the Parliament,    without the approval of the Parliament,    only in the case of the national calamities,    None of the above

Ans:B,B


Which of the following is the largest manufacturer of Hard Disk Drives?
Options:  IBM B.  Seagate C.  Microsoft D.  3M

Ans:– B ,


306. madhumakkhee paalan kya kahalaata hai?
Options: NA

Ans: epeekalchar , epeekalchar


What does that acronym VGA stand for?
Options: Extended Graphics Adapter,    Enhanced Graphics Array,    Video Graphics Array,    Color Graphics Array

Ans:C ,C


9.Main memory is referred as
Options: (A)Virtual memory (B) Real memory (C) A and B both (D) None of these. 9

Ans:89. (B),89. (B)


After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Options: a. You need to delete the whole tablThere is no method to remove a particular field only. b. Delete all the fields from third downwards and reenter the required fields again. c. Select the third column in datasheet view then  Delete d. Select the third row in table design view then Delete

Ans:ndash; d,ndash; d


When operating below its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated above its resonant frequency,    purely resistive circuit

Ans:B ,B


5.The Least Recently Used (LRU) policy
Options: (A)Replaces the page in memory that has not been referenced for the least time. (B) Replaces the page in memory that has not been referenced for the longest time. (C) Replaces the page in memory in round robin fashion. (D) None of these. 10

Ans:105. (B),105. (B)


. What was the nick name of the computer used by the Americans in 1952 for their H-bomb project?

Options: A) ENIAC B) EDSAC C) MANIAC D) UNIVAC

Ans:C,C


. ALU is
Options: A) Arithmetic Logic Unit B) Array Logic Unit C) Application Logic Unit D) None of above

Ans:0-A,0-A


Zawar (Rajasthan) is famous for
Options: ship manufacturing,    zinc mines,    salt,    major port

Ans:B,B


0.Sub-systems in a system are
Options: (A)Independent systems that compromises the system (B) Dependent systems that compromises the system (C) A and B both true (D) None of these 9

Ans:90. (A),90. (A)


A variable that has no physical meaning and is used to obtain an initial basic feasible solution to a linear programming problem is known as:
Options: basis,    algorithm,    artificial variable,    basic variable

Ans:D ,D


293. bhaarat mein nirmit pratham kampyootar ka kya naam hai?
Options: NA

Ans: siddhaarth, siddhaarth


A partitioned data set is most used for
Options: a program or source library,    storing program data,    storing backup information,    storing ISAM files

Ans:A ,A


The groundwater can become confined between two impermeable layers. This type of enclosed water is called
Options: artesian,    artesian well,    unconfined groundwater,    confined groundwater

Ans:A,A


. When a hyperlink is created, Word formats the Web address as _____.
Options: a. italicized and colored red b. italicized and colored blue c. underlined and colored red d. underlined and colored blue

Ans: – D , – D


. Find can be used to
Options: a. Locate a program b. Locate a document c. Locate a network computer d. All of above

Ans:7 – d ,7 – d


Who was the 1st president of BCCI ( Board of Control for Cricket in India )?
Options: R.E. Grant Govan,    Dr. Maharajkumar Sir Vijaya Ananda,    Sikandar Hyat Khan,    Anthony S. D'Mello

Ans:A,A


609. thal sena divas kab manaaya jaata hai?
Options: NA

Ans: 15 janavaree, 15 janavaree


Assume integer is 2 bytes wide. What will be the output of the following code? #include<stdio.h> #include<stdlib.h> #define MAXROW 3 #define MAXCOL 4 int main() { int (*p)[MAXCOL]; p = (int (*) [MAXCOL])malloc(MAXROW *sizeof(*p)); printf("%d, %d\n", sizeof(p), sizeof(*p)); return 0; }
Options: 2, 8,    4, 16,    8, 24,    16, 32

Ans:A ,A


2.In Excel autofill feature
Options: (A)Extends a sequential series of data (B) Automatically adds range of cell values (C) Applies a boarder around the selected cells (D) None of the above 9

Ans:92. (B),92. (B)


. In a PowerPoint presentation
Options: a.  Sound clips can be inserted but not movie clips b.  Movie clips can be inserted but not sound clips c.  Both cannot be inserted d.  Both can be inserted

Ans:9 – D ,9 – D


5.In Microsoft PowerPoint the term used when you press and hold the left mouse key and move the mouse around the slide
Options: (A)Highlighting (B) Dragging (C) Selecting (D) (B) and (C) both true 4

Ans:45. (D),45. (D)


where is panch vaktra mandir in Hp
Options: kinnaur , lahul, kullu, mandi

Ans:mandi,mandi


Which is a non-standard version of a computing language?
Options: PROLOG,    APL,    Army,    PL/1

Ans:C ,C


Velocity of wind is measured by
Options: speedometer,    tachometer,    anemometer,    audiometer

Ans:C,C


Saddle Peak National Park
Options: Karnataka,Kerala,Tripura,Andaman and Nicobar Islands

Ans:Andaman and Nicobar Islands,


origin of yamuna river in HP
Options: yamnotri, peer panjal, bada bhangaal, baralacha darra

Ans:yamnotri,yamnotri


The first cell in EXCEL worksheet is labeled as
Options: AA B. A1 C. Aa D. A0

Ans:– B ,


The owner of Star TV is
Options: Rupert Murdoch,    Tata Group,    Richard Attenborough,    George Lucas

Ans:A,A


It is a query that when run displays its own dialog box prompting you for information, such as
Options: a. Select b. crosstab c. Parameter d. Append

Ans:ndash; c,ndash; c


7.Learning is
Options: (A)The process of finding the right formal representation of a certain body of knowledge in order to represent it in a knowledge-based system (B) It automatically maps an external signal space into a system’s internal representational space. They are useful in the performance of classification tasks. | 121 (C) A process where an individual learns how to carry out a certain task when making a transition from a situation in which the task cannot be carried out to a situation in which the same task under the same circumstances can be carried out. (D) None of these 5

Ans:57. (C),57. (C)


How many layers does OSI Reference Model has?
Options:  4 B.  5 C.  6 D.  7

Ans:– D ,


How many bytes are there in 1011 1001 0110 1110 numbers?
Options: 1,    2,    4,    8

Ans:B ,B


Texas Instruments Incorporated produces a low-cost LISP machine called:
Options: The Computer-Based Consultant,    The Explorer,    Smalltalk,    The Personal Consultant

Ans:B ,B

www.000webhost.com