. In order to perform a calculation in a spreadsheet, you need to use a:


Options: table B. formula C. field D. variable

Ans: – B ,






More MS-Excel Related questions:


A __ name must be unique within a database
Options: a. Table b. Field c. Record d. Character

Ans:ndash; a,ndash; a


Determine the resistance value and tolerance of a resistor that has the following color bands; first band is red, second band is red, third band is orange, and the fourth band is gold
Options: 220 Ohm, 5%,    220 Ohm, 10%,    22,000 Ohm, 5%,    22, 000 Ohm, 10%

Ans:C ,C


A servo controlled robot:
Options: stop only at fixed points on each axis,    can accelerate,    must be hydraulically driven,    must be electrically driven

Ans:B ,B


The Josephson tunneling device illustrates principles associated with the advanced storage technique:
Options: cryogenics,    CCD,    EBAM,    holographing

Ans:A ,A


What protocols are used to configure trunking on a switch? VLAN Trunking Protocol VLAN 802.1Q ISL
Options: 1 and 2,    3 and 4,    1 only,    2 only

Ans:B ,B


The first microprocessor built by the Intel Corpn. was called
Options: 8008,    8080,    4004,    8800

Ans:C,C


. Gutter position can be set in following positions
Options: Left & Right B. Left & Top C. Left & Bottom D. Left Only

Ans:– B ,


. The storage subsystem in a microcomputer consists mainly of __ or __ media with varying capacities
Options: A) Memory or video B) Magnetic or optical C) Optical or memory D) Video or magnetic

Ans:B,B


. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
Options: a. 7 b. 17 c. 60 d. Not enough information to tell

Ans:5 – c ,5 – c


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


If the client receives an address from a DHCP server, what is the only information available in the Network Properties dialog box?
Options: The IP address,    The subnet address,    That the client is receiving its address from DHCP,    The default gateway

Ans:C ,C


. In which language is source program written?
Options: A) English B) Symbolic C) High level D) Temporary

Ans:C,C


Data item characteristics that are important in data management include
Options: punctuation,    language,    spelling,    width

Ans:D ,D


. The __________ determines how long you must hold down an alphanumeric key before the keyboard will repeat the character.
Options: a. strike rate b. repeat rate c. default rate d. threshold rate

Ans:0 – b ,0 – b


Most current PC CAD systems are used for producing:
Options: solids modeling,    2-D drawings,    circuit simulation,    finite element analysis

Ans:B ,B


Programmable controllers:
Options: are programmed using relay ladder logic,    cannot perform functions other than relay logic,    are widely used in many different industries,    (a) and (c) above

Ans:D ,D


Point out the error in the program? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a z1 = {512}; union a z2 = {0, 2}; return 0; }
Options: Error: invalid union declaration,    Error: in Initializing z2,    No error,    None of above

Ans:B ,B


The first machine to successfully perform a long series of arithmetic and logical operations was:
Options: ENIAC,    Mark I,    Analytic engine,    UNIVAC-I

Ans:B ,B


The longest method of conversion is
Options: direct,    parallel,    phased,    pilot

Ans:A ,A


What is the language used by most of the DBMSs for helping their users to access data?
Options: a. High level language b. SQL c. Query Language d. 4GL

Ans:. c ,. c


What is meant by a dedicated computer?
Options: a . which is used by one person only b . which is assigned to one and only one task c . which does one kind of software d . which is meant for application software only

Ans:3.b,3.b


The DBA is
Options: a person,    a computer device,    a communication technique,    All of the above

Ans:D ,D


In which mode, each user has a local input/output device.
Options: Interactive,    Time sharing mode,    Batch processing mode,    All of the above

Ans:B ,B


Which area in an excel window allows entering values and formulas
Options: a. Title bar b. Menu bar c. Formula bar d. Standard toolbar

Ans:#8211; c,#8211; c


You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
Options: Open [FileName],    Show [FileName],    Alter [FileName],    Edit [FileName]

Ans:D ,D


An automatic machine that performs routine seemingly human tasks is
Options: KIPS,    AI,    PL,    Robot

Ans:D ,D


Most important advantage of an IC is its
Options: Easy replacement in case of circuit failure,    Extremely high reliability,    Reduced cost,    Low power consumption

