. How to fit long texts in a single cell with multiple lines?

Options: Start typing in the cell and press the Enter key to start another line B. Use the Wrap Text option in the Format -> Alignment menu C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu D. All of above

Ans:– B ,

More MS-Excel Related questions:

A special type of device which uses an ordinary telephone with a computer is
Options: Light pen,    Mouse,    Acoustic couple,    Touch panel

Ans:C ,C

Which of the following keys is used to delete the character beneath the cursor?
Options: x,    X,    dd,    D

Ans:A ,A

. RD command are used to
Options: a. Remove an empty directory b. Remove non empty directory c. Remove directory including files d. None of the above

Ans:9 – a ,9 – a

Union officials receive the same type of education as
Options: top level managers,    the rank and file employees,    low level managers,    All of the above

Ans:C ,C

A generalised software package produced to meet the bugs of a variety of data processing users is known as
Options: Utility programs,    System software,    Operating system,    Application package

Ans:D ,D

. What was the name of the first commercially available microprocessor chip?
Options: A) Intel 308 B) Intel 33 C) Intel 4004 D) Motorola 639


. A data map is helpful
Options: a. When you have too much data to chart b. To show a geographic distribution of data c. To compare data points d. To show changes in data over time

Ans:– b,– b

Which of the following is not true of immediate processing?
Options: It is often used in real-time applications,    It can occur with either sequential of direct-access files,    It can be used in an airline-reservation system,    Transactions are processed shortly after a real-world event occurs


Which one of the following properties of a magnetic circuit can be directly compared to current in an electrical circuit?
Options: Number of lines of force,    Flux density,    Reluctance,    Magnetomotive force

Ans:A ,A

A step-down transformer has turns ration of 5:1. If the primary voltage is 120 Vrms, what is the secondary voltage?
Options: 12 V,    18 V,    24 V,    30 V

Ans:C ,C

ODBC minimum SQL grammar contains which of the following?
Options: INSERT, UPDATE, DELETE only,    Stored Procedures only,    Literals for date, time and timestamp only,    CREATE VIEW, DROP VIEW only

Ans:A ,A

. Which statement is valid about magnetic tape?
Options: A) It is a plastic ribbon B) It is coated on both sides with iron oxide C) It can be erased and reused D) All of above


Environment in systems parlance refers to
Options: a sub-system,    the boundary,    a part outside the boundaries,    All of the above

Ans:C ,C

If you see a diskette with a piece of foil covering its notch, it is said to be
Options: write-protected,    copy-protected,    write-enabled,    foil-covered

Ans:A ,A

. One computer that is not considered a portable is
Options: A) Minicomputer B) Laptop computer C) Notebook computer D) All of above


High-level languages are not concerned with computer but with
Options: Assembler,    Machine code,    Compiler,    All of the above

Ans:A ,A

A real voltage source has
Options: Zero internal resistance,    Infinite internal resistance,    A small internal resistance,    A large internal resistance

Ans:C ,C

Which file keeps commands to execute automatically when OS is started?
Options: command.com B. any batch file C. autoexec.bat D. config.sys

Ans:– C ,

.   The quickest way to create a PowerPoint presentation is to use the
Options: a. Word for windows templates b. Auto creation wizard c. Auto content wizard d. Presentation wizard

Ans:7 – C ,7 – C

A memory that does not change its contents without external causes is known as
Options: Dynamic memory,    Static memory,    RAM,    EEPROM


You can copy data or formulas
Options: a. With the copy, paste and cut commands on the edit menu b. With commands on the shortcut menu c. With buttons on the standard toolbars d. All of the above

Ans:#8211; d,#8211; d

Which one of the following equations most directly leads to the resistance of an ordinary household light bulb, assuming that you know the power and voltage rating?
Options: R = E2/P,    P = PR,    P = E2/R,    I = P/E

Ans:A ,A

A Dumb terminal has
Options: Processor and Keyboard B. Processor and Hard Disk C. Keyboard and Hard Disk D. Keyboard and Screen

Ans:– D ,

The structure chart is:
Options: a document of what has to be accomplished,    a hierarchical partitioning of the program,    a statement of information-processing requirements,    All of the above

Ans:B ,B

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

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: – D , – D

