. How to specify cell range from A9 to A99 in Excel?

Options: (A9, A99) B. (A9 to A99) C. (A9 : A99) D. (A9 – A99)

Ans:– C ,

More MS-Excel Related questions:

Which of the following is an advantage to using fiber optics data transmission?
Options: resistance to data theft,    fast data transmission rate,    low noise level,   All of the above

Ans:D,All of the above

6.In secondary storage management, bit table, for each block on disk a vector contains
Options: (A)One bit each block (B) Two bit each block (C) Three bit each block (D) Four bit each block. 18

Ans:186. (A),186. (A)

What is the first octet range for a class B IP address?
Options: 128 - 255,    1 - 127,    192 - 223,    128 - 191

Ans:D ,D

Which field type can store photos?
Options: a. Hyperlink b. OLE c. Both of these can be used d. Access tables can’t store photos

Ans:ndash; b,ndash; b

.   A file which contains readymade styles that can be used for a presentation is called
Options: a. Auto style b. Template c. Wizard d. Pre-formatting

Ans:8 – B ,8 – B

Which of the following is used to insure the high quality of computer output?
Options: computer output microfilm,    output controls,    voice output systems,    liquid crystal display


The president addresses both the Houses of Parliament assembled together
Options: during emergency session summoned for the purpose,    every session,    first session after each general election and the first session of each year,    any session


In LISP, the function X (x). (2x+l) would be rendered as
Options: (lambda (x) (+(*2 x)l)),    (lambda (x) (+1 (* 2x),    (+ lambda (x) 1 (*2x)),    (* lambda(x) (+2x1)

Ans:A ,A

Which one of the following is termed a combination input-output device?
Options: VDT,    Keyboard,    Printer,    Laser Jet


Which of the following is used as storage locations both in the ALU and the control section of a computer?
Options: accumulator,    register,    adder,    decoder

Ans:B ,B

Krishan Dutt Sultan Puri


Coding and testing are done in which manner.
Options: ad hoc,    cross-sectional,    bottom-up,    top-down

Ans:D ,D

. What PowerPoint feature will you use to apply motion effects to different objects of a slide?
Options: a.  Slide Transition b.  Slide Design c.  Animation Objects d.  Animation Scheme

Ans:3 – D ,3 – D

. Disk label name can be up to ….characters
Options: a. 8 b. 9 c. 11 d. 255

Ans:9 – c ,9 – c

Options: NA

Ans: 919. 42ven sanshodhan dvaara prastaavana mein kaun-se shabd jode gae?, 919. 42ven sanshodhan dvaara prastaavana mein kaun-se shabd jode gae?

Which of the following is correct regarding Aggregate functions?
Options: it takes a list of values and return a single values as result B. it takes a list of values and return a list of values as result C. it takes a single value and returns a list of values as result D. it takes a single value and returns a single value as result

Ans:– A ,

The two main components of the CPU is
Options: Control unit and registers,    Control unit and ALU,    Registers and main memory,    ALU and bus

Ans:B ,B

In MS-DOS 5.0, which is the number that acts as a code to uniquely identify the software product?
Options: MS,    DOS,    MS DOS,    5.0

Ans:D ,D

. Formatting a cell in Number format you can’t set
Options: a. Decimal Places b. Use 1000 separator c. Negative numbers d. Currency Symbol

Ans:– d,– d

Which command is used to remove a table from the database in SQL?

Ans:B ,B

The highest mountains on earth namely Mount Everest, K2, Kanchenjanga are located in
Options: the greater Himalayas,    the Lesser Himalayas,    the outer Himalayas,    None of the above


For every relationship, how many possible sets of minimum cardinalities are there?
Options: Two,    Three,    Four,    Six

Ans:C ,C

. Which command permits to see the directory structure in DOS?
Options: a. Display structure b. Tree c. Dir/all d. All of above

Ans:0 – b ,0 – b

Which of the following is a technique for hiding the internal implementation details of an object?
Options: Encapsulation,    Polymorphism,    Inheritance,    All of the above.

Ans:A ,A

. The operating system is the most common type of .... Software
Options: a. Communication b. Application c. System d. Word processing software

Ans: c, c

. Which computer memory is used for storing programs and data currently being processed by the CPU?

Options: A) Mass memory B) Internal memory C) Non-volatile memory D) PROM


