. Which of the following is correct syntax in Excel?

Options: =IF(LogicalTest, TrueResult, FalseResult) B. =IF(LogicalTest, (TrueResult, FalseResult)) C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Ans:– A ,

More MS-Excel Related questions:

An AI technique that allows computers to understand associations and relationships between objects and events is called:
Options: heuristic processing,    cognitive science,    relative symbolism,    pattern matching

Ans:D ,D

9.In Access press …………………….to Move the selected control to the right (except controls that are part of a layout)
Options: (A)CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 2

Ans:19. (D),19. (D)

Which of the following items would require you t.o comply with EPA disposal guidelines?
Options: Keyboard,    System board,    Power supply,    Battery

Ans:D ,D

The hydrological cycle is a conceptual model that describes
Options: the storage of water between biosphere, hydrosphere, atmosphere and lithosphere,    the movement of water between biosphere, atmosphere, lithosphere and hydrosphere,    both (a) and (b),    None of the above


The northern boundary of the peninsular plateau of Indian runs parallel to the Ganga and the Yamuna from Rajmahal hills to a point near
Options: Allahabad,    Delhi,    Gwalior,    Jaipur


You are working with a network that has the network ID, and you require 25 subnets for your company and an additional 30 for the company that will merge with you within a month. Each network will contain approximately 600 nodes. What subnet mask should you assign?
Options:,,,    255,255.248.0

Ans:E ,E

Tab scrolling button
Options: a. Allow you to view a different worksheet b. Allow you to view additional worksheet rows down c. Allow you to view additional worksheet columns to the right d. Allow you to view additional sheets tabs

Ans:#8211; d,#8211; d

Options: NA

Ans: 901. bhaarateey antariksh anusandhaan sangathan (isro) ka mukhyaalay kahaan hai ?, 901. bhaarateey antariksh anusandhaan sangathan (isro) ka mukhyaalay kahaan hai ?

. A ….is a pointing device
Options: a. Monitor b. Mouse c. Keyboard d. None of these

Ans:1 – b ,1 – b

The concept of a general CAD system was that it should provide:
Options: A system for handling user actions.,    A system for the operation of applications programming.,    A set of basic system functions and utilities.,    All of the above

Ans:D ,D

. A series of MS-DOS Commands can be performed by
Options: Typing all the commands Prompt in series by adding hyphen (-) B. Copying all the commands into single Directory C. Creating BAT File D. This is not possible in MS-Dos

Ans:– C ,

India was elected as a President of General Assembly of the United Nations in 1953. Who occupied this office on behalf of India?
Options: S. Radha Krishnan,    Gopalswamy Iyyengar,    V.K. Krishna Menon,    Vijayalakshmi Pandit


Middle-level managers are responsible for making the _____ decisions to allocate resources and establish controls.
Options: strategic,    structured,    simulation,    tactical

Ans:D ,D

What piece of clothing was invented by French fashion designer Louis Reard in 1946?
Options: Zoot suit,    Mini-skirt,    Bikini,    Tank top


Which one of the following was associated with INA?
Options: NA

Ans:Bakshi Pratap Singh,Bakshi Pratap Singh

The right ascension is the equivalent of longitude on the celestial sphere, and it is given in the units of
Options: degrees,    time-hours, minutes and seconds,    only hours,    only seconds


sanskrit name of satluj river in Hp
Options: arjikia, shatdru, purushani, sutudri, kaalindi


The process that creates the deep oceanic trenches is called
Options: plate tectonics,    sea floor spreading,    continental drift,    isostasy


To select text by shading as you drag the mouse arrow over the text is known as...
Options: Clip art,    To highlight,    To fetch,    To decode


The Operating system manages
Options: Memory,    Processor,    Disks and I/O devices,    All of the above

Ans:D ,D

Which of these is a valid e-mail address?
Options: professor.at.learnthenet,    www.learnthenet.com,    professor@learnthenet.com,    professor@learnthenet


. Underlined character on the menu or dialog box known as
Options: a. Hot spot b. Hot key c. Pane d. Underline word

Ans:4 – b ,4 – b

The first machine to successfully perform a long series of arithmetic and logical operations was:
Options: ENIAC,    Mark I,    Analytic engine,    UNIVAC-I

