What is represented by the small, black square in the lower-right corner of an active cell or range?


Options: Copy handle B. Fill handle C. Insert handle D. Border

Ans:– B ,






More MS-Excel Related questions:


Which of the following is an advantage of using an expert system development tool?
Options: imposed structure,    knowledge engineering assistance,    rapid prototyping,    All of the above

Ans:D ,D


The network address of 172.16.0.0/19 provides how many subnets and hosts?
Options: 7 subnets, 30 hosts each,    8 subnets, 8,190 hosts each,    8 subnets, 2,046 hosts each,    7 subnets, 2,046 hosts each

Ans:B ,B


The _____ symbol is used in a flowchart to represent a step that gets information from the user.
Options: Input/Output,    Process,    Selection/repetition,    Start/Stop

Ans:A ,A


. A __________ enables you to view data from a table based on a specific criterion
Options: a. Form b. Query c. Macro d. Report

Ans:0 – b ,0 – b


Which of the following operations can be performed on the file "NOTES.TXT" using the below code? FILE *fp; fp = fopen("NOTES.TXT", "r+");
Options: Reading,    Writing,    Appending,    Read and Write

Ans:D ,D


The following are components of a database except ________ .
Options: user data,    metadata,    reports,    indexes

Ans:C ,C


36. When typing in a word field manually, what must you press to insert the code’s braces?
Options: a. Ctrl + F6 b. Ctrl + F9 c. Alt + F11 d. Shift + F12

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


Which of the following are layers in the TCP/IP model? Application Session Transport Internet Data Link Physical
Options: 1 and 2,    1, 3 and 4,    2, 3 and 5,    3, 4 and 5

Ans:B ,B


The most common binary code in use today is the 8 bit ASCII code. What do the letters ASCII stand for?
Options: American Standard Code for International Interchange,    American Standard Code for Information Interchange,    American Standard Code for Intelligence Interchange,    American Scientific Code for Information Interchange

Ans:B ,B


What is the name of the operating system for the laptop computer called MacLite?
Options: Windows,    DOS,    MS-DOS,    OZ

Ans:D ,D


. In Excel, by default Numeric Values appears in
Options: a. Left aligned b. Right aligned c. Center aligned d. Justify aligned

Ans:– b,– b


A reflective marker that indicates the end of the usable tape is
Options: End user,    End-of-tape,    Optical mark reader,    FAX

Ans:B ,B


Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above

Ans:D,D


Which of the following is correct about err used in the declaration given below? typedef enum error { warning, test, exception } err;
Options: It is a typedef for enum error.,    It is a variable of type enum error.,    The statement is erroneous.,    It is a structure.

Ans:A ,A


A good query system
Options: can accept English language commands,    allows non-programmers to access information stored in a database,    can be accessed only by data processing professionals,    both (a) and (b)

Ans:B ,B


When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995

Ans:A,A


What is the default subnet mask for a class A network?
Options: 127.0.0.1,    255.0.0.0,    255.255.255.0.0,    255.255.255.0

Ans:B ,B


Which of the following is not a quotation system procedure set?
Options: delivery planning,    product data retrieval,    quotation preparation,    all of the above

Ans:A ,A


The Turnaround is
Options: the elapsed time between the receipt of the input and the availability of the output,    a group of related fields,    the key information of programming,    a program statement that violates one or more rules of the language in which it is written

Ans:A ,A


The complexity of Bubble sort algorithm is
Options: A)O(n) b.O(log n) c.O(n2) d.O(n log n)

Ans:C, O(n2)


What TCP/IP protocol is used for remote terminal connection service?
Options: UDP,    RARP,    FTP,    TELNET

Ans:D ,D


What is Custom Shows in PowerPoint?
Options: Use the only some parts of the monitor is called Custom Shows B. The Presentation which can present only on particular date C. Creating Presentations within a Presentation D. There is no option of Custom Shows

Ans:– C ,


What are the data transmission channels available for carrying data from one location to another?
Options: Narrowband,    Voiceband,    Broadband,    All of the above

Ans:D ,D


A dialog box with a bomb appears oh a Macintosh screen. What type of problem has occurred?
Options: A RAM problem,    A software problem,    A ROM problem,    An ADB problem

Ans:B ,B


Which of the following could be a valid DOS  file  specification?
Options: a. NOSFILE.POST b. NOSFILE.P.OST c. NOSFILE.DOC d. NOST.FILEDOC

