0. In Excel _______ may not contain in Formula

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

Ans: – C ,

Description: mcqquestions

More MS-Excel Related questions:

Which of the following statements are correct about the function? long fun(int num) { int i; long f=1; for(i=1; i<=num; i++) f = f * i; return f; }
Options: The function calculates the value of 1 raised to power num.,    The function calculates the square root of an integer,    The function calculates the factorial value of an integer,    None of above

Ans:C ,C

. Gridlines
Options: a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. a, b and c

Ans:– d,– d

The Second Generation Computer was based on ________.
Options: Vacuum Tube B. Silicon Chips C. Transistor D. Bio Chips

Ans:– C ,

A disk scheduling algorithm in an operating system causes the disk arm to move back and forth across the disk surface in order to service all requests in its path. This is a
Options: First come first served,    Shortest Seek Time First (SSTE),    Scan,    FIFO

Ans:C ,C

Read-only databases are ________ updated.
Options: always,    commonly,    seldom,    never

Ans:D ,D

The autofill feature
Options: a. extends a sequential series of data b. automatically adds range of cell values c. applies a boarder around the selected cells d. none of the above

Ans:#8211; d,#8211; d

The _____ is a short horizontal line indicating the conclusion of a document.
Options: a. insertion point b. end mark c. status indicator d. scroll box

Ans:– B,– B

When entering field name, how many characters you can type in maximum?
Options: a. 60 b. 64 c. 68 d. Any number of character

Ans:ndash; b,ndash; b

Two main measures for the efficiency of an algorithm are
Options: a. Processor and memory b. Complexity and capacity c. Time and space d. Data and space  


What command is used to remove the directory?
Options: rdir,    remove,    rd,    rmdir

Ans:D ,D

An encyclopedic database
Options: is an information utility that specializes in storing and searching information,    is generally free,    is easy for beginners to use,    All of the above

Ans:A ,A

A smart solid-state sensor is:
Options: one that integrates both logic and a solid-state sensor into one unit.,    one that has two or three substrates,    not available today,    All of the above

Ans:A ,A

. Use of icons and windows are characteristics of …… interface
Options: a. Command driven b. Windows orientated c. Graphical user d. Menu driven

Ans:5 – c ,5 – c

. How can you disable extended selection mode?
Options: a. Press F8 again to disable b. Press Del to disable c. Press Esc to disable d. Press Enter to disable

Ans:– C,– C

Which of the following commands is used to display the filenames in multiple columns?
Options: ls,    ls -1,    ls -x,    lc

Ans:C ,C

What is the name of the computer program that contains the distilled knowledge of an expert?
Options: Data base management system,    Management information System,    Expert system,    Artificial intelligence

Ans:C ,C

Which two statements describe the IP address The subnet address is The lowest host address in the subnet is The last valid host address in the subnet is The broadcast address of the subnet is
Options: 1 and 3,    2 and 4,    1, 2 and 4,    2, 3 and 4

Ans:B ,B

. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Options: a. formula b. format c. layout d. record

Ans:3 – d ,3 – d

. Status indicators are located on the
Options: a. Vertical scroll bar b. Horizontal scroll bar c. Formula bar d. Formatting toolbar

Ans:– c,– c

. Which of the following is not anti-viruses software?
Options: A) NAV B) F-Prot C) Oracle D) McAfee


A solenoid:
Options: can be used only in de circuits,    is spring operated,    is widely used in industrial automation,    is related to an aneroid

Ans:C ,C

Using ODL, you can define which of the following?
Options: Attribute,    Structure,    Operation,    All of the above.

Ans:D ,D

Which one of the following statements is true for current flowing in a series circuit?
Options: The amount of current flow through each part of a series circuit can be different, depending on the resistance of each part and the amount of voltage applied to it,    The total current in a series circuit is equal to the sum of the currents flowing through the individual components in the circuit,    The same current flows through every part of a series circuit,    The total current in a series circuit is equal to the total voltage multiplied by the total resistance