Ans:B ,B

1.An adder which adds three binary digits and outputs a result bit and a carry bit is referred as
Options: (A)Half adder (B) Quarter adder (C) Full adder (D) None of these 3

Ans:31. (C),31. (C)

5.In multi processor scheduling, independent parallelism indicates
Options: (A)There is synchronization among processes at gross level. (B) There is no explicit synchronization among processes. (C) A parallel processing or multi tasking is done within a single application. (D) None of these. 12

Ans:125. (B),125. (B)

. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
Options: a. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. b. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box c. Apply a selected background color d. All of above

Ans:– b,– b

The method that cannot be used for removing permanent hardness of water is
Options: adding sodium carbonate,    distillation,    adding caustic soda,    boiling


where is chini bangla
Options: kangra, shimla, bilaspur, hamirpur, kullu


An internetworking protocol that provides virtual circuit service across multiple X.25 protocol, is
Options: X.75,    X.25,    X.400,    X.21

Ans:A ,A

The smallest glaciers are
Options: mountain or alpine glaciers,    continental glaciers,    piedmont glaciers,    None of the above


Control Unit of a digital computer is often called the
Options: Clock,    Nerve center,    ICs,    All of the above

Ans:B ,B

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)

UART is a type of serial chip. Its letters stand for:
Options: unidirectional access regarding transmission,    universal asynchronous receiver/ transmitter,    upper advanced real transfer,    unable all restore t-bits

Ans:B ,B

7.Euclidean distance measure is
Options: (A)A stage of the KDD process in which new data is added to the existing selection. (B) The process of finding a solution for a problem simply by enumerating all possible solutions according to some pre-defined order and then testing them. (C) The distance between two points as calculated using the Pythagoras theorem (D) None of these

Ans:37. (C),37. (C)

Elapsed time, between initiating a query and receiving a response is called
Options: response time,    waiting time,    processing time,    Turnaround time

Ans:D ,D

A type of line printer that uses an embossed steel band to form the letters printed on the paper is
Options: Golf ball printer,    Dot-matrix printer,    Laser printer,    Band printer


most dry place in himachal


hypair taixt transfair protochol
Options: NA

Ans: 929. deepika kumaaree ka sambandh kis khel se hai?, 929. deepika kumaaree ka sambandh kis khel se hai?

Interprocess communication
Options: is required for all processes,    is usually done via disk drives,    is never necessary,,    allows processes to synchronize activity

Ans:D ,D

. A transaction completes its execution is said to be
Options: Saved B. Loaded C. Rolled D. Committed

Ans: – D ,

Most data communications involving telegraph lines use:
Options: simplex lines,    wideband channels,    narrowband channels,    dialed service

Ans:C ,C

A subtype entity name should be which of the following?
Options: A singular noun,    Specific to the organization,    Concise,    All of the above

Ans:D ,D

118 semee
Options: NA

Ans: 922. dakshinee-pashchimee maanasoon kis raajy mein sabase pahale pravesh karata hai?, 922. dakshinee-pashchimee maanasoon kis raajy mein sabase pahale pravesh karata hai?

. The ..... program compresses large files into a smaller file
Options: a. WinZip b. WinShrink c. WinStyle d. None of above

Ans: a, a

Which of the following is a storage device?
Options: Tape B. Hard Disk C. Floppy Disk D. All of the above

Ans:– D ,

2.The following is responsible for number of logical records in a physical record
Options: (A)Blocking factor (B) Block (C) Boolean algebra (D) None of these 14

Ans:142. (A),142. (A)

If the record management system allows you to edit values before they are recorded on disk, you can
Options: correct spelling changes before they are recorded,    change the name of a field,    change the width of a field,    All of the above

Ans:A ,A

who made Raani ka Kot Durg
Options: veer sen, rajender prakash, ajbar sen, Sevant Sen

Ans:D,Sevant Sen

3.In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)
Options: (A)CTRL+F (B) CTRL+H (C) SHIFT+F4 (D) None of these 3

Ans:33. (A),33. (A)

Which one of the following kinds of materials has the highest permeability?
Options: A diamagnetic material,    A ferromagnetic material,    A paramagnetic material,    All of the above

Ans:B ,B