Ans:  4 b.        ,  4 b.       


If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
Options: Derived attribute,    Optional one cardinality,    Multi-valued attribute,    Weak entity

Ans:D ,D


An organization containing manufacturing, marketing, and finance areas is called a
Options: matrix organization,    flow network organization,    modular organization,    functional organization

Ans:D ,D


Which of the following is not used for storage purposes with main frame computers?
Options: removable disks,    fixed disks,    mass storage systems,    diskettes

Ans:D,D


_____ use standardized symbols to represent an algorithm.
Options: Flowcharts,    Flow diagrams,    IPO charts,    Pseudocharts

Ans:A ,A


Which of the following function returns t If the object is a symbol m LISP?
Options: (* <object>),    (symbolp <object>),    (nonnumeric <object>),    (constantp <object>)

Ans:B ,B


Which one of the following statements is true for the currents in a parallel RL circuit?
Options: The total current is equal to the sum of the currents through the resistance and inductance,    The current always has the same amplitude and phase for every part of the circuit,    The total current is less than the sum of the currents through the resistance and inductance,    The total current leads the total voltage by less than 90

Ans:C ,C


The first mechanical calculating machine was made by
Options: William Oughtred,    Gottfried Leibnitz,    Blaise Pascal,    Charles Babbage

Ans:C ,C


Which of the following is not used as secondary storage
Options: Semiconductor memory,    Magnetic disks,    Magnetic drums,    Magnetic tapes

Ans:A ,A


Why does the data communication industry use the layered OSI reference model? It divides the network communication process into smaller and simpler components, thus aiding component development, design, and troubleshooting. It enables equipment from different vendors to use the same electronic components, thus saving research and development funds. It supports the evolution of multiple competing standards and thus provides business opportunities for equipment manufacturers. It encourages industry standardization by defining what functions occur at each layer of the model.
Options: 1 only,    1 and 4,    2 and 3,    3 only

Ans:B ,B


When the graph of current versus voltage is a straight line, the device is referred to as
Options: Active,    Linear,    Nonlinear,    Bipolar

Ans:B ,B


Which of the following is not the Networking Devices?
Options: Gateways B. Linux             C. Routers D. Firewalls

Ans:– B ,


People often call ______ as the brain of computer system
Options: A) Control Unit B) Arithmetic Logic Unit C) Central Processing Unit D) Storage Unit

Ans:-C,-C


A relation that has no partial dependencies is in which normal form
Options: First B. Second C. Third D. BCNF

Ans:– B ,


Documentation should include
Options: a. Destination and users of the output data b. Source of input data c. Information on the purpose of the workbook d. All of the above

Ans:#8211; d,#8211; d


. How can you get your photo album slide show to play continuously?
Options: a. Use random slide transition b. Launch an online broadcast c. Loop continuously d. All of above

Ans:8 – C ,8 – C


97. What is the shortcut key for “Find and Replace” dialog box?
Options: a. Ctrl + F b. Ctrl + R c. Ctrl + H d. Ctrl + Shift + F

Ans:–  C ,–  C


The Primary job of the operating system is A)  Manage Commands B)  Manage Users         C)  Manage Programs D)  Manage Resources
Options:

Ans:– D ,


How is ink transferred to paper in common ink jet printers?
Options: Boiling ink,    Crystal,    Motorized pump,    Screens deflect ink on the paper into the proper positions

Ans:B ,B


Which of the following is a special purpose language used to describe to a computer's operating system.
Options: LOGO,    APL,    ICL,    CORAL

Ans:C ,C


Who has developed the Linux?
Options: Bob Young,    Mark Eving,    Richard Stallman,    Linus Torvalds

Ans:D ,D


. How can you optimize performance of your computer?
Options: a. Delete unused files b. Defrag disk c. Scan for virus d. All of above

Ans:8 – d ,8 – d


A critical region is
Options: a program segment that has not been proved bug-free,    a program segment that often causes unexpected system crashes,    a program segment where shared resources are accessed,    one which is enclosed by a pair of P and V operations on semaphores

Ans:D ,D


What problem can occur if a printer cable is to close to a power cable?
Options: ESD Electrostatic Discharge,    EMI Electromagnetic Interference,    parity error,    no affect

Ans:B ,B


The Personal Consultant is based on:
Options: EMYCIN,    OPS5+,    XCON,    All of the above

Ans:D ,D

www.000webhost.com