0. In Excel _______ may not contain in Formula


Options: Text Constant B. Number Constant C. Circular Reference D. All of them

Ans: – C ,






More MS-Excel Related questions:


How many bits are used in the data bus?
Options: 7,    8,    9,    16

Ans:B ,B


Changing the appearance of a document is called
Options:  A) Proofing, B) Editing, C) Formatting, D) All of above, 

Ans:-C,-C


Communication using a modulated carrier to apply a data signal to a transmission medium in analog form is
Options: Local area network,    Modem,    Base band networking,    Broad band networking

Ans:D ,D


. Most of the first generation computers were
Options: A) Special purpose computers B) General purpose computers C) Both of above D) None of above

Ans:A,A


. Which OS deos not support networking between computers?
Options: a. Windows 3.1 b. Windows 95 c. Windows 2000 d. Windows NT

Ans: a, a


To drop a column that is used as a foreign key, first:
Options: drop the primary key.,    drop the table containing the foreign key..,    drop the foreign key constraint.,    All of the above must be done.

Ans:C ,C


A PCMCIA measuring 10.5mm is what type?
Options: type 1,    type 2,    type 1 and 3,    type 3

Ans:D ,D


Which of the following keys is used to replace a single character with new text?
Options: S,    s,    r,    C

Ans:B ,B


A high speed device used in CPU for temporary storage during processing is called
Options: A register,    A bus,    A databus,    All of the above

Ans:A ,A


. What was the expected feature of fifth generation computers when Japan started FGCS?
Options: A) Operating Systems B) Paralled Processing C) ULSI D) None of above

Ans:B,B


Which of the following file retrieval methods use hypermedia?
Options: HTTP,    WAIS,    Veronica,    Archie

Ans:A ,A


What happens when you insert an AutoShape by simply clicking in the document?
Options: it appears near the insertion point B. it is inserted in its default size C. is selected D. all of the above

Ans: – C ,


A programmable controller:
Options: allows faster machine checkout,    is easier to troubleshoot than standard relay logic,    both (a) and (b),    All of the above

Ans:C ,C


What does that acronym VGA stand for?
Options: Extended Graphics Adapter,    Enhanced Graphics Array,    Video Graphics Array,    Color Graphics Array

Ans:C ,C


. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b


What is a slide-title master pair?
Options: a. The title area and text area of a specific slide b. a slide master and title master merged into a single slide c. A slide master and title master for a specific design template d. All of above

Ans: – C , – C


What is the name given to the molecular-scale computer?
Options: Femtocomputer,    Nanocomputer,    Supercomputer,    Microcomputer

Ans:B ,B


.   Which of the following can you use to add times to the slides in a presentation?
Options: a. Microsoft graph b. Microsoft Table c. Microsoft Excel d. Microsoft Word

Ans:2 – A ,2 – A


. Which of the following command is an internal command?
Options: a. Del b. Scandisk c. CHKDSK d. Deltree

Ans:0 – a ,0 – a


Which statements are true regarding ICMP packets? They acknowledge receipt of a TCP segment. They guarantee datagram delivery. They can provide hosts with information about network problems. They are encapsulated within IP datagrams.
Options: 1 only,    2 and 3,    3 and 4,    2, 3 and 4

Ans:C ,C


Which of the following can be an example of a database?
Options: a. Address book of all the suppliers of a company b. Salary sheet of all the employees of a company c. Records of daily sales transactions of a company d. All of above

Ans:ndash; d,ndash; d


Which command will be used with vi editor to replace text from cursor to right?
Options: r,    R,    s,    S

Ans:B ,B


The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:C ,C


Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Options: optimistic,    skeptical,    ambivalent,    None of the above is correct.

Ans:B ,B


In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
Options: One-to-One Relationship,    One-to-Many Relationship,    Many-to-Many Relationship,    Composite Relationship

Ans:A ,A


What is the main reason the OSI model was created?
Options: To create a layered model larger than the DoD model.,    So application developers can change only one layer's protocols at a time.,    So different networks could communicate.,    So Cisco could use the model.

Ans:C ,C


. The command allows you to show the status of the disk
Options: a. Vol b. Diskcomp c. CHKDSK d. Defrag

Ans:8 – c ,8 – c


A common reason for changing an information system is
Options: new requirements,    new technology,    problems in the existing system,    All of the above

Ans:D ,D


. Which of the following features should you use when typing in the notes text box?
Options: a. Slide shows b. Insert c. Slide master d. Zoom

Ans:4 – D ,4 – D


The estimation of the value of a function at a point beyond the interval in which the data lies is called known as
Options: Interpolation,    Simulation,    Emulation,    Extra polation

Ans:A ,A


High-resolution, bit-mapped displays are useful for displaying:
Options: clearer characters,    graphics,    more characters,    All of the above

Ans:D ,D


. A .... is a named location on a disk where files are stored
Options: a. Folder b. Pod c. Version d. None of the above

Ans: a, a


Tracing, of any input record or process, performed on a system, back to its original source, is an
Options: audit trial,    report generation,    batch processing,    conversion

Ans:A ,A


95. What is the shortcut key to Update Formula in a table?
Options: a. F9 b. Alt + F9 c. Ctrl + F9 d. Shift + F9

Ans:–  A ,–  A


. Find out who is not the inventor of transistors among following names
Options: A) John Burdeen B) William Shockley C) Walter Brattain D) Lee de Forest

Ans:5-D,5-D


What is the shortcut key for “Subscript ” the selected text?
Options: Ctrl + = B. Ctrl + – C. Ctrl + Shift + = D. Ctrl + Shift + –

Ans: – A ,


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

Ans:C ,C


We combine hardware, software, people, procedures, and data to create an _____
Options: people,    icons,    information system,    on-line

Ans:C ,C


Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:D ,D


What do you call the programs that are used to find out possible faults and their causes?
Options: Operating system extensions B. Cookies C. Diagnostic software D. Boot diskettes

Ans:– C ,


A modem is connected in between a telephone line and a
Options: network,    computer,    communication adapter,    serial port

Ans:C ,C


In SQL, the ALTER TABLESPACE command is used
Options: to add/rename data files,    to change storage characteristics,    to take a tablespace online/offline,    to begin/end a backup

Ans:E ,E


. Which command will you choose to convert a column of data into row?
Options: a.  Cut and Paste b.  Edit >> Paste Special >> Transpose c.  Both of above d.  None of above

Ans:– b,– b


Which is the first compiler-level language developed by a team of IBM programmers led by John Backus and unveiled in 1957?
Options: BASIC,    PL/1,    FORTRAN,    APL

Ans:C ,C


. The command fixes the minor errors of the disk
Options: a. Error.fix b. Scandisk c. CHKDSK/f d. Defrag

Ans:6 – c ,6 – c


. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Options: a. Go to File-Save As – Save As Type – Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert – Entire Column d. None of above

Ans:– b,– b


. Which device can understand difference between data & programs?
Options: A) Input device B) Output device C) Memory D) Microprocessor

Ans:D,D


Compression of digital data for efficient storage is
Options: Buffer,    CPU,    Packing,    Field

Ans:C ,C


Which elements of worksheet can be protected from accidental modification
Options: a. Contents b. Objects c. Scenarios d. All of above

Ans:#8211; d,#8211; d


________ is an object-oriented interface that encapsulates data-server functionality.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:B ,B

www.000webhost.com