. Which of the following is correct?


Options: =POWER(2^3) B. =POWER(2,3)             C. =POWER(2#3) D. =POWER(2*3)

Ans:– B ,






More MS-Excel Related questions:


. Which of the following command is used to close the active window?
Options: a. Ctrl+F4 b. Ctrl+F5 c. Alt+F6 d. None of above

Ans:8 – a ,8 – a


Which of the following are true regarding OSPF areas? You must have separate loopback interfaces configured in each area. The numbers you can assign an area go up to 65,535. The backbone area is also called area 0. If your design is hierarchical, then you don't need multiple areas. All areas must connect to area 0.
Options: 1 only,    1 and 2 only,    3 and 4 only,    3, 4 and 5

Ans:D ,D


Which of the following command addresses all users who are currently hooked on?
Options: write,    mail,    wall,    mesg

Ans:C ,C


Condensing output data to exhibit specific information is
Options: Calculating,    Recording,    Merging,    Summarising

Ans:D ,D


Virtual memory is
Options: simple to implement,    used in all major commercial operating systems,    less efficient in utilization of memory,    useful when fast I/O devices are not available

Ans:B ,B


The data recording area between the blank gaps on magnetic tape is called a/ an:
Options: Record,    Block,    Field,    Database

Ans:B ,B


When operating above its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated below its resonant frequency,    purely resistive circuit

Ans:A ,A


Who invented Java?
Options: Netscape,    Microsoft,    Sun,    None of the above is correct.

Ans:C ,C


Filename extensions help identify certain files. What filename extension identifies executable files?
Options: INF,    PRO,    EXE,    SYS

Ans:C ,C


What is the use of Bridge in Network?
Options:  to connect LANs B.  to separate LANs C.  to control Network Speed D.  All of the above

Ans:– A ,


Strong AI is
Options: the embodiment of human intellectual capabilities within a computer.,    a set of computer programs that produce output that would be considered to reflect intelligence if it were generated by humans.,    the study of mental faculties through the use of mental models implemented on a computer.,    All of the above

Ans:A ,A


What is the recommended way to fix the registry description for the printer driver
Options: Delete the spool file,    Run regedit.exe and remove any reference to the printers,    Run sysedit.exe and remove any reference to the printers,    Remove the printer driver and re¬install it

Ans:D ,D


The communication mode that supports data in both directions at the same time is
Options: simplex,    half-duplex,    full-duplex,    multiplex

Ans:C ,C


When did IBM close the last of its punched card manufacturing plant?
Options: June, 1989,    December, 1984,    March, 1982,    November, 1979

Ans:B ,B


Which of the following is not a Storage Manager Component?
Options: Transaction Manager B. Logical Manager C. Buffer Manager D. File Manager

Ans:– B ,


Excel probably considers the cell entry January 1, 2000 to be a
Options: a. Label b. Value c. Formula d. Text string

Ans:#8211; b,#8211; b


Large collection of files are called
Options: a . fields b . records c . database d . sectors

Ans:.c,.c


While working with MS-DOS, which command is used to force DOS to recheck all clusters when reformatting a disk?
Options: FORMAT/B,    FORMAT/S,    FORMAT/8,    FORMAT/C

Ans:D ,D


. Which converts the user data into machine readable form?

Options: A) input unit, outpu unit, control unit B) central processing unit C) output unit D) decoder unit

Ans:A,A


. In the third Generation of computers

Options: A) Distributed data processing first became popular B) An operating system was first developed C) High level procedural language were first used D) Online real time systems first become popular

Ans:B,B


The command chmod 761 letter is equivalent to
Options: chmod 4=7, g = 6, o = 1 letter,    chmod a = 761 letter,    chmod u = rwx, g = rw, o = x letter,    chmod 167 letter

Ans:C ,C


Multiprogramming systems:
Options: are easier to develop than single programming system,    execute each job faster,    execute more jobs in the same time period,    are used only on large mainframe computers

Ans:C ,C


What script is run for setting bash global defaults for all users?
Options: /etc/.profile,    /etc/.bashrc,    /etc/.log,    /etc/profile

Ans:D ,D


In SQL, the _____ command is used to recompile a view
Options: COMPILE VIEW,    DEFINE VIEW,    CREATE VIEW,    ALTER VIEW

Ans:D ,D


