. What is the shortcut key to insert current date in a cell?


Options: CTRL + D B. CTRL + T C. CTRL + ; D. CTRL + /

Ans: – C ,






More MS-Excel Related questions:


The feasibilities studied in preliminary investigation is (are):
Options: technical feasibility,    economic feasibility,    operational feasibility,    All of the above

Ans:D ,D


Status indicators are located on the
Options: a. Vertical scroll bar b. Horizontal scroll bar c. Formula bar d. Standard toolbar

Ans:#8211; c,#8211; c


Instructions and memory address are represented by
Options: A) Character code B) Binary codes C) Binary word D) Parity bit

Ans:-B,-B


Which of the following is not user defined data type? 1 : struct book { char name[10]; float price; int pages; }; 2 : long int l = 2.35; 3 : enum day {Sun, Mon, Tue, Wed};
Options: 1,    2,    3,    Both 1 and 2

Ans:B ,B


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

Ans:A,


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

Ans:C,C


A _____ decision is routine one that's made following the completion of a preplanned series of steps.
Options: strategic,    structured,    simulation,    tactical

Ans:B ,B


. Which of the following is not a class of computers based on size?
Options: A) Mainframe Computers B) Mini Computers C) Micro Computers D) Super Computers

Ans:D,D


An integrated circuit is
Options: a complicated circuit,    an integrating device,    much costlier than a single transistor,    fabricated on a tiny silicon chip

Ans:D ,D


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

Ans:B,B


Network 206.143.5.0 was assigned to the Acme Company to connect to its ISP. The administrator of Acme would like to configure one router with the commands to access the Internet. Which commands could be configured on the Gateway router to allow Internet access to the entire network? Gateway(config)# ip route 0.0.0.0 0.0.0.0 206.143.5.2 Gateway(config)# router rip Gateway(config-router)# network 206.143.5.0 Gateway(config-router)# network 206.143.5.0 default
Options: 1 only,    3 only,    1, 2 and 4,    1 and 4

Ans:D ,D


The reserved word enum is used for which of the following?
Options: To define a range for an attribute.,    To define a range for a class.,    To define a range for a relationship.,    All of the above.

Ans:A ,A


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    none of the above

Ans:D,None of the above


Which of the following input/output devices is not associated with personal computers?
Options: mice,    color monitors,    punched cards,    dot-matrix printers

Ans:C,C


The principle of locality of reference justifies the use of
Options: reenterable,    non reusable,    virtual memory,    cache memory

Ans:D ,D


.   Which of the following best describes serifs?
Options: a. Serifs on characters help to differentiate between similar looking letters b. Serifs fonts are best for viewing test at a distance c. Serifs are fine cross strokes that appear at the bottom and top of a letter d. Serif font are very simple in appearance

Ans:0 – C ,0 – C


Floppy disks which are made from flexible plastic material are also called?
Options: hard disks,    high-density disks,    diskettes,    templates

Ans:C ,C


A UML diagram includes which of the following?
Options: Class name,    List of attributes,    List of operations,    All of the above.

Ans:D ,D


What is the similarity between a structure, union and enumeration?
Options: All of them let you define new values,    All of them let you define new data types,    All of them let you define new pointers,    All of them let you define new structures

Ans:B ,B


Programmers use _____ to organize and summarize the results of their problem analysis.
Options: Flowcharts,    Input charts,    IPO charts,    Output charts

Ans:C ,C


Quantitative evaluation of new products assures that
Options: the important factors receive management attention,    the factors are weighted according to their relative importance,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which of the following is the user programmed semiconductor memory?
Options: SRAM,    DRAM,    EPROM,    All of the above

Ans:C,C


A section of code that may only be executed by one process at any one time is
Options: CPM,    Critical resource,    Critical region,    Gray code

Ans:C ,C


What is the name given to the weapons which use computerised guidance system?
Options: Guided weapons,    Smart weapons,    Dumb weapons,    Starwars weapons

Ans:B,B


. List Box and Text box
Options: a.  Are some other than that in a list box the bullets are enabled b.  Are different. List boxes are used to present lists and can’t be created with text boxes. c.  Both of above d.  None of above

