Which function is not available in the Consolidate dialog box?


Options: Pmt B. Average C. Max D. Sum

Ans:– A ,






More MS-Excel Related questions:


. The __________ key will launch the Start button.
Options: a. esc b. shift c. Windows d. Shortcut

Ans:4 – c ,4 – c


The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B


Trend analysis:
Options: is used only in financial planning,    can improve control system response,    requires a very expensive system to implement,    is a brand new concept

Ans:B ,B


The transistor has a collector current of 10 mA and a base current of 40 mA. What is the current gain of the transistor?
Options: 250 μA,    350 μA,    0.25 μA,    300 μA

Ans:A ,A


Which of the following is a machine language instruction?
Options: ADD 5,    10001101,    GOTO XOUT,    All of the above

Ans:B ,B


Which of the following files is used for NetBIOS name resolution?
Options: HOSTS,    LMHOSTS,    ARP,    FQDN

Ans:B ,B


82. Which option in File pull-down menu is used to close a file in MSWord?
Options: a. New b. Quit c. Close d. Exit

Ans:–  C ,–  C


Which bitwise operator is suitable for checking whether a particular bit is on or off?
Options: && operator,    & operator,    || operator,    ! operator

Ans:B ,B


What do the following declaration signify? char **argv;
Options: argv is a pointer to pointer.,    argv is a pointer to a char pointer.,    argv is a function pointer.,    argv is a member of function pointer.

Ans:B ,B


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

Ans:9 – c ,9 – c


What is a common language that computers use to talk with one another on a network
Options: client,    adapter,    protocol,    operating systems

Ans:C ,C


A technique used by codes to convert an analog signal into a digital bit stream is known as
Options: Pulse code modulation,    Pulse stretcher,    Query processing,    Queue management

Ans:A,(Aanswer


What is the paper feeding technology most commonly associated with dot-matrix printers?
Options: sheet feed,    tractor feed,    friction feed,    manual feed

Ans:B ,B


The computer is a part of the firm's
Options: physical system,    conceptual system,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which of the field has width 8 bytes?
Options: a. Memo b. Number c. Date/Time d. Hyperlink

Ans:ndash; c,ndash; c


Text formulas:
Options: a. Replace cell references b. Return ASCII values of characters c. Concatenate and manipulate text d. Show formula error value

Ans:8211; c,8211; c


Point out the error in the following program (if it is compiled with Turbo C compiler). #include<stdio.h> int main() { display(); return 0; } void display() { printf("IndiaBIX.com"); }
Options: No error,    display() doesn't get invoked,    display() is called before it is defined,    None of these

Ans:C ,C


The size of the organization chart object
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. b and c

Ans: – D , – D


. Which of the following is not a video file extension?
Options: a. .avi b. .wav c. .mpeg d. .mov

Ans:1 – b ,1 – b


Which of the following processor is software that accepts user ideas, manipulates and reorganises them in user-specified ways and then produces a refined model of those thoughts.
Options: Distribute,    Out-line,    Multi,    On-line

Ans:B ,B


Which SQL phrase is not supported by Oracle?
Options: ON DELETE CASCADE,    ON UPDATE CASCADE,    CREATE SEQUENCE [SequenceName],    DROP SEQUENCE [SequenceName]

Ans:B ,B


. Excel is a
Options: a. Graphic program b. None of these c. Word processor d. A spreadsheet

Ans:– d,– d


. Which of the following field properties displays a model or pattern for entering data?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:6 – c ,6 – c


. What is the first stage in software development?
Options: A) Specification and design B) Testing C) System Analysis D) Maintenance

Ans:C,C


. Which one is the largest space?
Options: A) kilobyte B) petabyte C) terrabyte D) gigabyte

Ans:B,B


The data communication support should include, but is not restricted to
Options: file transfer and transaction processing,    file and database access,    terminal support, electronic mail and voice grams.,    All of the above

Ans:D ,D


What is the use of Notes in slides?
Options: It will be displays at the time of Slide Presentation B. This is just Note about the slide       C. This is just for printing purpose only D. Notes cannot be inserted in Slides

Ans:– B ,


A table that displays data redundancies yields ____________ anomalies
Options: Insertion B. Deletion C. Update D. All of the above

Ans:– D ,


. How do you display current date and time in MS Excel?
Options: a. date () b. Today () c. now () d. time ()

Ans:– c,– c


The command center of  access file that appears when you create or open the MS Access database file.
Options: a. Database Window b. Query Window c. Design View Window d. Switchboard

Ans:ndash; a,ndash; a


. Which command will you use to transfer a specific file from one disk to another disk?
Options: a. Time b. Diskcopy c. Copy d. Rename

Ans:7 – c ,7 – c


The three different types of pen plotter technology are flatbed, drum, and:
Options: electrostatic,    thermal,    pinch roller,    impact

Ans:C ,C


The communication mode that supports two-way traffic but only one direction at a time is
Options: simplex,    duplex,    half duplex,    multiplex

Ans:C ,C


17. What is the smallest width of a column?
Options: a. 0″ b. 0.5″ c. 1″ d. 1.5″

Ans:– B ,– B


What is the alternative name for a diskette?
Options: Floppy disk,    Hard disk,    Flexible disk,    Winchester disk

Ans:A ,A


. Floppy disks are available in

Options: A) Single side single density B) Single side double density C) Both of above D) None of above

Ans:C,C


. Ctrl + D shortcut key in Excel will
Options: a.  Open the font dialog box b.  Apply double underline for the active cell c.  Fill down in the selection d.  None of above

Ans:– c,– c


In which way(s) can a macro processor for assembly language be implemented?
Options: independent two-pass processor,    independent one-pass processor,    processor incorporated into pass of a standard two-pass assembler,    All of the above

Ans:D ,D


A 32 bit microprocessor has the word length equal to
Options: 2 bytes,    32 bytes,    4 bytes,    8 bytes

Ans:C ,C


Which language is used to create macros in Excel?
Options: Visual Basic B. C C. Visual C++ D. Java

Ans:– A ,


What is the size of Source and Destination IP address in IP header?
Options: 4 bits B. 8 bits C. 16 bits D. 32 bits

Ans:– D ,


Which of the following is a graphical input device?
Options: light pen,    keyboard,    mouse,    Track ball

Ans:A ,A


The main purpose of the off line device is
Options: To reduce the no.of operator errors in recording data,    To save computer time,    To save floor space in the computer centre,    All of the above

Ans:B ,B


. When did John Napier develop logarithm?
Options: A) 1416 B) 1614 C) 1641 D) 1804

Ans:B,B


A _____ is a formalized computer information system that can integrate data from various sources to provide the information necessary for management decision making.
Options: prompt,    passwords,    MIS,    Tactical

Ans:C ,C


How many ALU(s) is/are control by one control unit is SIMD (single instruction stream, multiple data stream) architecture?
Options: one or more ALUs,    One ALU,    Only two ALU .,    Impossible to say

Ans:A ,A


Which of the following does not fail in the Personnel Decision-Making Area:
Options: pay-rolls,    cash flow analysis,    income-tax assessment and recovery,    person's experience

Ans:B ,B


. The memory which is programmed at the time it is manufactured
Options: A) ROM B) RAM C) PROM D) EPROM

Ans:5-C,5-C


An extent is which of the following?
Options: A keyword that indicates that the subclass inherits from a superclass,    A keyword that indicates that the superclass inherits from a subclass,    The set of all instances of a class within a database,    Only one instance of a class within a database

Ans:C ,C


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

www.000webhost.com