_____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Options: a. Document b. Character c. Paragraph d. Object

Ans:– B,– B


13. The file type _____ indicates the file is a Word document.
Options: a. .msw b. .wor c. .wrd d. .doc

Ans:– D ,– D


A vertically aligned set of tracks on a disk pack is known as
Options: Cluster,    Surface,    Cylinder,    Panel

Ans:C ,C


. Descending Order of a data Hierarchy is
Options: Database – File – Record – Fields – Bytes – Bit B. Database – File – Record – Fields – Bit – Bytes C. Database – Record – File – Fields – Bytes – Bit D. Database – Record – Fields – File – Bytes – Bit

Ans:– A ,


. Excel is a
Options: a. Graphic program b. None of these c. Word processor d. A spreadsheet

Ans:– d,– d


. What happens when a user selects a record in a form and presses [Delete]?
Options: a. The record is deleted in the form and from its source table. b. The record is deleted in the form, but not from its source table. c. The record is neither deleted in the form, nor from its source table. d. The record is not deleted in the form, but is deleted from its source table.

Ans:8 – a ,8 – a


. From where can we set the timing for each object?
Options: a. slide show, custom transition b. Slide show, Slide transition c. slide show, custom animation d. view, slide sorter

Ans:1 – C ,1 – C


What is meant by quad-density (QD) diskette?
Options: It is double-sided disk,    It is double density disk,    It has double the number of tracks per inch,    All of the above

Ans:D,D


. When did IBM introduce the 20286 based PC/AT?
Options: A) 1982 B) 1984 C) 1985 D) 1989

Ans:B,B


Which of the following processor is software that accepts user ideas, manipulates and reorganises them in user-specified ways and then produces a refined model of those thoughts.
Options: Distribute,    Out-line,    Multi,    On-line

Ans:B ,B


Natural language understanding is used in:
Options: natural language interfaces,    natural language front ends,    text understanding systems,    All of the above

Ans:D ,D


In a large DBMS
Options: a. each user can "see" only a small part of the entire database b. each subschema contains every field in the logical schema c. each user can access every subschema  

Ans:9. a ,9. a


The entity integrity rule states that:
Options: no primary key attribute may be null.,    no primary key can be composite.,    no primary key may be unique.,    no primary key may be equal to a value in a foreign key.

Ans:A ,A


. Which command is used to delete all the files from root directory of drive A?
Options: a. Del a: b. Del *.* c. Del A d. Erase *

Ans:3 – a ,3 – a


What protocol(s) is(are) allowed a user to retrieve her/his mail from the mail server to her/his mail reader?
Options: POP3,    FTP,    MAP,    All of the above

Ans:A ,A


The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B,(Banswer


The CPU chip used in a computer is partially made out of:
Options: Copper,    Iron,    Gold and silver,    Silica

Ans:D ,D


_______ controls all the main slide control tasks for your presentation.
Options: a. Task Pane b. Task Bar c. Control Panel d. None of above

Ans:– A ,– A


Which of the following operations are INCORRECT?
Options: int i = 35; i = i%5;,    short int j = 255; j = j;,    long int k = 365L; k = k;,    float a = 3.14; a = a%3;

Ans:D ,D


What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options:  Compiler B.  Interpreter C.  Debugger D.  Assembler

Ans:– D ,


The characteristics of strategic decisions include all of the following except:
Options: they are structured,    they are future oriented,    they have a high level of uncertainty,    they are concerned with long-range plans

Ans:A ,A


. 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


Using OQL, you may do which of the following?
Options: Return an entire collection of elements including duplicates.,    Return a collection of elements without duplicates.,    Return a specific subset of elements using a given criteria.,    All of the above.

Ans:D ,D


A symbol that modifies an action is known as
Options: Compiler,    Modifier,    Interpreter,    Mod

Ans:B ,B


In the following program how long will the for loop get executed? #include<stdio.h> int main() { int i=5; for(;scanf("%s", &i); printf("%d\n", i)); return 0; }
Options: The for loop would not get executed at all,    The for loop would get executed only once,    The for loop would get executed 5 times,    The for loop would get executed infinite times

Ans:D ,D


. Which command used to delete all files from current directory?
Options: a. Del, ,b. Deltree/y * ,c. Del *.* , d. All of the above

Ans:4 – c ,4 – c

www.000webhost.com