How many worksheets can a workbook have?


Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,






More MS-Excel Related questions:


  A File which contains readymade styles that can be used for a presentation is called :
Options: AutoStyle B. Template C. Wizard D. Pre formatting

Ans:– B ,


A shared database should:
Options: be accurate and available.,    provide for backup and recovery.,    be secure.,    All of the above.

Ans:D ,D


. Which of the following professions has not been affected by personal computers?
Options: A) Medical B) Clerical and law C) Accounting D) None of the above

Ans:D,D


A computer-controlled device for training exercises that duplicates the work environment is a:
Options: simulator,    duplicator,    trainer,    COM device

Ans:A ,A


. What is Thrashing?
Options: a. A high paging activity is called thrashing. b. A high executing activity is called thrashing c. A extremely long process is called thrashing d. A extremely long virtual memory is called thrashing

Ans:8 – a ,8 – a


What command is used to hang up a MODEM when using the "AT Command set"?
Options: ATZ,    ATD,    ATR,    ATH

Ans:D ,D


Match the device driver HIMEM.SYS to its operation.
Options: Supports (ANSI) terminal emulation,    Manages the use of extended memory,    Uses expanded memory on a 80386 processor,    Supports code page switching

Ans:B ,B


The X.25 standard specifies a
Options: technique for start-stop data,    technique for dial access,    DTE/DCE interface,    data bit rate

Ans:C ,C


________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:A ,A


. One of a class of storage device devices that can access storage locations in any order is

Options: A) DTE B) DASD C) DDE D) DDE

Ans:B,B


Which command is used to list all the files with extension .lst?
Options: ls -l *.lst,    ls lst*,    ls *.*,    ls *[lst]

Ans:A ,A


. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
Options: a. display all customers with CustID from 10 to 100 b. display all customers with CustID above 10 c. display all customers with CustID below 100 d. display all customers with CustID from 11 to 99

Ans:– d,– d


A sizeable geographical area with communication based on the telephone system is though as
Options: Local area network,    Wide area network,    Modulator-Demodulator,    All of the above

Ans:B ,B


. CAD software is most likely to be used by
Options: a. Web designer b. Engineers c. Project Manager d. Magazine Editor

Ans:0 – b ,0 – b


What command is used to assign executable permission to all of the files named "report"?
Options: chmod ugo + x report,    chmod u + x report,    chmod ugo + rw report,    chmod ugo + r report

Ans:A ,A


. The value of each bead in earth is
Options: A) 1 B) 3 C) 5 D) 7

Ans:A,A


When MS-DOS formats a disk, it automatically creates the main directory on your disk, which is called the _____ directory.
Options: main,    root,    area,    border

Ans:B ,B


What is a stub network?
Options: A network with more than one exit point.,    A network with more than one exit and entry point.,    A network with only one entry and no exit point.,    A network that has only one entry and exit point.

Ans:D ,D


What will be the output of the program (myprog.c) given below if it is executed from the command line? cmd> myprog one two three /* myprog.c */ #include<stdio.h> #include<stdlib.h> int main(int argc, char **argv) { printf("%s\n", *++argv); return 0; }
Options: myprog,    one,    two,    three

Ans:B ,B


Skipping every other line and picking up the skipped lines on the second pass is called:
Options: interlacing,    refresh-vector,    raster-scan,    stroke writing

Ans:A ,A


_____ means that the manager spends his or her time dealing with exceptions or those situations which are out of control
Options: relevant,    management by exception,    predictive reports,    control

Ans:B ,B


Satellite-Switched Time-Division Multiple Access (SS/TDMA) is
Options: the method of determining which device has access to the transmission medium at any time.,    a medium access control technique for multiple access transmission media,    a form of TDMA in which circuit switching is used to dynamically change the channel assignments,    All of the above

Ans:C ,C


Which of the following is not considered to be a basic element of an enterprise-class database system?
Options: Users,    Database applications,    DBMS,    COBOL programs

Ans:D ,D


One nibble is equal to
Options: 4 bits,    8 bits,    6 bits,    16 bits

Ans:A ,A


. First operating system was developed in
Options: a. 1958 b. 1976 c. 1950 d. 1946

