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: 8476 | 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:

. Assembly language started to be used from
Options: A) first generation computers B) second generation computers C) third generation computers D) fourth generation computers


The rate at which scanning is repeated is called the:
Options: stroke rate,    refresh rate,    bandwidth,    resolution

Ans:B ,B

Which two of the following DOS commands are used to display or set the date and time of your computer's infernal clock?
Options: VER,    HOUR,    DATE,    DAY

Ans:C ,C

Which multiplexing technique shifts each signal to a different carrier frequency?
Options: FDM,    synchronous TDM,    asynchronous TDM,    All of the above

Ans:A ,A

A front-end processor is
Options: a user computer system,    a processor in a large-scale computer that executes operating system instructions,    a minicomputer that relieves main-frame computers at a computer centre of communications control functions,    preliminary processor of batch jobs.

Ans:C ,C

Auto text and Auto correct are ___________ tools.
Options: styling B. editing B. designing D. none of the above

Ans:– B ,

Snapshot of the data in the database at a given instant of time is called
Options: Database Schema B. Database Instance C. Database Snapshot D. All of the above

Ans:– B ,

What command will display the forward/filter table?
Options: show mac filter,    show run,    show mac address-table,    show mac filter-table

Ans:C ,C

. A small part of taskbar that has icons of background running applications is
Options: a. Start button b. Quick launch c. Task bar d. System tray

Ans: d, d

The time lag, between the keying of the last character on the keyboard input and the appearance of the first output character on the screen, is known as
Options: Key,    System review,    response time,    batch Processing

Ans:C ,C

In ODBC, a file that can be shared among database users is called a:
Options: system data source.,    file data source.,    user data source.,    SQL text file.

Ans:B ,B

. What is the purpose of inserting header and footer in document?
Options: a. to enhance the overall appearance of the document b. to mark the starting and ending of page c. to make large document more readable d. to allow page headers and footers appear on document when printed

Ans: – D , – D

Which method uses the design analysis as a method for effecting the design?
Options: The iterative design method,    The direct method,    The design selection method,    All of the above

Ans:B ,B

Entities of a given type are grouped into a(n):
Options: database.,    entity class.,    attribute.,    ERD.

Ans:B ,B

Which of the following is used as a primary storage device?
Options: A) Magnetic drum B) Hard Disks C) Floppy D) All of above


In which year were chips used inside the computer for the first time?
Options: 1964,    1975,    1977,    1981

Ans:B ,B

25. How will MS Word will respond in repeated word.
Options: a. A Red wavy line under the repeated word b. A Green wavy line under the repeated word c. A Blue wavy line under the repeated word d. None of the above

Ans:–  A ,–  A

The report card and merit list forms the
Options: Output data,    Data processing,    Central Processing,    Input data


. Any files deleted in Windows goes into
Options: a. Trash can b. Recycle bin c. Deleted Files d. None of above

Ans:2 – b ,2 – b

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

.Only filenames and extensions are to be displayed in wide format, which command you’ll use?
Options: a.    Dir/w b.    Dir a: c.    Dir/s d.    Dir/b

Ans:a,Correct Answer: Dir/w

The most popular language for interactive use is

Ans:C ,C

_____ help prevent power surges.
Options: Surge suppressor,    Spike protector,    UPS system,    High-grade multi-meter

Ans:A ,A

. Which of the following have low failure rate?
Options: A) mechanical devices B) electronic devices C) electro-mechanical devices D) None of above


The type of information most restricted by a poor interface between generalized data base management systems and special computing system languages is
Options: supervisory,    planning,    priority setting,    limitation

Ans:B ,B

. The lower deck of an abacus is known as
Options: A) heaven B) sky C) earth D) floor


. The most important advantage of a video disk is
Options: A) Compactness B) Potential capacity C) Durability D) Cost effectiveness


. Tabs stop position cannot be the following alignment
Options: Decimal Alignment B. Center Alignment C. Bar Alignment D. Justify Alignment

Ans:– D ,

. Pick out odd
Options: a. Windows b. Window c. DOS d. Linux

Ans:5 – b ,5 – b

Who is credited with the idea of using punch cards to control patterns in a weaving machine?
Options: Pascal,    Hollerith,    Babbage,    jacquard

Ans:D ,D

What is the purpose of the PSH flag in the TCP header?
Options: Typically used to indicate end of message B. Typically used to indicate beginning of message C. Typically used to push the message D. Typically used to indicate stop the message

Ans:– A ,

The ascending order of a data hirerchy is:
Options: a. bit-byte-record-field-file-database b. byte-bit-field-record-file-database c. bit-byte-field-record-file-database d. bit-byte-file-record-field-database

Ans:c ,c

Which of the following do you use to change margins?
Options: a. formatting toolbar b. page setup dialog box c. Standard toolbar d. paragraph dialog box

Ans:–  B,–  B

In OLE DB, a tabular data provider:
Options: does not own data.,    transforms data through ODE DB interfaces.,    is both a consumer and a provider of data.,    exposes data via rowsets.

Ans:D ,D

What is the purpose of "rb" in fopen() function used below in the code? FILE *fp; fp = fopen("source.txt", "rb");
Options: open "source.txt" in binary mode for reading,    open "source.txt" in binary mode for reading and writing,    Create a new file "source.txt" for reading and writing,    None of above

Ans:A ,A

. Where can you find the horizontal split bar on MS Word screen?
Options: a. On the left of horizontal scroll bar b. On the right of horizontal scroll bar c. On the top of vertical scroll bar d. On the bottom of vertical scroll bar

Ans:– C,– C

What is the name of the operating system that reads and reacts in terms of actual time.
Options: Batch system,    Quick response system,    Real time system,    Time sharing system

Ans:C ,C

. The column command is located on the _____ tab.
Options: a. Insert b. Home c. View d. Page Layout

Ans: – D , – D

A hard copy would be prepared on a
Options: Line printer,    Dot matrix printer,    Type writer terminal,    Plotter

Ans:E ,E

Indicate which is a pre-emptive scheduling algorithm
Options: Round-robin,    Shortest-job-next,    Priority-based,    All of the above

Ans:A ,A

. Which of the following is correct regarding Underline in MS-Word?
Options: a. Color of Underline can be change b. Style of Underline can be change c. Underline can be set using by shortcut key d. All of the above

Ans: –  D , –  D

The computer generation that triggered the explosion of interest in information processing was the
Options: first generation of computers,    second generation of computers,    third generation of computers,    fourth generation of computers

Ans:C ,C

Multivalued dependencies should ________ be eliminated.
Options: always,    commonly,    seldom,    never

Ans:A ,A

. What value will display if the formula = “$55.00″+5 is entered into a cell?
Options: a. $60 b. 60 c. “$55.00″+5 d. $60.00

Ans:– b,– b

The funds management subsystem attempts to
Options: increase cash input,    decrease cash output,    balance cash inflow with outflow,    All of the above

Ans:C ,C

. Personal computers used a number of chips mounted on a main circuit board. What is the common name for such boards?

Options: A) Daughterboard B) Motherboard C) Father board D) Childboard


What switch would you use to view Smartdrive statistics?
Options: /x,    /e:,    /s,    /o:n

Ans:C ,C

. For what Antikyathera was used?
Options: A) For counting B) For Calculating tax collection C) For calculating astronomical positions D) For calculating firing weapons


What allows you to print on both sides of the printer?
Options: fuser,    duplexer,    toner cartridge,    paper-swapping unit

Ans:B ,B

What X-based tool is available for configuring the X Window system?
Options: XConfigurator,    XF86Setup,    xf86config,    All of the above

Ans:B ,B