Ans:1 – A ,1 – A


A battery is a device composed of one or more:
Options: chemical cells,    voltage generators,    solar cells,    piezoeletric cells

Ans:A ,A


Which of the following is not valid version of MS Office?
Options: a. Office XP b. Office Vista c. Office 2007 d. None of above

Ans:– B,– B


. Registers which are partially visible to users and used to hold conditional codes (bits set by the CPU hardware as the result of operations), are known as
Options: A) PC B) Flags C) Memory Address Registers D) General Purpose Registers

Ans:B,B


The way a particular application views the data from the data base that the application uses is a :
Options: module,    relational model,    schema,    subschema

Ans:D ,D


You can select a single range of cells by
Options: a. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells b. Pressing the Ctrl key while dragging over the desired cells c. Pressing the Shift key and an arrow key d. Dragging over the desired cells

Ans:#8211; d,#8211; d


. Edit >> Delete command
Options: a.  Deletes the content of a cell b.  Deletes Formats of cell c.  Deletes the comment of cell d.  Deletes selected cells

Ans:– d,– d



Options: format, header and footer B. view, footer C. insert, header and footer D. view, header and footer

Ans:– D ,


. How can you remove borders applied in cells?
Options: a. Choose None on Border tab of Format cells b. Open the list on Border tool in Formatting toolbar then choose first tool (no border) c. Both of above d. None of above

Ans:– c,– c


Which key is used to select all the text in the document?
Options: Ctrl+T B. Ctrl+A C. Ctrl+F D. Ctrl+N

Ans:– B ,


A relationship between processes such that each has some part (critical section) which must not be executed while the critical section of another is being executed, is known as
Options: semaphore,    mutual exclusion,    multiprogramming,    multitasking

Ans:B ,B


What is the byte capacity of a drum which is 5 inch high, 10 inch diameter, and which has 60 tracks per inch and bit density of 800 bits per inch?
Options: 942000 bytes,    9712478 bytes,    192300 bytes,    14384 bytes

Ans:A ,A


The data-base environment has all of the following components except:
Options: users,    separate files,    data base,    data-base administrator

Ans:B ,B


What should he used to extinguish a computer fire?
Options: fire hose,    class a extinguisher,    class c extinguisher,    silver foam water

Ans:C ,C


How would you allow device drivers and TSR's to be loaded into Upper Memory Blocks?
Options: DOS=High,    Devicehigh=,    Loadhigh=,    DOS=UMB

Ans:D ,D


The terms "red book", "yellow book", and "orange book" refer to:
Options: SCSI,    ide,    floppy drive technology,    CD-ROM standards

Ans:D ,D


The minimum number of MOS transistors required to make a dynamic RAM cell is
Options: 1,    2,    3,    4

Ans:A ,A


Which of the following terms refers to the degree to which data in a database system are accurate and correct?
Options: data security,    data validity,    data independence,    data integrity

Ans:D ,D


. In Computer System Memory management operations are performed by
Options: User B. Hardware       C. Programmer D. Operating system

Ans:– D ,


Which command would you place on interface connected to the Internet?
Options: ip nat inside,    ip nat outside,    ip outside global,    ip inside local

Ans:B ,B


. Generally quick launch toolbar is displayed on
Options: a. the left side of taskbar b. the right side of taskbar c. on the middle of taskbar d. a bar out of taskbar

Ans:4 – a ,4 – a


The _____ houses the switches in token ring.
Options: transceiver,    nine-pin connector,    MAU,    NIC

Ans:C ,C


A Dumb terminal has
Options: Processor and Keyboard B. Processor and Hard Disk C. Keyboard and Hard Disk D. Keyboard and Screen

Ans:– D ,


. Which of the following is input device?
Options: A) scanner B) speaker C) monitor D) projector

Ans:A,A


Does there any function exist to convert the int or float to a string?
Options: Yes,    No,    ,    

Ans:A ,A


Which of the following layer protocols are responsible for user and the application programme support such as passwords, resource sharing, file transfer and network management?
Options: Layer 7 protocols,    Layer 6 protocols,    Layer 5 protocols,    Layer 4 protocols

Ans:A ,A

www.000webhost.com