Which is an example of a function?

Options: =add(A1:A2) B. =A1+A2 C. =SUM(A1:A2) D. A1+A2

Ans:– C ,

Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 18213

More MS-Excel Related questions:

. Which of the following options is NOT a part of an option group?
Options: a. Option button label b. Option group frame c. Option group label d. Option group button

Ans:– d,– d

One byte can be used to encode any integer between 'O' and -inclusive
Options: 16,    256,    128,    255

Ans:D ,D

While working with MS-DOS, which command is used to specify the colour display, 40 columns and color?

Ans:C ,C

Which of the following device copies electrical signals from one Ethernet to another?
Options: bridge,    repeater,    hub,    passive hub

Ans:B ,B

Pillsbury's REACH system is concerned mainly with the accomplishment of
Options: monthly objectives,    weekly objectives,    quarterly objectives,    annual objectives

Ans:C ,C

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

Ans:C ,C

. Whenever you move a directory from one location to another
Options: a. All files inside the directory are moved b. All the subdirectory inside that directoryare moved c. The directory is moved the source file is not moved d. Both a and b

Ans: d, d

What type of memory is not directly addressable by the CPU and requires special software called EMS (expanded memory specification)?
Options: Extended,    Expanded,    Base,    Conventional

Ans:B ,B

Computer is free from tiresome and boardoom. We call it
Options: A) Accuracy B) Reliability C) Diligence D) Versatility


Which EIGRP information is held in RAM and maintained through the use of Hello and update packets? Neighbor table STP table Topology table DUAL table
Options: 2 only,    4 only,    1 and 3,    All of the above

Ans:C ,C

Which one of the following properties of a magnetic circuit can be directly compared to current in an electrical circuit?
Options: Number of lines of force,    Flux density,    Reluctance,    Magnetomotive force

Ans:A ,A

Which of the following is an absolute cell reference?
Options: a. !A!1 b. $A$1 c. #a#1 d. A1

Ans:#8211; b,#8211; b

. We can remove a relationship defined between two tables by
Options: a. From edit menu choose delete relationship b. Select the relationship line and press delete c. Choose delete option from relationship menu d. All of above

Ans:4 – b ,4 – b

What is the name of the earliest calculating machine which was based on concepts found in modern computers but was unfortunately never built?
Options: Babbage's Difference Engine,    Pascal's Adder,    Leibnitz's Multiplier,    Differential Analyser

Ans:A ,A

What do you need to check serial and parallel port?
Options: Port adapter,    Logic probe,    Loopback plug,    All of the above

Ans:C ,C

Which of the following is false about disk when compared to main memory?
Options: non-volatile,    longer storage capacity,    lower price per bit,    faster

Ans:D ,D

. EBCDIC can code up to how many different characters?
Options: A) 256 B) 16 C) 32 D) 64


The process of entering data into a storage location
Options: adds to the contents of the location,    cause variation in its address number,    is known as a readout operation,    is destructive of previous contents


John Napier invented Logarithm in
Options: A) 1614 B) 1617 C) 1620 D) None of above


. A computer program that converts an entire program into machine language at one time is called a/an
Options: A) Interpreter B) CPU C) Compiler D) Simulator


. SQL stands for __________.
Options: a. Standard Query Language b. Structured Query Language c. Simplified Query Language d. Static Query Language

Ans:5 – b ,5 – b

A card on the top of pack of cards containing information about the cards in the pack is
Options: Punched card,    Card punch,    Reader card,    Punched paper tape

Ans:C ,C

. A normal CD-ROM usually can store up to __________data?
Options: A) 680 KB B) 680 Bytes C) 680 MB D) 680 GB


  After choosing a predefined template, which option has to be chosen to change the background color?
Options: Design Template B. Color Scheme C. Animation Scheme D. Color Effects

Ans:– B ,

. Which is not external command?
Options: a. Doskey b. Verify c. Print d. Find

Ans:4 – b ,4 – b

