. We can save and protect the workbook by


Options: Write Reservation Password B. Protection Password C. Read-only Recommended D. Any of the above

Ans: – D ,


Description: mcqquestions






More MS-Excel Related questions:


. Which program would you use to create copies of important information stored on your fixed disk drive?
Options: a. Scan disk b. Copy disk c. Back up d. None of above

Ans:3 – c ,3 – c


. Which of the following statements about PivotChart View is NOT true?
Options: a. It is used to graphically summarize and analyze data in a table, query, or form. b. It can be used to view different levels of detail or to specify custom layout. c. It displays field values that can be switched for different views of data. d. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

Ans:5 – d ,5 – d


Which of the following is not a valid size of a Floppy Disk?
Options: 8″ B. 5 1/4″ C. 3 1/2″ D. 5 1/2″

Ans:– D ,


Why does the data communication industry use the layered OSI reference model? It divides the network communication process into smaller and simpler components, thus aiding component development, design, and troubleshooting. It enables equipment from different vendors to use the same electronic components, thus saving research and development funds. It supports the evolution of multiple competing standards and thus provides business opportunities for equipment manufacturers. It encourages industry standardization by defining what functions occur at each layer of the model.
Options: 1 only,    1 and 4,    2 and 3,    3 only

Ans:B ,B


Which command is used to copy a file wb with the same name from the programs directory to the misc directory?
Options: copy programs/wb misc/wb,    cp programs/wb misc,    tar programs/wb misc/wb,    copy a:programs/wb b:misc/wb

Ans:B ,B


. Which object is used to create a form?
Options: a. Tables and Queries b. Tables only c. Tables and reports d. Queries and reports

Ans:– a,– a


If a robot can alter its own trajectory in response to external conditions, it is considered to be:
Options: intelligent,    mobile,    open loop,    non-servo

Ans:A ,A


. Hard disk is coated in both side with
Options: A) Magnetic metallic oxide B) Optical metallic oxide C) Carbon layer D) All of the above

Ans:5-A,5-A


  Slides can have
Options: title, text, graphs B. drawn objects, shapes C. clipart, drawn art, visual D. any of the above

Ans:– D ,


What are the main parts of an atom?
Options: Protons only,    Electrons, protons, and ions,    Electrons, ions, and neutrons,    Electrons, protons, and neutrons

Ans:D ,D


A 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


. To copy cell contents using drag and drop, press the
Options: a. End key b. Shift key c. Esc key d. None of above

Ans:– d,– d


19. Which command is used to delete all the files in the root directory of drive a
Options: a. A:del b. Del *.* a: c. Del a: d. Erase *.*

Ans:Correct Answer: c ,Correct Answer: c


. What will be the command if you want to copy rdoc file that resides in the floppy disk into work sub-directory of hard disk while you are in C prompt
Options: a. Copy c: doc a:work b. Copy A: doc c:work c. Copy rdoc c:work d. Copy c:>work a:doc

Ans:1 – b ,1 – b


A single transistor can be used to build which of the following digital logic gates?
Options: AND gates,    OR gates,    NOT gates,    NAND gates

Ans:C ,C


Which would you choose to move selected text from one place to another?
Options: Press Ctrl+S B. Click File, Save C. Click Tools, Options, Save D. Click File, Save As

Ans:C ,


An assembly language instruction:
Options: is written in ones and zeros,    corresponds to one computer operation,    does not require knowledge of the computer design,    All of the above

Ans:B ,B


Which of the following is not a factor affecting the processing capability or performance of a PC system?
Options: The clock speed of the microprocessor,    The revolutions per minute of the printer disk,    The primary storage capacity of the processor,    The built-in instruction set available to the microprocessor

Ans:B ,B


Which of the following best describes a computer-based information system?
Options: A system in which a computer is used to turn data into information,    Inputting data,    Processing data,    Performing complex mathematical calculations

Ans:A,A


Which is a swapping device is used to hold the images of pages in main memory.
Options: Plex,    Paging drum,    Card punch,    Optical mark reader

Ans:B ,B


A computer system consisting of its processor, memory and I/O devices accepts data, processes it and produces the output results. Can you tell in which component is the raw data fed?
Options: Mass Memory,    Main memory,    Logic unit,    Arithmetic unit

Ans:B ,B


Sensitivity Analysis is the ability to perform:
Options: What-if analysis,    If-so analysis,    What-then analysis,    And-or analysis

Ans:A ,A


