. What is the shortcut key to hide entire column?


Options: CTRL + − B. CTRL + 0             C. CTRL + H D. CTRL + C

Ans:– B ,






More MS-Excel Related questions:


The "Turing Machine" showed that you could use a/an _____ system to program any algorithmic task.
Options: binary,    electro-chemical,    recursive,    semantic

Ans:A ,A


. The effect applied to display when slides changes in slide show view is
Options: a.  Slide Animation b.  Custom Animation c.  Custom Transition d.  Slide Transition

Ans:7 – D ,7 – D


Dust in a computer actually increases the size of the magnetic fields inside it. This is not good, so you must occasionaiy dust, I trust. What
Options: reverse vacuum,    any small vacuum device,    blow real hard on the system board,    non-static compressed air

Ans:non-static compressed air ,D


A part of database that stores only  one type of data is
Options: a. Report b. Field c. Query d. Record

Ans:ndash; b,ndash; b


What is the process lag?
Options: The time it takes for the sensor to respond to a changed.,    The lag in the error signal when the setpoint is changed.,    The time it takes for the mass of the process to respond to an input change.,    All of the above

Ans:C ,C


Before a disk drive can access any sector record, a computer program has to provide the record’s disk address. What information does this address specify?
Options: A) Track number B) Sector number C) Surface number D) All of above

Ans:-D,-D


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


Which of the following is true when describing a multicast address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    Packets are delivered to all interfaces identified by the address. This is also called a one-to-many address.,    Identifies multiple interfaces and is only delivered to one address. This address can also be called one-to-one-of-many.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:B ,B


Computers cannot communicate with each other directly over telephone lines because they use digital pulses whereas telephone lines use analog sound frequencies. What is the name of the device which permits digital to analog conversion at the start of a long distance transmission?
Options: Interface,    Modem,    Attenuation,    Teleprocessor

Ans:B ,B


What is the term used to describe addresses available on a DHCP server?
Options: Pools,    Scopes,    Ranges,    Notes

Ans:B ,B


A card on the top of pack of cards containing information about the cards in the pack is
Options: Punched card,    Card punch,    Reader card,    Punched paper tape

Ans:C ,C


The voltage across a 1N4001 is 0.93V when the current is 1A. What is the power dissipation of the diode for these values?
Options: 0.93 W,    0.93 V,    1 A,    9.3 W

Ans:A ,A


Which of the following IC was used in third generation of computers?
Options: A) SSI B) MSI C) LSI D) Both a and b

Ans:-D,-D


. 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


To find out how much memory is available, you could type _____
Options: EMM,    MEM,    CHKDSK,    MEMMAKER

Ans:B ,B


A prewritten program that's sold to perform a common task is called an application
Options: System software,    Package,    Utilities,    Program

Ans:B ,B


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 is considered a direct entry input device?
Options: Optical scanner,    All of the above,    Light pen,    Digitizer

Ans:All of the above,All of the above


.   Which of the following features allows you to view slides in a slide show without manually advancing each slide?
Options: a. Adding build effects b. Setting slide times c. Adding transitions d. All of these

Ans:4 – B ,4 – B


16. MSD . exe does not have information on:
Options: a. Cache b. Video c. Operating System d. Com or port

Ans:Correct answer: a,Correct answer: a


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B,(Banswer


What resistence in ohms should be displayed ehen testing a speaker in a computer?
Options: 0 Ohms,    16 Ohms,    -200 Ohms,    Unlimited Ohms

Ans:B ,B


If a switch receives a frame and the source MAC address is not in the MAC address table but the destination address is, what will the switch do with the frame?
Options: Discard it and send an error message back to the originating host,    Flood the network with the frame,    Add the source address and port to the MAC address table and forward the frame out the destination port,    Add the destination to the MAC address table and then forward the frame

Ans:C ,C


. Napier Bones were invented in
Options: A) 1614 B) 1617 C) 1620 D) None of above

Ans:B,B


For you to create a swap partition by using fdisk, what must the partition's system ID type be?
Options: 83,    82,    5,    4

Ans:B ,B


. The �.can be defined as the entire windows display and can be envisioned as the electronic equivalent of your own desk�s surface
Options: a. Desktop b. Windows c. Dialog box d. None of above

Ans:6 – a ,6 – a


ow to remove all character formats?
Options: Shift + Spacebar B. Shift + Enter C. Ctrl + Spacebar D. Ctrl + Enter