Ans:5 – c ,5 – c


A group of 2m - 1 routers are interconnected in a centralized binary tree, with router at each tree node. Router I communicate with router J by sending a message to the root of the tree. The root then sends the message back down to J. Then find the mean router-router path length.
Options: 2 (m - 2),    2 (2m - 1),    m - 1,    (2m - l)/mJ

Ans:A ,A


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


. Multiple calculations can be made in a single formula using…..
Options: a. Standard Formulas b. Array Formula c. Complex Formulas d. Smart Formula

Ans:– b,– b


Which of the following protocols support VLSM, summarization, and discontiguous networking? RIPv1 IGRP EIGRP OSPF BGP RIPv2
Options: 1 and 4,    2 and 5,    3, 4 and 6,    All of the above

Ans:C ,C


Which of the following medium is used for broadband local networks?
Options: Coaxial cable,    optic fiber,    CATV,    UTP

Ans:C ,C


Which of the following pane is not available in Task Pane?
Options: a. Getting Started b. Clip Art c. Word Art d. Search Results

Ans:– C ,– C


. Which query do you use to answer the question “What is the average salary of the employees”?
Options: a. Search query b. Cross tab query c. Select query d. Update query

Ans:– c,– c


. The commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above

Ans:D,D


. Which of the following options in the printer dialog box would you select to print slides 5 and 12 in a presentation?
Options: a. Slides b. Custom shows c. Current slide d. All

Ans:6 – A ,6 – A


Which of the following are examples of software development tools?
Options: debuggers,    editors,    assemblers, compilers and interpreters,    All of the above

Ans:D ,D


The 32-bit internet address 10000000 00001010 00000010 00011110 will be written in dotted decimal notation as
Options: 128.10.2.30,    210.20.2.64,    164.100.9.61,    148.20.2.30

Ans:A ,A


A one-bit signal that indicates the start of data transmission by an asynchronous device is
Options: Parity bit,    Status bit,    Zero bit,    Start bit

Ans:D ,D


The binary equivalent of 5.375 is
Options: 101.101110111,    101.011,    101011,    None of above

Ans:B ,B


SQL data definition commands make up a(n) ________ .
Options: DDL,    DML,    HTML,    XML

Ans:A ,A


A number that is used to control the form of another number is known as
Options: Map,    Mask,    Mamtossa,    Marker

Ans:B,(Banswer


Which 32-bit microprocessor is used in IBM's PS/2 model-80 computer?
Options: 8088,    80286,    80386,    80486

Ans:C,C


. Excel uniquely identifies cells within a worksheet with a cell name
Options: a. Cell names b. Column numbers and row letters c. Column letters and row numbers d. Cell locator coordinates

Ans:– c,– c


The total impedance of a parallel RLC circuit:
Options: always increases as the applied frequency increases,    is equal to the sum of the values of resistance, inductive reactance and capacitive reactance,    always decreases as the applied frequency increases,    is maximum at the resonant frequency

Ans:D ,D


Data mining applications are used accomplish which of the following tasks?
Options: Process transactions only,    Do RFM analysis only,    Do what-if analysis only,    Do both RFM and what-if analysis

Ans:C ,C


. Clear the contents by pressing “DELETE” key from a keyboard will clear
Options: Text Only B. Format Only C. Contents Only D. Both Contents and Format

Ans:– C ,


0. Ctrl + T
Options: Hanging Indent B. Left Indent C. Open Tabs Dialog box D. Terminate all opened Dialog box

Ans: – A ,


Which access method is used for obtaining a record from a cassette tape
Options: direct,    sequential,    random,    All of the above

Ans:B ,B


. To select an entire column in MS-EXCEL, press?
Options: a. CTRL + C b. CTRL + Arrow key c. CTRL + S d. None of the above

Ans:– d,– d


. ______ is most often done after fixing a problem, adding a new program or making configuration change
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans:2 – b ,2 – b


What is a compiler?
Options:  A compiler does a conversion line by line as the program is run B.  A compiler converts the whole of a higher level program code into machine code in one step C.  A compiler is a general purpose language providing very efficient execution D.  None of the above

Ans:– B ,

www.000webhost.com