. Which of the following is correct syntax in Excel?

Options: =IF(LogicalTest, TrueResult, FalseResult) B. =IF(LogicalTest, (TrueResult, FalseResult)) C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Ans:– A ,

More MS-Excel Related questions:

An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program

Ans:C ,C

. 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

During the system study, the executive vice-president and the other managers exercise their responsibility of
Options: planning,    controlling,    directing,    organizing

Ans:B ,B

. Which among the following are the best tools for fixing the errors?
Options: a. Fdisk b. Scandisk c. CHKDSK d. Fixdisk

Ans:1 – b ,1 – b

A modern electronic computer is a machine that is meant for
Options: Doing quick mathematical calculations,    Input storage, manipulation of outputting of data,    Electronic data processing,    Performing repetitive tasks accurately


Which of the following section does not exist in a slide layout?
Options: a. Titles b. Lists c. Charts d. Animations

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

In laser printer technology, what happens during the conditioning stage?
Options: The corona wire places a uniform positive charge on the paper,    A uniform negative charge is placed on the photosensitive drum,    A uniform negative charge is placed on the toner,    All of the above

Ans:B ,B

Periodically adding, changing and deleting file records is called file
Options: Updating,    upgrading,    restructuring,    renewing

Ans:A ,A

. Which of the following is not a valid Zoom percentage in Excel?
Options: a. 10 b. 100 c. 300 d. 500

Ans:– d,– d

. The qualitative or quantitative attribute of a variable or set of variables is termed as
Options: A) data B) information C) both of above D) none of above


The two basic types of record-access methods are:
Options: sequential and random,    sequential and indexed,    direct and immediate,    on-line and realtime

Ans:A ,A

An operating system is a program or a group of programs that
Options: Helps in checking the spelling of Word B. Maintain the relationship in Database C. Manages the resources of the Computer D. Performs the calculations of cells in Excel

Ans:– C ,

A feasibility study
Options: includes a statement of the problems,    considers a single solutions,    both (a) and (b),    a list of alternative solution considered

Ans:A ,A

.   to save a presentation you
Options: a. click save on the windows start button b. press Ctrl + F5 c. select File, Save from the menu d. click the saver button on the formatting toolbar

Ans:2 – C ,2 – C

. Underlined text, such as text and folder names is referred to as
Options: a. Hyperlink b. Menu c. Source drive d. None of these

Ans: a, a

Which type of system hoard is the MOST likely candidate for processor upgrading if you want maximum performance and future compatibility?
Options: ML,    PCI,    ISA,    EISA

Ans:B ,B

Footnotes, endnotes, and indexes are all inserted as __________
Options: bookmarks B. cross-references C. hyperlinks D. word fields

Ans:– D ,

Thesaurus tool in MS Word is used for
Options:  A) Spelling suggestions, B) Grammar options, C) Synonyms and Antonyms words, D) All of above,


The register which holds the address of the location to or from which data are to be transferred is known as
Options: index register,    instruction register,    memory address register,    memory data register


. Which is built directly on the hardware?
Options: a. Computer Environment b. Application Software c. Operating System d. Database System

Ans:0 – c ,0 – c

. When was MS Windows operating system introduced?
Options: a. 1975 b. 1985 c. 1995 d. 2000

Ans:4 – b ,4 – b

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

Which of the following is a graphic representation of the modules in the System and the interconnection between them
Options: Pie chart,    Flow chart,    Structural chart,    System chart

Ans:C ,C

Which internal DOS command clears the screen and places the DOS prompt in the upper left corner of the screen?
Options: cls,    close,    quit,    exit

Ans:A ,A

Nonmodifiable procedures are called
Options: serially usable procedures,    concurrent procedures,    reentrant procedures,    topdown procedures

Ans:C ,C

. What is the best way to create another copy of a slide?
Options: a.  Click the slide then press Ctrl+A and paste in new slide b.  From Insert Menu choose Duplicate Slide c.  Redo everything on a new slide that you had done on previous slide d.  None of above

Ans:4 – B ,4 – B

93. What is the shortcut key to “Center Align” the selected text?
Options: a. Ctrl + C b. Ctrl + E c. Ctrl + F d. None of above

Ans:–  B ,–  B

What does COUNTA () function do?
Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Ans:– D ,

The state transition initiated by the user process itself in an operating system is
Options: block,    dispatch,    wake up,    timer run out

Ans:A ,A

What is the default left margin in Word 2003 document?
Options:  A) 1", B) 1.25", C) 1.5", D) 2", 


LISP was developed by
Options: John Mc Carthy,    Blaise Pascal,    Dr. Hollerith,    John Napier

Ans:A ,A

. A transaction completes its execution is said to be
Options: Saved B. Loaded C. Rolled D. Committed

Ans: – D ,

Which table is a permanent databases that has an entry for each terminal symbol?
Options: Terminal table,    Literal table,    Identifier table,    Reductions

Ans:A ,A

The output quality of a printer is measured by
Options: A) Dot per sq. inch B) Dot per inch C) Dots printed per unit time D) All of the above


The most common addressing techiniques employed by a CPU is
Options: a . immediate b . direct c . indirect e . all of the above


. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Options: a. Datasheet b. Justified c. Stacked d. Tabular

Ans:0 – d ,0 – d

Which of the following symbol modes are used to input of graphics to General CAD system?
Options: Live and Rectangle mode,    Arc and Circle mode,    Dimension and Alphanumeric mode,    All of the above

Ans:D ,D

Data integrity refers to
Options: the simplicity of data,    the privacy of data,    the validity of data,    the security of data

Ans:C ,C

An operation that will increase the length of a list is
Options: Insert,    Look-up,    Modify,    All of the above

Ans:A ,A

What type of magnetic material is normally used in bubble memories?
Options: Magnetic core,    Cobalt,    Garnet,    Metallic

Ans:C ,C

. Referential integrity cannot be set for _______________ relationships.
Options: a. One-To-One b. Indeterminate c. One-To-Many d. Many-To-Many

Ans:9 – b ,9 – b

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Options: read-only,    updateable,    either a read-only or an updateable,    None of the above is correct.

Ans:A ,A

. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Options: a. Between b. Is Null c. Like d. Not

Ans:7 – a ,7 – a

The process of communicating with a file from a terminal is
Options: Interactive,    Interrogation,    Heuristic,    All of the above

Ans:B ,B

To delete an embedded objects, first
Options: a. Double click the object b. Select the object by clicking it c. Press the Shift + Delete keys d. Select it and then press the delete key

Ans:#8211; d,#8211; d

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

The physical components of a computer system is
Options: Human ware,    Firm ware,    Hardware,    Software

Ans:C ,C

You configure the following access list: access-list 110 deny tcp any eq smtp access-list 110 deny tcp any eq 23 int ethernet 0 ip access-group 110 out What will the result of this access list be?
Options: Email and Telnet will be allowed out E0.,    Email and Telnet will be allowed in E0.,    Everything but email and Telnet will be allowed out E0.,    No IP traffic will be allowed out E0.

Ans:D ,D

Which field type will you select when creating a new table if you require to enter long text in that field?
Options: a. Text b. Memo c. Currency d. Hyperlink

Ans:ndash; b,ndash; b