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:

Pictographs, called _____ help systems to be more user friendly.
Options: people,    icons,    information system,    on-line

Ans:B ,B

A section of code that may only be executed by one process at any one time is
Options: CPM,    Critical resource,    Critical region,    Gray code

Ans:C ,C

6.Software migration and evolution is
Options: (A)Time-period that begins when a software product is conceived and ends when the software is no longer available for use. (B) Adaptive maintenance, performed to make a computer program usable in a changed environment. (C) A simplified description of a software process that is presented from a particular perspective. (D) None of these 25

Ans:256. (B),256. (B)

In which addressing mode the operand is given explicitly in the instruction?
Options: absolute mode,    immediate mode,    indirect mode,    index mode

Ans:B ,B

6.COUNT command is used to
Options: (A)Count the number of data fields in an active database file (B) Count the number of data files which are active (C) Count the records which are updated (D) Count the number of records in an active database file 2

Ans:26. (D),26. (D)

620. pandit ravishankar ka sambandh kis vaady yantr se hai?
Options: NA

Ans: sitaar, sitaar

An Excel Workbook is a collection of …….
Options: Workbooks B. Worksheets C. Charts D. Worksheets and Charts

Ans:– D ,

Sales invoking is a:
Options: pre-sales activity,    job of finance department,    post-sales activity,    All of the above

Ans:A ,A

Germany signed the Armistice Treaty on ____ and World War I ended
Options: January 19, 1918,    May 30, 1918,    November 11, 1918,    February 15, 1918


95. What is the shortcut key to Update Formula in a table?
Options: a. F9 b. Alt + F9 c. Ctrl + F9 d. Shift + F9

Ans:–  A ,–  A

The term which refers to the total amount of sales made by a firm in one year or the total amount of money changing hands in business, is
Options: trade gap,    turnover,    reserves,    referendum


After you have verified that TCP/IP is installed correctly, what is the next step in verifying the TCP/IP configuration?
Options: Ping the broadcast address,    Ping the Microsoft Web site,    Ping a distant router.,    Ping the address of the local host

Ans:D ,D

9.In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
Options: (A)& (ampersan(D) (B) = (equal sign) (C) (space) (D) All of the above 7

Ans:69. (A),69. (A)

735. daas kaipital kisakee rachana hai?
Options: NA

Ans: kaarl maarks, kaarl maarks

. Which of the following is correct full form of BCD?
Options: A) Binary Coded Decimal B) Bit Coded Decimal C) Binary Coded Digit D) Bit Coded Digit


The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
Options: a. relationship b. Join c. Query d. None of these

Ans:dash; a,dash; a

Which of the following might be used to convert high-level language instructions into machine language?
Options: system software,    applications software,    an operating environment,    an interpreter

Ans:D ,D

1.Parallelism is
Options: (A)General class of approaches to a problem. (B) Performing several computations simultaneously (C) Structures in a database those are statistically relevant. (D) Simple forerunner of modern neural networks, without hidden layers. 8

Ans:81. (B),81. (B)

Which is India's largest library with a collection of over 190 million volumes of reading and information material?
Options: National Book Trust,    National Library,    National Educational Resource Centre,    None of the above


. Gridlines
Options: a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. a, b and c

Ans:– d,– d

A supertype/subtype hierarchy is which of the following?
Options: Each subtype has only one attribute.,    Each supertype has only one attribute.,    Each subtype has only one supertype.,    Each supertype has only one subtype.

Ans:C ,C

The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B ,B

Which layer 4 protocol is used for a Telnet connection?
Options: IP,    TCP,    TCP/IP,    UDP

Ans:B ,B

. How do you display current date and time in MS Excel?
Options: a. date () b. Today () c. now () d. time ()

Ans:– c,– c

Which of the following devices would be classified as a robot by the Robot Institute of America?
Options: Automobile,    Pick-and-place manipulator,    Artificial hand,    All of the above

Ans:B ,B