An MIS can be developed by
Options: a fire department,    a college testing service,    an ocean transportation company,    All of the above

Ans:D ,D

Insert Date, Format Page Number, and Insert AutoText are buttons on the _____ toolbar.
Options: a. Formatting b. Header and Footer c. Standard d. Edit

Ans:– B,– B

. Which of the following is a feature of fifth generation computers?
Options: A) Use of natural language B) artificial intelligence C) bio-chips D) All of above


At the time of system study, flowcharts are drawn using
Options: non-standard symbols,    general symbols,    abbreviated symbols,    specific symbols

Ans:B ,B

A Ring, refers to a record chain, the last of which refers to the first record, in the chain, is called a/an
Options: addressing,    location,    pointer,    loop

Ans:C ,C

A condition that led to the development of databases was
Options: a demand for more data to support information needs,    an increase in the amount of data handled by organizations,    the proliferation of data files,    All of the above

Ans:D ,D

Which of the following is still useful for adding numbers?
Options: EDSAC,    ENIAC,    Abacus,    UNIVAC


Which of the following systems software does the job of merging the records from two flies into one?
Options: Documentation system,    Utility program,    Networking software,    Security software

Ans:B ,B

Molecule is
Options: The smallest particle of a substance that retains the properties of that substance,    A atom that has a shortage of electrons in its outer orbit,    A atom that has an excessive number of electrons in its outer orbit,    A atom that flows whenever there is an imbalance of electrical charges between two points

Ans:A ,A

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Options: A domain constraint,    A range constraint,    An intrarelation constraint,    An interrelation constraint

Ans:A ,A

In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)
Options: a. animation b. slide transition c. custom animation d. preset animation

Ans: – B , – B

. What is the quickest way to select entire worksheet?
Options: a. Choose Edit -> Select all from the Menu b. Click on the first column, press Ctrl, and then click on the last column c. Click on the first column, press Shift, and then click on the last column d. Click on the rectangle box on the upper left corner where column headings and row headings meet

Ans:– d,– d

Which device does the general population associate most with automation?
Options: Flexible manufacturing,    Robots,    Numerical control machine,    Computer graphics workstation

Ans:B ,B

ISDN stands for:
Options: internal select data nulls,    integrated services digital network,    interval set down next,    interior sector direct none

Ans:B ,B

An example of a global allocation problem is
Options: defining plant capacities,    scheduling an entire development project,    setting general inventory guidelines,    All of the above

Ans:D ,D

A brownout is defined as:
Options: a slightly elevated voltage lasting from seconds to minutes or more,    a slightly decreased voltage lasting from seconds to minutes or more,    complete power out lasting a few minutes,    alternating power out, power on lasting a few minutes

Ans:B ,B

AutoCorrect was originally designed to replace _________ words as you type.
Options: a. short, repetitive b. grammatically incorrect c. misspelled d. none of the above

Ans:– C,– C

78. What should you do if you require to paste the same format in many places?
Options: a. Click the Format painter and go on pasting in many places holding Alt Key b. Double click the format painter then go on pasting in many places c. Click the format painter then go on pasting to many places holding Ctrl Key d. All of above

Ans:– B ,– B

When was the IBM XT microcomputer released in the market?
Options: 1970,    1971,    1987,    1986

Ans:C ,C

Which of the following is correct in VLSM?
Options: Can have subnets of different sizes B. Subnets must be in same size             C. No required of subnet D. All of above

Ans:– A ,

. What is the easiest way to place same graphic in same place in all slides
Options: a. Place graphic in Notes Master b. Place graphic in Slide Master c. Place graphic in Handout Master d. Place graphic manually in all slide

Ans:3 – B ,3 – B

. MICR stands for
Options: A) Magnetic Ink Character Reader B) Magnetic Ink Code Reader C) Magnetic Ink Cases Reader D) None


. Which of the following is not an advantage of open source operating system over proprietary version?
Options: a. Free to use and distribution b. Availability of technical support c. Availability of source code d. Ability to modify code

Ans:4 – b ,4 – b

A 'number crunching' computer is one that can handle
Options: large spreadsheets,    large alphanumeric data,    large volume of numbers,    only numbers

Ans:C ,C