Which elements of a worksheet can be protected from accidental modification?
Options: Contents B. Objects C. Scenarios D. All of the above

Ans:– D ,

. Command Interpreter is also known as
Options: a. Prompt b. Shell c. Command d. DOS Prompt

Ans:0 – b ,0 – b

. The modern keyboard typically has __________ Function keys.
Options: a. 10 b. 12 c. 14 d. 16

Ans:8 – b ,8 – b

indira gandhi sports complex is situated in which district in himachal?
Options: NA


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

Which of the following items is not used in Local Area Networks (LANs)?
Options: Computer,    Modem,    Printer,    Cable

Ans:B ,B

who was founder of sayad dynasty?

Ans:khijra khan,

Which of the following terms is the most closely related to main memory?
Options: nonvolatile,    permanent,    control unit,    temporary

Ans:D ,D

Programmers use _____ to organize and summarize the results of their problem analysis.
Options: Flowcharts,    Input charts,    IPO charts,    Output charts

Ans:C ,C

Glass is made of the mixture of
Options: quartz and mica,    sand and silicates,    salt and quartz,    sand and salt


A lock that allows concurrent transactions to access different rows of the same table is known as a
Options: Field-level lock B. Row-level lock C. Table-level lock D. Database-level lock

Ans:– A ,

42 ve
Options: NA

Ans: 386 gotaakhor paanee jo gaison jo le rahe hain ka ek mishran hai ke tahat saans lene ke lie?, 386 gotaakhor paanee jo gaison jo le rahe hain ka ek mishran hai ke tahat saans lene ke lie?

Which of the following are not likely to be found on a PC main circuit board
Options: RAM chips,    Microprocessor chips,    ROM chips,    LCD clocks

Ans:D ,D

The Harmattan is
Options: cool, extremely dry wind that forms over the Sahara and blows westward or south-westward to the African coast,    wind that blows during the dry season from December to February,    tertiary wind that carry great quantities of fine dust from the Sahara,    All of the above


What is a brand?
Options: A) The name of companies that made computers B) The name of product a company gives to identify its product in market C) A name of class to indicate all similar products from different companies D) All of above


. The __________ performs document tracking.
Options: a. distributed application b. enterprise software c. Oracle software d. EDM software

Ans:2 – d ,2 – d

1.In Microsoft PowerPoint the following is not an option when printing handouts
Options: (A)Six slides per page (B) Five slides per page (C) Three slides per page (D) Two slides per page 2

Ans:21. (B),21. (B)

Which is part of a computer system, enables human operators to communicate with the computer.
Options: Console,    Keyboard,    Printer,    CPU

Ans:A ,A

Lala Lajpat Rai is the author of the book
Options: India Divided,    Unhappy India,    Mother India,    Hind Swaraj


. Workgroup means
Options: a. Computer in network b. Individual user c. Connection d. All of the above

Ans:5 – a ,5 – a

Which of the following can be use as slide background?
Options: Gradient B. Texture C. Picture D. All of the Above

Ans:– D ,

The core of an electromagnet is said to be in saturation when:
Options: the core is permitted to move freely within the coil,    an increase in current through the coil causes no further increase in the mmf,    frequent changes in the direction of current through the coil causes heating effects in the core material,    changing the polarity of the current in the coil changes the polarity of the magnetic field around the core

Ans:B ,B

. Which of the following is NOT possible when printing Forms?
Options: a. Print page 1, 3, and 5 b. Print pages 1 through 5 c. Print selected records d. Print only the third record

Ans:5 – a ,5 – a

Which of the following activities, does not belong to the Implementation phase of the SDLC?
Options: File conversion,    Program testing,    User training,    All of the above

Ans:B ,B