. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

Options: a.  F8 b.  F9 c.  F10 d.  F11

Ans:– b,– b

More MS-Excel Related questions:

Which of the following files will displayed by this command cat *ch*
Options: patch,    catch,    .ch,    All of the above

Ans:D ,D

Addition of 102 and 112 is
Options: 1002,    1012,    1112,    1102

Ans:B ,B

In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of a register?
Options: Absolute mode,    Indirect mode,    Immediate mode,    Index mode


Which of the following are measures of quality:
Options: validity,    accuracy,    precision,    All of the above

Ans:D ,D

. Where you can find the font?
Options: a. C:Font b. C:windowsfont c. C:control panelfont d. All of above

Ans:9 – b ,9 – b

. With which view can you see how text and graphics will appear on the printed page?
Options: a. Normal b. Print Layout c. Outline d. Web Layout

Ans:–  B,–  B

Where is the 'National Remote Sensing Agency' situated?
Options: Shadnagar,    Bangalore,    Chennai,    Dehradun


3.In Excel to name a constant, you use the …… dialog box
Options: (A)Create names (B) Define name (C) Paste name (D) Format cells 17

Ans:173. (B),173. (B)

. If you write criteria values vertically (one in a row) it will mean
Options: a. Or conditions b. And conditions c. Not condition d. None of above

Ans:6 – a ,6 – a

234. koshika ka paavarahaus kise kaha jaata hai?
Options: NA

Ans: maitokondriya, maitokondriya

An application suitable for sequential processing is
Options: A) Processing of grades B) Payroll processing C) Both a and b D) All of above


5.When using PowerPoint, to play a PowerPoint show for previewing the show, select
Options: (A)View, slide sorter (B) View, slide (C) View, slide show (D) View outline

Ans:5. (C),5. (C)

Pa(Pascal) is the unit for
Options: thrust,    pressure,    frequency,    conductivity


Which is used to provide the sight information to the right person at the right time for proper decision making?
Options: DBMS,    MIS,    ISO,    PSO

Ans:B ,B

Who co-created the UNIX operating system in 1969 with Dennis Ritchie?
Options: Bjarne Stroustrup,    Steve Wozniak,    Ken Thompson,    Niklaus Wirth


. What is defined by Handout Master?
Options: a. Slide Formatting b. Slide Transaction c. Layout of Handout d. Layout of Slide

Ans:6 – C ,6 – C

A coating of dust on a computer's main circuit boards has this probable consequence
Options: Overheating,    Short circuits,    Slower hard disk,    None


In 1901, Nobel Prize was not given for
Options: Chemistry,    Physics,    Economics,    Peace


Which of the following is the expansion of EBCDIC
Options: Extended bit comparable to digital interface for computer,    Extended bootable computerised digital infrared calculator,    Extended binary coded decimal interchange code,    Extended binary coded decimal information code

Ans:C ,C

When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995


The gas present in the stratosphere which filters out some of the sun's ultraviolet light and provides an effective shield against radiation damage to living things is
Options: helium,    ozone,    oxygen,    methane


240. tanjaur ka vrhadeshvar mandir kisane banavaaya tha?
Options: NA

Ans: raajaraaja pratham chol ne, raajaraaja pratham chol ne

.  In a module, a(n) _______ is a series of commands and properties that perform a specific task.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– c,– c

Device used to measure very high temperature is
Options: NA


What types of installations require a special boot disk?
Options: NFS,    FTP,    PCMCIA,    All of the above

Ans:D ,D

The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B ,B

Background color or effects applied on a document is not visible in
Options:  A) Web layout view, B) Print Layout view, C) Reading View, D) Print Preview, 


Which component must be vacuumed or replaced during preventative maintenance on a laser printer?
Options: Scanning mirror,    Toner cartridge,    Ozone filter,    All of the above

Ans:C ,C

The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but the data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a linear array does not d. All of above

Ans: d, d

What will be the output of the program if it is executed like below? cmd> sample /* sample.c */ #include<stdio.h> int main(int argc, char **argv) { printf("%s\n", argv[argc-1]); return 0; }
Options: 0,    sample,    samp,    No output

Ans:B ,B

'Apsara' is the name of India's first
Options: Railway Locomotive,    Helicopter,    Nuclear Reactor,    Ground Battle Tank


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

Ans:D ,D

298. baal pen kis siddhaant par kaam karata hai?
Options: NA

Ans: prshtheey tanaav, prshtheey tanaav

Which part of the laser printer should NOT be exposed to sunlight?
Options: Transfer corona assembly,    PC drum,    Primary corona wire,    Toner cartridge

Ans:B ,B

. Which operating system does not support networking between computers?
Options: a. Windows 3.1 b. Windows 95 c. Windows 2000 d. Windows NT

Ans: a, a

The imaginary line on the earth's surface, which closely follows the 180 º meridian, is called the
Options: International Date Line,    Tropic of Cancer,    Equator,    Prime Meridian


5.Multiprogramming systems
Options: (A)are easier to develop than single programming systems (B) execute each job faster (C) execute more jobs in the same time period (D) are used only one large mainframe computers 23

Ans:235. (C),235. (C)

47. kshetraphal kee drshti se bhaarat mein sabase chhota raajy kaun–sa hai?
Options: NA

Ans: gova, gova

. The Search tool is best used when searching for ______ data.
Options: a. simple b. multiple c. unique d. formatted

Ans:6 – a ,6 – a

345. bhaarat kee sabase lambee sthaleey seema kis desh se lagatee hai?
Options: NA

Ans: baanglaadesh, baanglaadesh

Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,

Which is another name for functional language?
Options: Machine,    Application language,    Low-level language,    High-level language


What could cause a fixed disk error.
Options: No-CD installed,    bad ram,    slow processor,    Incorrect CMOS settings

Ans:D ,D

. 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 ,

The _____ command is used to allocates an extent for the table in SQL

Ans:A ,A

. Copy con ram.txt is
Options: a. Copy the entire data b. Deletes the data c. Controlling the enter data d. All of above

Ans:8 – a ,8 – a

The president can be removed from his office before the expiry of his normal term only on the recommendation of
Options: the Supreme Court,    the chief justice of India,    council of ministers,    the two Houses of Parliament


Two dimensional arrays are also called
Options: a. tables arrays b. matrix arrays c. both of above d. none of above

Ans:- c,- c

Light from the star, Alpha Centauri, which is nearest to the earth after the sun, reaches the earth in
Options: 4.2 seconds,    42 seconds,    4.2 years,    42 years


Knot is a unit of speed of which of the following?
Options: Aeroplane,    Light waves,    Ship,    Sound waves