. Multiple calculations can be made in a single formula using…..

Options: Standard Formulas B. Array Formula C. Complex Formulas D. Smart Formula

Ans: – B ,

More MS-Excel Related questions:

Which of the following is not the required condition for binary search algorithm?
Options: a. The list must be sorted b. there should be the direct access to the middle element in any sublist c. There must be mechanism to delete and/or insert elements in list d. none of above

Ans:- c,- c

. The .... displays the name of every computer user on the computer
Options: a. Wish list screen b. Command screen c.Welcome screen d. None of the above

Ans: c, c

The database administration function includes
Options: application programming,    computer operations management,    database access planning,    All of the above

Ans:C ,C

What can greatly reduce TCP/IP configuration problems?
Options: WINS Server,    WINS Proxy,    DHCP Server,    PDC

Ans:C ,C

What is the name given to the molecular-scale computer?
Options: Femtocomputer,    Nanocomputer,    Supercomputer,    Microcomputer


. In order to play and hear sound on a computer, one needs:

Options: A) a sound card and speakers B) a microphone C) all of them required D) none of them required


. The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above


The complexity of merge sort algorithm is
Options: A)O(n) b.O(log n) c.O(n2) d.O(n log n)


Where can system and mail logs be found in Ret Hat Linux?
Options: /var/log,    /etc/log,    /mail,    All of the above

Ans:A ,A

. 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

. Which of the following is not true regarding Conditional Formatting?
Options: a. You can add more than one condition to check b. You can set condition to look for Bold and apply Italics on them. c. You can apply Font, border and pattern formats that meets the specified conditions d. You can delete any condition from Conditional Formatting dialog box if it is not requried

Ans:– b,– b

Which of the following systems implementation approaches should be used if you want to run the old system and the new system at the same time for a specified period?
Options: direct,    pilot,    parallel,    phased

Ans:C ,C

. To delete records or perform calculations on a table, the best tool to use is a __________.
Options: a. query b. filter c. form d. report

Ans:0 – a ,0 – a

A device for converting handwritten impressions into coded characters & positional coordinates for input to a computer is
Options: Touch panel,    Mouse,    Wand,    Writing tablet


.  To assign a macro to an event, users need to open the form in Design View.
Options: a.            event b.            property c.           title d.           macro

Ans:– a,– a

. In latest generation computers, the instructions are executed
Options: A) Parallel only B) Sequentially only C) Both sequentially and parallel D) All of above


. What do you mean by dialog box?
Options: a. Interactive message box b. Group of options c. Set of controls d. All of the above

Ans:D,All of above

. If particular workbook have to open each time Excel started, where that workbook should be placed?

Ans:– D ,

2. ….is the layer of a computer system between the hardware and the user program
Options: a. Operating environment b. Operating system c. System environment d. None

Ans:Correct Answer: b,Correct Answer: b

The heart of any computer is the
Options: CPU,    Memory,    I/O Unit,    Disks


The technique, for sharing the time of a computer among several jobs. Which switches jobs so rapidly such that each job appears to have the computer to itself:
Options: time sharing,    time out,    time domain,    FIFO

Ans:A ,A

Conversion of hexadecimal number 1D7F16 to a decimal number is
Options: 755110,    877110,    555710,    778110

Ans:A ,A

If the client receives an address from a DHCP server, what is the only information available in the Network Properties dialog box?
Options: The IP address,    The subnet address,    That the client is receiving its address from DHCP,    The default gateway

Ans:C ,C

Which of the following device cannot be shared in Network?
Options: CD Drive B. Printer C. Mouse D. Hard Disk

Ans:– C ,

Columns dialog box can be opened from
Options:  A) Format menu Columns submenu, B) Double click on column space in ruler, C) Press Alt + O + C, D) All of above, 


Which of the following describes the operation of a positive edge-triggered D-type flip-flop?
Options: If both inputs are HIGH, the output will toggle.,    The output will follow the input on the leading edge of the clock.,    When both inputs are LOW, an invalid state exists.,    The input is toggled into the flip-flop on the leading edge of the clock and is passed to the output on the trailing edge of the clock.

Ans:B ,B

. Which is not executable file?
Options: a. .com b. .exe c. .bat d. .txt

Ans:3 – d ,3 – 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

.   in order to edit a chart, you can
Options: a. triple click the chart object b. click and drag the chart object c. double click the chart object d. click the chart objects

Ans:9 – C ,9 – C

_____ tool allows you to change your default X Window desktop.
Options: utilinux,    cempre,    switchdesk,    window

Ans:C ,C

What command is used to reset a MODEM when using the
Options: ATR,    ATZ,    DTR,    DCE

Ans:B ,B

Which of the following is private IP address?

Ans:D ,D

. Charles Babbage was awarded by Royal Society for his
Options: A) Difference Engine B) Analytic Engine C) Binary System in Analytic Engine D) His concept of input, mill, output and storage


. Which feature helps you to inserts the contents of the Clipboard as text without any formatting
Options: Paste Special B. Format Painter C. Page Setup D. Styles

Ans:– A ,

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
Options: Network database,    Relational database,    Distributed database,    Hierarchical database

Ans:D ,D

. The lower deck of an abacus is known as
Options: A) heaven B) sky C) earth D) floor


. Networking such as LAN, MAN started from

Options: A) First generation B) Second generation C) Third generation D) Fourth generation


.   To give a PowerPoint presentation to a large audience, you:
Options: a. Set up your computer in a large auditorium, and click large, auditorium, OK b. Click the slide you wish the audience to see in normal view, then click the next slide, and so on. c. Choose either view, slide show or slide show, view show d. Slick slide show, OK

Ans:5 – C ,5 – C

When an entity instance must be a member of only one subtype, it is which of the following?
Options: Disjoint with total specialization,    Disjoint with partial specialization,    Overlap with total specialization,    Overlap with partial specialization

Ans:A ,A

Loaders that allow for program relocation are called
Options: relocating loaders,    relative loaders,    both (a) and (b),    None of the above

Ans:C ,C

Which of the following file organizations is most efficient for a file with a high degree of file activity?
Options: sequential,    ISAM,    VSAM,    B-Tree index

Ans:A ,A

Options: is a method of memory allocation by which the program is subdivided into equal portions, or pages and core is subdivided into equal portions or blocks.,    consists of those addresses that may be generated by a processor during execution of a computation.,    is a method of allocating processor time.,    allows multiple programs to reside in separate areas of core at the time.

Ans:D ,D

Which of the following memory has the shortest access time?
Options: Virtual Memory B. Cache Memory C. External Memory D. Register

Ans:– D ,

What do the following declaration signify? int (*pf)();
Options: pf is a pointer to function.,    pf is a function pointer.,    pf is a pointer to a function which return int,    pf is a function of pointer variable.

Ans:C ,C

_____ use standardized symbols to represent an algorithm.
Options: Flowcharts,    Flow diagrams,    IPO charts,    Pseudocharts

Ans:A ,A

. The command to display the contents of a file fast.it
Options: a. TYPE it fast b. COPY fast.it CON c. COPY CON fast.it d. None of above

Ans:3 – c ,3 – c

Which of the following is not the Section Break Option?
Options: a. Next Page b. Previous Page c. Odd Page d. Even Page

Ans:–  B,–  B

Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit

Ans:D ,D

Which of the following is used to create newspaper style columns?
Options:  A) Format Tabs, B) Table Insert Table, C) Insert Textbox, D) Format Columns, 


Which of the following option in File pull down menu is used to close a MS Word document?
Options:  A) Quit, B) Close, C) Exit, D) New,