Ans:B ,B


. Which of the following in not Outer join?
Options: Left outer join B. Right outer join C. Full outer join D. All of the above

Ans: – D ,


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

Ans:A ,A


. When you start up the computer the boot up storage at which the BIOS versions manufacturer and data are displayed on the monitor is called
Options: a. Bootstrap b. Power on self test (POST) c. System configuration d. Kernel loading

Ans: b, b


Which of the following is used to insure the high quality of computer output?
Options: computer output microfilm,    output controls,    voice output systems,    liquid crystal display

Ans:B ,B


. How to insert Tables in Slide?
Options: a. Insert Table from Insert menu b. Click on Insert Table in content pane of blank slide c. Option A & B d. Tables cannot be inserted in slides

Ans:4 – C ,4 – C


Which of the following is not a factor in the failure of a systems development project ?
Options: inadequate user involvement,    failure of systems integration,    size of company,    continuation of a project that should have been cancelled

Ans:C ,C


which of the following is not an Aggregate function?
Options: Min B. Max C. Select D. Avg

Ans:– C ,


. You can select My Computer icon and press Alt + Enter to
Options: a. Delete it from desktop permanently b. Open it in Explorer mode c. Open System Properties dialog box d. Pin it on Start menu

Ans:3 – c ,3 – c


You need to gather the IP address of a remote switch that is located in Hawaii. What can you do to find the address?
Options: Issue the show ip arp command on the router connected to the switch.,    Issue the show ip route command on the router connected to the switch.,    Issue the show cdp neighbor command on the router connected to the switch.,    Issue the show cdp neighbors detail command on the router connected to the switch.

Ans:D ,D


An operating system intended for use on microprocessor based systems that support a single user is
Options: PC-DOS,    MS-DOS,    UNIX,    CP/M

Ans:D,(Danswer


Which of the following is (are) the characteristic(s) of a system?
Options: organization,    Interaction,    Interdependence,    All of the above

Ans:D ,D


Which layer 4 protocol is used for a Telnet connection?
Options: IP,    TCP,    TCP/IP,    UDP

Ans:B ,B


What will be the output of the program? #include<stdio.h> int main() { struct s1 { char *z; int i; struct s1 *p; }; static struct s1 a[] = {{"Nagpur", 1, a+1} , {"Chennai", 2, a+2} , {"Bangalore", 3, a} }; struct s1 *ptr = a; printf("%s,", ++(ptr->z)); printf(" %s,", a[(++ptr)->i].z); printf(" %s", a[--(ptr->p->i)].z); return 0; }
Options: Nagpur, Chennai, Bangalore,    agpur, hennai, angalore,    agpur, Chennai, angalore,    agpur, Bangalore, Bangalore

Ans:D ,D


. A zip is a program used to
Options: a. Speed up the computer memory b. Speed up the disk access c. Compress files d. All of above

Ans:7 – c ,7 – c


What is the maximum data rate for the 802.11b standard?
Options: 6Mbps,    11Mbps,    22Mbps,    54Mbps

Ans:B ,B


The main difference between synchronous and asynchronous transmission is
Options: the clocking is derived from the data in synchronous transmission,    the clocking is mixed with the data in asynchronous transmission,    the pulse height is different.,    the bandwidth required is different

Ans:A ,A


Educational programs for the labour union officials are conducted by
Options: the firm's industrial relations department,    the vice-president of information systems,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which of the following types of connections can use full duplex? Hub to hub Switch to switch Host to host Switch to hub Switch to host
Options: 1, 2 and 4,    3 and 4,    3 and 5,    2, 3 and 5

Ans:D ,D


Which of the following is a method to create a new table in MS Access?
Options: a. Create table in Design View b. Create Table using wizard c. Create Table by Entering data d. All of above

Ans:ndash; d,ndash; d


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B,(Banswer


In LISP, the function (minusp (-20 4 8 8 1) returns
Options: T,    F,    NIL,    -20

Ans:A ,A


A regular subquery can be processed:
Options: from the top down.,    from the bottom up.,    by nesting.,    None of the above is correct.

Ans:B ,B


Which of the following may be classified as an automation system?
Options: automated warehouses,    numerically controlled machine tools,    robotics,    All of the above

Ans:D ,D

www.000webhost.com