. We can remove a relationship defined between two tables by
Options: a. From edit menu choose delete relationship b. Select the relationship line and press delete c. Choose delete option from relationship menu d. All of above

Ans:4 – b ,4 – b

'Kandla' is situated on the Gulf of Kachh is well known for which of the following?
Options: Export Processing Zone,    Centre for Marine Food products,    Cutting and Polishing of diamonds,    Ship breaking industry


9.What is the purpose of the page field on a pivot table report?
Options: (A)It creates a new page for each type of data (B) It allows the data within the the Pivot Table report to be filtered (C) It displays a title for the Pivot Table report (D) None of the above 13

Ans:129. (B),129. (B)

6.A remote batch-processing operation where data is solely input to a central computer would require
Options: (A)telegraph line (B) simplex lines (C) mixed-band channel (D) none of these Answer Sheet

Ans:176. (B),176. (B)

Information is _____ when it is useful in making a decision.
Options: relevant,    management by exception,    predictive reports,    control

Ans:A ,A

The theory of utilitarianism was expounded by
Options: Jeremy Bentham (1748-1836),    James Mill(1773-1839),    Henry Sidgwick (1838-1900),    All of the above


0.Software metric is
Options: (A)It is the general process of changing system after it has been delivered. The changes can be to correct coding error to correct design error, or adding new components to system. (B) It is concerned with deriving a numeric value for some attribute of a software product or a software process. (C) It is any type of measurement, which relates to software system, process and related documentation. (D) None of these 26

Ans:260. (A),260. (A)

In which year the first operating system was developed
Options: a. 1910 b. 1940 c. 1950 d. 1980

Ans:Correct Answer: c ,Correct Answer: c

The manager of inventory would most likely be found in the
Options: finance function,    marketing function,    manufacturing function,    information systems function

Ans:C ,C

who was founder of thiyog riyasat
Options: shivram chand, jai chand, hari chand, datar chand

Ans:jai chand,jai chand

1.What are the columns in a Microsoft Access table called?
Options: (A)Rows (B) Fields (C) Cells (D) Records 15

Ans:151. (B),151. (B)

A wrist grounding strap contains which of the following:
Options: Surge protector,    Capacitor,    Voltmeter,    Resistor

Ans:D ,D

157. maada enaaphleej machchhar ke kaatane se kaunasa rog hota hai ?
Options: NA

Ans: maleriya , maleriya

How many wickets did Zaheer Khan pick up in his ODI debut?
Options: 0,    3,    5,    2


Large collections of files are called
Options: fields,    records,    databases,    file system

Ans:C ,C

who was last rular of guler riyasat
Options: shyam singh, durga singh, bhoop singh, umed singh

Ans:bhoop singh,bhoop singh

7.In Excel which of the following is a correct order of precedence in formula calculation?
Options: (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 15

Ans:157. (D),157. (D)

.  To open the existing presentation, press
Options: Ctrl + L B. Ctrl + N C. Ctrl + A D. Ctrl + O

Ans: – D ,

971. chaabhee bharee ghadee mein kaunasee oorja hotee hai?
Options: NA

Ans: sthitij oorja, sthitij oorja

Everything computer does is controlled by its
Options: RAM,    ROM,    CPU,    Storage devices

Ans:C ,C

where is forest training centre
Options: kangra, solan, bilaspur, hamirpur, kullu


To sort the results of a query use:
Options: SORT BY.,    GROUP BY.,    ORDER BY.,    None of the above is correct.

Ans:C ,C

3.A data item, which is not broken down into smaller units, is
Options: (A)Data element (B) Elementary data item (C) Data entry (D) Database management 10

Ans:103. (B),103. (B)

Why Drop Caps are used in document?
Options:  A) To drop all the capital letters, B) To automatically begin each paragraph with capital letter, C) To begin a paragraph with a large dropped initial capital letter, D) None of above,


Individuals who intend to pursue a career as an information-system manager should have:
Options: technical expertise in information systems,    human-relations skills,    ability to communicate in written form,    two of the above

Ans:E ,E