Ans:C ,C

Which command will configure a switch port to use the IEEE standard method of inserting VLAN membership information into Ethernet frames?
Options: Switch(config)# switchport trunk encapsulation isl,    Switch(config)# switchport trunk encapsulation ietf,    Switch(config)# switchport trunk encapsulation dot1q,    Switch(config-if)# switchport trunk encapsulation isl

Ans:E ,E

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

End Key
Options: a. Moves the cursor end of the line b. Moves the cursor end of the document c. Moves the cursor end of the paragraph d. Moves the cursor end of the screen

Ans:–  A,–  A

The attribution of human form or qualities to things such as machines or computers is called
Options: cybernetics,    cybernation,    artificial intelligence,    anthropomorphism

Ans:D ,D

Data Manipulation Language enables users to
Options: Retrieval of information stored in database B. Insertion of new information into the database C. Deletion of information from the database D. All of the above

Ans:– D ,

Assuming 100% efficiency, what is the power being applied to the primary winding of the transformer described in the above question?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A

Which programming language is based on Algol 60.
Options: PILOT,    SNOBOL,    ADA,    SIMULA

Ans:D ,D

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

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

An Oracle System Change Number (SCN):
Options: is a value that is incremented whenever a dirty read occurs.,    is incremented whenever a deadlock occurs.,    is a value that keeps track of explicit locks.,    is a value that is incremented whenever database changes are made.

Ans:D ,D

With MS-DOS which command will divide the surface of the blank floppy disk into sectors and assign a unique address to each one?
Options: FORMAT command,    FAT command,    VER command,    CHKDSK command

Ans:A ,A

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

The term "memory" applies to which one of the following
Options: Logic,    Storage,    Control,    Input device

Ans:B ,B

In which of the following areas may ICAI programs prove to be useful?
Options: educational institutions,    corporations,    department of Defence,    All of the above

Ans:D ,D

The details of all external symbols and relocation formation (relocation list or map) is provided to linker by
Options: Macro processor,    Translator,    Loader,    Editor

Ans:B ,B

3. What is the maximum number of lines you can set for lines to drop box?
Options: a. 3 b. 5 c. 10 d. 15

Ans:#8211; C ,#8211; C

Which device is required for the Internet connection?
Options: Joystick B. Modem C. CD Drive D. NIC Card

Ans:– B ,

Which is considered a direct entry input device?
Options: Optical scanner,    All of the above,    Light pen,    Digitizer

Ans:All of the above,All of the above

From which menu you can access Picture, Test Box, Chart etc?
Options: a. File b. Edit c. Insert d. View

Ans: – C , – C

Which of the methods below can be used to tell a robot what it is to do?
Options: Walk-through,    Set mechanical stops,    Software program,    (a) and (c)

Ans:D ,D

A decrease in magnitude of current, voltage, a power of a signal in transmission between points, is known as
Options: Attenuation,    Amplitude,    Aloha,    Carrier

Ans:A ,A

Which of the following command is used to count just the number of lines contained in a file?
Options: wc -l,    wc -c,    wc -w,    wc -r

Ans:A ,A

Programs are executed on the basis of a priority number in a
Options: Batch processing system B. Multiprogramming C. Time sharing D. None of these

Ans:– B ,

. Which operating system uses short file names?
Options: a. Windows b. Unix c. DOS d. All of above

Ans:4 – c ,4 – c

. In Datasheet View, what appears at the top of each column?
Options: a. Data type b. Description c. Field name d. Primary key

Ans:2 – c ,2 – c

The @active data warehouse architecture includes which of the following?
Options: At least one data mart,    Data that can extracted from numerous internal and external sources,    Near real-time updates,    All of the above.

Ans:D ,D

What does DMA stand for?
Options: Distinct Memory Access B. Direct Memory Access C. Direct Module Access D. Direct Memory Allocation

Ans:– B ,