. Which option allows you to Bold all the negative values within the selected cell range:


Options: Zero Formatting B. Conditional Formatting       C. Compare Formatting D. Negative Formatting

Ans:– B ,


Description: mcqquestions






More MS-Excel Related questions:


A primary use of decision support system (DSS) is to simulate an experiment over by using different parameters and assumptions. What is it called?
Options: Artificial intelligence,    What if analysis,    Exception report,    Computer assisted experimenting

Ans:D ,D


Which of following is not PowerPoint views?
Options: Page View B. Print View C. Normal View D. Outline View

Ans:– A ,


Which file starts MS Word?
Options: a. winword.exe b. word.exe c. msword.exe d. word2003.exe

Ans:– A,– A


A monitor's _____ is the distance between the holes in the mask behind the screen. This helps determine how sharp the dots appear.
Options: refresh rate,    dot pitch,    resolution,    color depth

Ans:B ,B


. “Ctrl + PageUp” is used to
Options: Moves the cursor one Page Up B. Moves the cursor one Paragraph Up C. Moves the cursor one Screen Up D. Moves the cursor one Line Up

Ans:– A ,


Data Definition Language (DDL)
Options: describes how data are structured in the data base,    specifies for the DBMS what is required; the techniques used to process data,    determine how data must be structured to produce the user's view,    All of the above

Ans:A ,A


. The shortcut key is used to open properties window of selected item is
Options: a. Ctrl+Enter b. Shift+Enter c. Alt+Enter d. None of above

Ans:9 – c ,9 – c


. When the formula bar is activated, you can see
Options: a. The Edit Formula button b. The Cancel button c. The Enter button d. All of above

Ans:– d,– d


The rectangular boundary around a specific area on the display is called
Options: a window,    a conic section,    a view point,    a view plane

Ans:A ,A


In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Options: parent,    child,    instance,    subtype

Ans:A ,A


. Which of the following is default location of saving and opening file?
Options: a. Desktop b. My computer c. My documents d. All of above

Ans:6 – c ,6 – c


. It is the default folder for many Windows Applications to save your file
Options: a. My Document b. My Pictures c. Documents and Settings d. My Computer

Ans:7 – a ,7 – a


. Slide Rules was invented in
Options: A) 1614 B) 1617 C) 1620 D) None of above

Ans:C,C


Output segments of AI programming contain(s)
Options: printed language and synthesized speech,    Manipulation of physical object,    Locomotion,    All of the above

Ans:D ,D


.   Special effects used to introduce slides in a presentation are called
Options: a. Effects b. Custom animations c. Transitions d. Preset animations

Ans:4 – C ,4 – C


0. Windows displays various options to shutdown. Which is suitable at the end ofday?
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans: - a, - a


Human beings are referred to as Homosapiens. Which device is called Silico sapiens?
Options: Monitor,    Hardware,    Robot,    Computer

Ans:D ,D


Which of the following is not a characteristic of good test data
Options: users do not participate at this preliminary stage,    should be comprehensive,    every statement should be executed,    All of the above

Ans:A ,A


In analyzing the compilation of PL/I program, the term "Machine independent optimization" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:C ,C


. In MS Access “Hyperlink” Data Type can store
Options: a. Web Address b. email Address c. Path of a File d. All of Above

Ans:– d,– d


A network designer wants to connect 5 routers as point-to-point simplex line. Then the total number of lines required would be
Options: 5,    10,    20,    32

Ans:B ,B


Advantages of Relational Database Management systems are
Options: Flexibility, of relating different logical files,    Security controls can be more easily implemented.,    Data independence since it allows the database to grow by adding new attributes and relations.,    All of the above

Ans:D ,D


. You can activate a cell by
Options: a. Pressing the Tab key b. Clicking the cell c. Pressing an arrow key d. All of above

Ans:– d,– d


A disk scheduling algorithm in an operating system causes the disk arm to move back and forth across the disk surface in order to service all requests in its path. This is a
Options: First come first served,    Shortest Seek Time First (SSTE),    Scan,    FIFO

Ans:C ,C


. Which command is used to list out deleted files in DOS?
Options: a. list b. Undelete/list c. Recover d. All of the above