Which of the following are not done by Business Intelligence (BI) systems?
Options: Analyze past and current activities only,    Process and record transactions only,    Both of the above are correct.,    Neither of the above is correct.

Ans:B ,B


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

Ans:A,A


Inverted list organization
Options: means storing records in contiguous blocks according to a key.,    Stores records sequentially but uses an index to locate records,    uses an index for each key type,    has records placed randomly throughout the file

Ans:C ,C


. Which of the following is not the classification of computers based on application?

Options: A) Electronic Computers B) Analog Computers C) Digital Computers D) Hybrid Computers

Ans:A,A


The calculation of expected outcomes in intended to help the manager
Options: identify problems,    identify solutions,    evaluate solutions,    All of the above

Ans:C ,C


. Fonts install from
Options: a. Add from control panel b. Font setup file c. Font.exe file d. All of above

Ans:2 – d ,2 – d


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


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


Which of the following commands is used to change the working directory?
Options: cd,    changedir,    chdir,    cdir

Ans:A ,A


A network administrator is connecting hosts A and B directly through their Ethernet interfaces, as shown in the illustration. Ping attempts between the hosts are unsuccessful. What can be done to provide connectivity between the hosts? A crossover cable should be used in place of the straight-through cable. A rollover cable should be used in place of the straight-through cable. The subnet masks should be set to 255.255.255.192. A default gateway needs to be set on each host. The subnet masks should be set to 255.255.255.0.
Options: 1 only,    2 only,    3 and 4 only,    1 and 5 only

Ans:D ,D


Which is the earliest and most widely used shell that came with the UNIX system?
Options: C shell,    Korn shell,    Bourne shell,    Smith shell

Ans:C ,C


Which of the following is not a practical data-processing approach?
Options: batch-sequential,    batch-direct,    immediate-sequential,    immediate-direct

Ans:C,C


Which command is used to remove an index from the database in SQL?
Options: DELETE INDEX,    DROP INDEX,    REMOVE INDEX,    ROLL BACK INDEX

Ans:B ,B


. A set of rods where numbers were carved and used for multiplication and division aids is known as

Options: A) Pascaline B) Napier’s Bones C) Stepped Reckoner D) Slide Rule

Ans:B,B


Uniform Symbols Table
Options: contains all constants in the program,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure.,    consists of a full or partial list of the token's as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    a permanent table which lists all key words and special symbols of the language in symbolic form.

Ans:C ,C


You get a CMOS checksum error during bootup. What is most likely the cause?
Options: power supply is bad,    BIOS needs updating,    CMOS battery is nearing end of life,    hard drive types are incorrectly defined

Ans:C ,C


What is the highest binary number that can be referred to on a three position jumper block?
Options: 4,    6,    F,    1

Ans:D ,D


. What is the use of bookmarks in Microsoft Word?
Options: To easily correct the spelling errors B. To quickly jump to a specific location in the document C. To quickly jump to the ending of the document D. To create a link within the document

Ans:– B ,


Which of the following can be output by a computer?
Options: graphics,    voice,    text,    computer-usable data or information

Ans:E ,E


If the values of a variable in one module is indirectly changed by another module, this situation is called
Options: A)internal change b.inter-module change c.side effect d.side-module update

Ans:C,Side effect


The EIA-232 interface has _____ pins.
Options: 20,    24,    25,    30

Ans:C ,C


Feed back queue
Options: are very easy to implement,    dispatch tasks according to execution characteristics,    are used to favor real-time tasks,    require manual intervention to implement properly

Ans:B ,B


The most common input device used today is
Options: Motherboard,    Track ball,    Scanner,    Mouse

Ans:A,Motherboard


What TCP/IP protocol is used for transferring electronic mail messages from one machine to another?
Options: FTP,    SNMP,    SMTP,    RPC

Ans:C ,C


What can he used to set up a firewall on a Linux system?
Options: netstat,    route,    trace,    ipchains

Ans:D ,D


Which of the following is not a component of a data warehouse?
Options: Data extraction/cleaning/preparation programs,    Data warehouse data,    Data metadata,    None of the above are data warehouse components.

Ans:C ,C


. Which of the following is machine independence program?
Options: A) High level language B) Low level language C) Assembly language D) Machine language

Ans:A,A


In SQL, which command(s) is(are) used to recompile a stored function?
Options: SET FUNCTION,    SET STORED FUNCTION,    ALTER FUNCTION,    All of the above

Ans:C ,C

www.000webhost.com