. 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: 8161 | Level: Moderate

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

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

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

More MS-Excel Related questions:

Time during which a job is processed by the computer is
Options: Delay time,    Real time,    Execution time,    Down time


Which of the following tasks is not suited for sequential processing by a computer?
Options: Preparing of mailing labels,    Processing payroll cheques,    Accounting for credit card purchases,    Inventory control

Ans:D ,D

The accuracy of the floating point numbers representable in two 16 bit words of a computer is approximately
Options: 16 digits,    6 digits,    4 digits,    All of the above

Ans:B ,B

Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,

The digitizing technology that uses an electric field radiated from the tablet and picked up by a cursor is:
Options: electromagnetic,    raster,    sonic,    electrostic

Ans:D ,D

COM1 is typically represented by which of the following?
Options: 15 pin port,    9 pin male port,    9 pin female port,    25 pin male port

Ans:B ,B

Codes consisting of light and dark marks which may be optically read is known as
Options: Mnemonics,    Bar code,    Decoder,    All of the above

Ans:B ,B

. In DOS, the maximum length of filename is
Options: a. 5 b. 8 c. 11 d. 10

Ans:0 – b ,0 – b

Which key deletes the character to the left of the cursor
Options: macros B. template C. mail merge D. none

Ans: B ,

. To delete records or perform calculations on a table, the best tool to use is a __________.
Options: a. query b. filter c. form d. report

Ans:0 – a ,0 – a

Ctrl + E
Options: Exit Application B. Select All C. Clear All D. Align Center

Ans:– D ,

Procedure development occurs within the
Options: structured design phase,    conversion phase,    system building phase,    maintenance

Ans:C ,C

What is required when more than one person uses a central computer at the same time?
Options: Light pen,    Mouse,    Digitizer,    Terminal

Ans:D ,D

To test for AC ripple on a PC power supply, you would set the volt/ohm meter for:
Options: DC voltage scale,    AC voltage,    OHM scale,    Farad scale

Ans:B ,B

Which option will be used with sort command to start sorting ofter the nth column of the (m+l)th field?
Options: -m.n,    +m.n,    + n.m+1,    +(m+l).n

Ans:B ,B

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

. The appropriate Data Type to store Time in MS Access?
Options: a. Date/Time b. Time Only c. Time d. Time cannot be stored

Ans:– a,– a

Replication should be used when which of the following exist?
Options: When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.,    When using many nodes with different operating systems and DBMSs and database designs.,    The application's data can be somewhat out-of-date.,    All of the above.

Ans:C ,C

. What do you mean by Memory Compaction?
Options: a. Combine multiple equal memory holes into one big hole b. Combine multiple small memory holes into one big hole c. Divide big memory hole into small holes d. Divide memory hole by 2

Ans:9 – b ,9 – b

. “Ctrl + End” is used to
Options: Moves the cursor to the end of Line B. Moves the cursor to the end of Document C. Moves the cursor to the end of Paragraph D. None of the Above

Ans:– B ,

Group technology brings together and organizes:
Options: automation and tool production,    parts and simulation analysis,    documentation and analysis,    common parts, problems, and tasks

Ans:D ,D

. Which term is used to describe RAM?
Options: A) Dynamic RAM (DRAM) B) Static RAM (SRAM) C) Video RAM (VRAM) D) All of the above


Which of the following system program forgoes the production of object code to generate absolute machine code and load it into the physical main storage location from which it will be executed immediately upon completion of the assembly?
Options: two pass assembler,    load-and-go assembler,    macroprocessor,    compiler

Ans:B ,B

We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
Options: the basic probability,    support,    lift,    confidence

Ans:D ,D

. An Excel Workbook is a collection of …….
Options: a. Workbooks b. Worksheets c. Charts d. Worksheets and Charts

Ans:– d,– d

A relation has which of the following properties?
Options: Each row is not unique.,    Attributes can have the same name within a given table.,    Each relation has a unique name.,    The order of the columns is significant.

Ans:C ,C

Block caches or buffer caches are used
Options: to improve disk performance,    to handle interrupts,    to increase the capacity of the main memory,    to speed up main memory read operation

Ans:A ,A

The FIFO algorithm
Options: executes first the job that last entered the queue,    executes first the job that first entered the queue,    execute first the job that has been in the queue the longest,    executes first the job with the least processor needs

Ans:B ,B

In vi editor, forward search is performed using the command.
Options: :pat,    ?pat,    /pat,    All of the above

Ans:C ,C

. EBCDIC stands for
Options: A) Extended Binary Coded Decimal Interchange Code B) Extended Bit Code Decimal Interchange Code C) Extended Bit Case Decimal Interchange Code D) Extended Binary Case Decimal Interchange Code


Which of the following are kinds of instructions?
Options: Input,    Arithmetic,    Conditional branching,    All of the above

Ans:D ,D

In an absolute loading scheme, which loader function is accomplished by assembler
Options: Reallocation,    Allocation,    Linking,    Loading

Ans:A ,A

End-to-end connectivity is provided from host-to-host in:
Options: Network layer,    Session layer,    Data link layer,    Transport layer

Ans:D ,D

Which command will clear all the translations active on your router?
Options: show ip nat translations,    show ip nat statistics,    debug ip nat,    clear ip nat translations *

Ans:D ,D

A characteristic of a distributed MIS structure is:
Options: computers supporting local DP operations,    a multiprocessing environment,    integrative sharing of the workload,    All of the above

Ans:C ,C

The branch logic that provides decision making capabilities in the control unit is known as
Options: a . controlled transfer b . conditional transfer c . unconditional transfer d . none of above


_____ means that the manager spends his or her time dealing with exceptions or those situations which are out of control
Options: relevant,    management by exception,    predictive reports,    control

Ans:B ,B

Sometime data are gathered over a period of time and collected into a group before entering them into a computer for processing. What type of processing is it called?
Options: Interactive processing,    Sequential processing,    Batch processing,    Group processing

Ans:A ,A

Sales persons and other employees of the company who spend much of their time away from their offices but keep in touch with their company's microcomputers or main frame computers over telephone lines are called
Options: field workers,    telecommuters,    teleprocessors,    company directors

Ans:B ,B

The reserved word enum is used for which of the following?
Options: To define a range for an attribute.,    To define a range for a class.,    To define a range for a relationship.,    All of the above.

Ans:A ,A

If the memory slots have 30 pins then the chip is a?
Options: DIMM,    SIMM,    SDRAM,    All of the above

Ans:B ,B

All Operating Systems get their total memory initialized from?
Options: CPU,    BIOS,    ROM,    RAM

Ans:B ,B

What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register


Error reports are an example of:
Options: scheduled reports,    demand reports,    exception reports,    predictive reports

Ans:C ,C

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

Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit


. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Options: a. On the file menu, point to print area, and then click set print area. b. On the file menu, click print, and then click selection under print what c. On the view menu, click custom views, then click add d. All of above

Ans:– b,– b

. We can restore the deleted files and folders from
Options: a. Recycle bin b. My document c. Control panel d. All of the above

Ans:2 – a ,2 – a

Which of the following statements is true concerning JDBC?
Options: It is language independent.,    It is similar in concept to ODBC.,    It is useful for all object-oriented languages.,    It consists of three main layers.

Ans:B ,B

A group of related fields, is known as
Options: tuple,    schema,    records,    file

Ans:A ,A