Ans:3 – b ,3 – b


Which of the following is a read only memory storage device?
Options:  Floppy Disk B.  CD-ROM      C.  Hard Disk D.  None of these

Ans:– B ,


The ability to combine name and addresses with a standard document is called _________ 
Options: a. document formatting b. database management c. mail merge d. form letters

Ans:–  C,–  C


Which of the following in true regarding Null Value?
Options: Null = 0 B. Null < 0 C. Null > 0 D. Null <> 0

Ans:– D ,


Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists

Ans: a, a


Most industrial control applications:
Options: can be solved using more than one method of control,    can be done more reliably using solid-state methods,    must have the process specified correctly to be successful,    All of the above

Ans:D ,D


The general systems model of the firm can be used
Options: to solve problems in college classes,    to ease the transition into a new company, upon graduation,    to solve problems as a manager,    All of the above

Ans:D ,D


The file structure that redefines its first record at a base of zero uses the term:
Options: relative organization,    key fielding,    dynamic reallocation,    hashing

Ans:A ,A


In a PC to telephone hookup for long distance communication, modem is connected between the telephone line and
Options: PC,    synchronous port,    crossover cable,    asynchronous port

Ans:D ,D


A typical modern computer uses
Options: LSI chips,    Vacuum tubes,    Valves,    All the above

Ans:A,A


What is a form in MS Access
Options: a. It is a printed page where users will write their data to fill it up b. It is an input screen designed to make the viewing and entering data easier c. This is an important part of database used by analysts to draw conclusions d. All of above

Ans:ndash; b,ndash; b


In SQL, which command(s) is(are) used to change a table's storage characteristics?
Options: ALTER TABLE,    MODIFY TABLE,    CHANGE TABLE,    All of the above

Ans:A ,A


______ shares characteristics with both hardware and software
Options: Operating system B. Software C. Data D. None

Ans:– A ,


Sequential retrieval on a primary key for sequential file storage has which of the following features?
Options: Very fast,    Moderately fast,    Slow,    Impractical

Ans:A ,A


. The brain of any computer system is
Options: A) Control Unit B) Arithmetic Logic Unit C) Central Processing Unit D) Storage Unit

Ans:C,C


Multivalued dependencies should ________ be eliminated.
Options: always,    commonly,    seldom,    never

Ans:A ,A


. What is the difference between ‘open’ and ‘open exclusively’
Options: a. Open statement opens access database files and open exclusively opens database files of other program like oracle b. Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed c. Both open and open exclusively are same d. Open exclusive command does not exist in MS Access

Ans:6 – b ,6 – b


Which of the following technique is used for encapsulation?
Options: a technique used in best-effort delivery systems to avoid endlessly looping packets.,    a technique used by protocols in which a lower level protocol accepts a message from a higher level protocol and places it in the data portion of the low level frame.,    One of the pieces that results when an IP gateway divides an IP datagram into smaller pieces for transmission across a network that cannot handle the original datagram size,    All of the above

Ans:B ,B


Which command will delete the contents of NVRAM on a router?
Options: delete NVRAM,    delete startup-config,    erase NVRAM,    erase start

Ans:D ,D


. An application program that helps the user to change any number and immediately see the result of that change is
Options: A) Desktop publishing program B) Database C) Spreadsheet D) All of above

Ans:2-C,2-C


Which of the following layer of OSI model also called end-to-end layer?
Options: Presentation layer B. Network layer C. Session layer D. Transport layer

Ans: – D ,


Which of the following is the latest version of MS Word?
Options:  A) Word 2000, B) Word 2007, C) Word 2010, D) Word 2011, 

Ans:-C,-C


. Which of the following concept is best to preventing page faults?
Options: a. Paging b. The working set c. Hit ratios d. Address location resolution

Ans:8 – b ,8 – b


. Ctrl + L
Options: Left Align B. Left Indent         C. Increase Left Margin D. Decrease Left Margin

Ans:– A ,


Which of the following memories needs refresh?
Options: DRAM B. SRAM C. ROM D. All of above

Ans:– A ,


. When was the company named IBM?
Options: A) 1914 B) 1924 C) 1975 D) None of above

Ans:7-B,7-B

www.000webhost.com