Ans:– C ,


Properties that describe the characteristics of entities are called:
Options: entities.,    attributes.,    identifiers.,    relationships.

Ans:B ,B


The CCITT Recommendation X.25 specifies three layers of communications:
Options: application, presentation and session,    Session, transport and network,    physical datalink and network,    datalink, network and transport

Ans:C ,C


. Microprocessors can be used to make
Options: A) Computer B) Digital systems C) Calculators D) All of the above

Ans:1-D,1-D


The complete picture of data stored in database is known as
Options: Record,    Schema,    System flowchart,    DBMS

Ans:B,(Banswer


Page Up Key
Options: a. Moves the cursor one line up b. Moves the cursor one screen up c. Moves the cursor one page up d. Moves the cursor one paragraph up

Ans:–  B,–  B


.   Which of the following options changes the fill color of an object back to the default color?
Options: a. Template b. Automatic c. Patterns d. Fill colors

Ans:1 – B ,1 – B


Which of the following commands is used to remove files with confirmation prompt from the user file system which have neither been accessed nor modified i the last one year?
Options: find -mtime +365 | rm,    grep (/usr/*) - mtime + 365 | -ok rm,    find -name - mtime + 365 / - ok rm,    find /user/* \(-mtime + 365 - a - atime +365 \) - OK rm {} \;

Ans:D ,D


What does RIPv2 use to prevent routing loops? CIDR Split horizon Authentication Classless masking Holddown timers
Options: 1 and 3,    2, 3 and 5,    2 and 5,    3 and 4

Ans:C ,C


. Selecting the Column G & H then choose Insert->Columns. What will happen?
Options: 2 Columns will be inserted after Column F B. 2 Columns will be inserted after Column G C. 2 Columns will be inserted after Column H D. 2 Columns will be inserted after Column I

Ans:– A ,


. A small or intelligent device is so called because it contains within it a

Options: A) Computer B) Microcomputer C) Programmable D) Sensor

Ans:D,D


Continuous line drawing are produced using
Options: Chain printers,    Daisy wheel printers,    Plotters,    Thermal devices

Ans:C,C


A database server is responsible for which of the following?
Options: Database storage,    Data processing logic,    Data presentation logic,    All of the above.

Ans:A ,A


Stephanie is in charge of a small network and wants to make it simple but secure. The users want to have full control over their data and still be able to share data with the rest of the office. The networking knowledge of the office staff is basic. Which network(s) would be the best for Stephanie to set up?
Options: Peer-to-peer,    Master domain,    Server-based,    WAN

Ans:C ,C


The benefits of a standard relational language include which of the following?
Options: Reduced training costs,    Increased dependence on a single vendor,    Applications are not needed.,    All of the above.

Ans:A ,A


You save the configuration on a router with the copy running-config startup-config command and reboot the router. The router, however, comes up with a blank configuration. What can the problem be?
Options: You didn't boot the router with the correct command.,    NVRAM is corrupted.,    The configuration register setting is incorrect.,    The newly upgraded IOS is not compatible with the hardware of the router.

Ans:C ,C


Which of the following describes the creation of private networks across the Internet, enabling privacy and tunneling of non-TCP/IP protocols?
Options: HDLC,    Cable,    VPN,    IPSec

Ans:C ,C


Software is:
Options: printer output,    a set of instructions,    tape input.,    a programming language

Ans:B ,B


The first step in the problem-solving process is to _____.
Options: Plan the algorithm,    Analyze the problem,    Desk-check the algorithm,    Evaluate and modify (if necessary) the program

Ans:B ,B


Off-line operation is the operation of devices without the control of
Options: Memory,    CPU,    ALU,    Control unit

Ans:B ,B


. The Name box
Options: a. Shows the location of the previously active cell b. Appears t the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:– b,– b


. Which of the following methods cannot be used to edit the content of cell?
Options: a. Pressing the Alt key b. Clicking the formula bar c. Pressing F2 d. Double clicking the cell

Ans:– a,– a


Which of the following is true when describing a unique local address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    These are your typical publicly routable addresses, just like a regular publicly routable address in IPv4.,    These are like private addresses in IPv4 in that they are not meant to be routed.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:D ,D


. You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
Options: a. Insert b. Copy c. Undo d. Replace

Ans:– c,– c

www.000webhost.com