Which one of the following is true regarding VLANs?
Options: Two VLANs are configured by default on all Cisco switches.,    VLANs only work if you have a complete Cisco switched internetwork. No off-brand switches are allowed.,    You should not have more than 10 switches in the same VTP domain.,    VTP is used to send VLAN information to switches in a configured VTP domain.

Ans:D ,D

6. Multiprogramming system
Options: a. Are easier to develop than single programming system b. Execute each job faster c. Execute more jobs in the same time period d. Are used only one large mainframe computers

Ans:Correct Answer: c,Correct Answer: c

The main purpose of the system investigation phase is to produce
Options: a design report,    a requirement report,    a feasibility report,    All of the above

Ans:C ,C

The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in Electronic Data Processing system is called
Options: ASCII,    EBCDII,    BCD,    All of the above

Ans:A ,A

. Which of the following is first generation of computer
Options: A) EDSAC B) IBM-1401 C) CDC-1604 D) ICL-2900


. What do you mean by one to many relationship between student and class table?
Options: a. One student can have many classes b. One class may have many student c. Many classes may have many students d. Many students may have manu classes

Ans:0 – a ,0 – a

The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but hte data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a lienear array does not d. All of above  


An econometric model requires
Options: a computer with large auxiliary storage capacity,    a data base of economic data,    a model base of quantitative analysis programs,    All of the above

Ans:D ,D

The earliest device that qualifies as a digital computer is
Options: EDSAC,    Abacus,    ENIAC,    EDVAC

Ans:B ,B

A terminal having local processing capability is
Options: KIPS,    AI,    Intelligent terminal,    Optical terminal

Ans:C ,C

An error-detecting code inserted as a field in a block of data to be transmitted is known as
Options: Frame check sequence,    Error detecting code,    Checksum,    flow control

Ans:A ,A

To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,

Which of the following is not true of a magnetic disk?
Options: It is expensive relative to magnetic tape,    It provides only sequential access to stored data,    Users can easily update records by writing over the old data,    It does not provide an automatic audit trail


. It is the default folder for many Windows Applications to save your file
Options: a. My Document b. My Pictures c. Documents and Settings d. My Computer

Ans:7 – a ,7 – a

. Borders can be applied to
Options: a. cells b. paragraph c. text d. All of above

Ans: – D , – D

Transmission of computerised data from one location to another is called
Options: data transfer,    data flow,    data communication,    data management

Ans:C ,C

How many types of storage loops exist in magnetic bubble memory?
Options: 8,    4,    16,    2

Ans:D ,D

What is the general name of the device which produces hardcopy graphics?
Options: COM,    Plotter,    Printer,    Microfilm


Which of the following is the original purpose of SQL?
Options: To specify the syntax and semantics of SQL data definition language,    To specify the syntax and semantics of SQL manipulation language,    To define the data structures,    All of the above.

Ans:D ,D

Suppose the zener diode has a breakdown voltage of 10 V and zener resistance of 8.5 W, what is the additional voltage when the current is 20 mA?
Options: 0.17 V,    10.17 V,    20 V,    18.8 V

Ans:A ,A

EBCDIC can code up to how many different characters?
Options: 8,    16,    32,    64

Ans:E ,E

You are trying to decide which type of network you will use at your office, and you want the type that will provide communication and avoid collisions on the cable. Which of the following is the best choice?
Options: Token-Ring,    CSMA/CD,    Ethernet,    CSMA/CA

Ans:A ,A

Which of the following options is not located in the Page Setup dialog box?
Options: a. Page Break Preview. b. Page Orientation c. Margins d. Headers and Footers

Ans:#8211; a,#8211; a

You can create a new presentation by completing all of the following except
Options: a. Clicking the new button on the standard toolbar b. Clicking file, new c. Clicking file open d. Pressing ctrl + N

Ans: – C , – C

What form of energy is used to maintain an imbalance of charges between the terminals of a battery?
Options: Electronical energy,    Mechanical energy,    Chemical energy,    Solar energy

Ans:C ,C