. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Options: Logical B. Math & Trigonometry C. Statistical D. Financial

Ans: – D ,

Description: mcqquestions

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

Hits Today: 8325 | Level: Moderate


Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.

Got some suggestion about this question or to make this site better? Please leave your comments below.

More MS-Excel Related questions:

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

Ans:B ,B

The two classification of inputs are:
Options: energies and maintenance,    products and waste,    maintenance and waste,    maintenance and signal

Ans:D ,D

Which would you choose to display the statistics about a document?
Options: tools, word count B. insert, statistics C. tools, spelling and grammar D. tools, statistics

Ans:– A ,

In synchronous transmission data from various users
Options: Require header,    Do not require header,    Sometimes require header,    All of the above

Ans:B ,B

Graphic representation of the control logic of processing functions or modules representing a system, is known as:
Options: Structured analysis,    Structured chart,    Structured English,    System Flow chart

Ans:B ,B

.   Special effects used to introduce slides in a presentation are called
Options: a. Effects b. Custom animations c. Transitions d. Preset animations

Ans:4 – C ,4 – C

The first practical commercial typewriter was invented in 1867 in the United States by
Options: Christopher Latham Sholes,    Carlos Glidden,    Samuel Soule,    All of the above


During the laser printer's conditioning phase a uniform charge of _____ is placed on the photosensitive drum.
Options: +1000 volt,    +600 volts,    -600 volts,    -1000 volts

Ans:C ,C

How many control unit(s) is/are available in SISD (single data stream, single data stream) architecture?
Options: one,    two,    more than one,    Mone

Ans:A ,A

The digital multimeter is set for DC, Ohm and 20k. You will read _____ while measuring a good 2 amp fuse.
Options: 0.00,    0.02,    0.20,    2.00

Ans:A ,A

In digital data transmission
Options: Baud rate in equal to bit rate,    Baud rate is always smaller than the bit rate,    Baud rate is always higher than the bit rate,    None of the above

Ans:D,None of the above

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Options: parent,    child,    instance,    subtype

Ans:A ,A

. How many margins sare there on a page?
Options: a. Two (header and footer) b. Four (top, bottom, right and left) c. Two (landscape and portrait) d. Four (center, top, left and bottom)

Ans: – B , – B

A wrist grounding strap contains which of the following:
Options: Surge protector,    Capacitor,    Voltmeter,    Resistor

Ans:D ,D

. When typing in Preeti font all the Ukars turn to something else? What’s the cause?
Options: a. Autotext b. Autocorrect c. Speller d. Preeti font does not work with Word

Ans:– B,– B

Continuous line drawing are produced using
Options: Chain printers,    Daisy wheel printers,    Plotters,    Thermal devices

Ans:C ,C

A device that both transmits and receives data, is
Options: Transducer,    Trapdoor,    Translator,    Transceiver

Ans:D ,D

Which is not a data source component?
Options:  A) mail merge toolbar, B) header row, C) data fields, D) data records, 


A venturi tube:
Options: is extremely difficult to use,    is made only of metal,    measures the presence of a liquid,    can be used to measure gas or liquid flow rates

Ans:D ,D

Baseband is
Options: transmission of signals without modulation,    a signal all of whose energy is contained within a finite frequency range,    the simultaneous transmission of data to a number of stations,    All of the above

Ans:A ,A

. What lets you to create new presentation by selecting ready-made font color and graphics effects?
Options: a.  Presentation Template b.  Master Slide c.  Design Template d.  Animation Scheme

Ans:1 – C ,1 – 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 is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,

An AI technique that allows computers to understand associations and relationships between objects and events is called:
Options: heuristic processing,    cognitive science,    relative symbolism,    pattern matching

Ans:D ,D

Which of the following is two way list?
Options: a. grounded header list b. circular header list c. linked list with header and trailer nodes d. List traversed in two directions

Ans:D,List traversed in two directions

. Bit map terminal
Options: A) support display containing multiple window B) require considerable amount of video RAM C) requires tremendous amount of copying and hence low performance D) all of above


Symbolic languages were developed in
Options: 1962,    1950,    1974,    1980


The main purpose of time sharing techniques used in computers is to make the best use of the
Options: CPU,    peripherals,    seconday storage,    floppy disks


Conversion of binary number 1010101000010111 to hexadecimal number is
Options: D8F916,    A8B916,    AA1716,    D9F816

Ans:C ,C

Which would you choose to move selected text from one place to another?
Options: Press Ctrl+S B. Click File, Save C. Click Tools, Options, Save D. Click File, Save As

Ans:C ,

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

Ans:C ,C

. Booting means
Options: a. Restarting computer b. Installing program c. Removing errors d. Switch off

Ans:7 – a ,7 – a

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

Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options:  A) Merge the two files, B) Create the main document, C) Set the mailing list parameters, D) Create the data source,


A computer that handles resource sharing and network management in a local area network. Select the best fit for answer:
Options: Network Server,    Virtual Private Network,    Network operating system,    OSI

Ans:A ,A

The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B ,B

Which WLAN IEEE specification allows up to 54Mbps at 2.4GHz?
Options: A,    B,    G,    N

Ans:C ,C

The binary system uses powers of
Options: 2,    10,    8,    16

Ans:A ,A

One example of the use of an S-R flip-flop is as a(n):
Options: transition pulse generator,    astable oscillator,    racer,    switch debouncer

Ans:D ,D

Which of the following are(is) Language Processor(s)
Options: assembles,    compilers,    interpreters,    All of the above

Ans:D ,D

Which of the following is responsible for coordinating various operations using timing signals?
Options: Arithmetic-logic Unit,    Control unit,    Memory unit,    Input/Output unit

Ans:B ,B

All the instructions and procedures needed to start up a computer, to the point it can load an operating system, are stored in ROM chips. In IBM compatible PCs this is called the _____
Options: RAM BIOS,    ROM BIOS,    EPROM,    POST


. The term GIGO is related to which characteristics of computers?
Options: A) Speed B) Automatic C) Accuracy D) Reliability


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

Ans:B ,B

Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists

Ans: a, a

. Scandisk analyze and repair damage to which of the following?
Options: a. Physical clusters b. FAT c. Lost clusters d. All of the above

Ans:6 – d ,6 – d

An inventory management system should answer the questions
Options: what and why,    when and how much,    who and why,    where and when

Ans:B ,B

. What is the second generation computers made?
Options: Resistors B. Transistors C. Vacuum tubes D. Integrated Circuits

Ans:– B ,

. Which of the following action removes a sheet from workbook?
Options: a.  Select the sheet, then choose Edit >> Delete Sheet b.  Select the sheet then choose Format >> Sheet >> Hide c.  Both of above d.  None of above

Ans:– a,– a

. The act of retrieving existing data from memory is called
Options: A) Read-out B) Read from C) Read D) All of above