Which of the following function will use to find the highest number in a series of number?

Options: MAX(B1:B3) B. MAXIMUM (B1:B3) C. HIGH (B1:B3) D. HIGHEST(B1:B3)

Ans:– A ,

Description: mcqquestions

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

Hits Today: 10488 | 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:

. To draw the Square box in the slide by selecting rectangle tool
Options: a. Holding CTRL & Draw b. Holding ALT & Draw c. Holding SHIFT & Draw d. All of the above

Ans:6 – C ,6 – C

. The contribution of Konrad Zuse was long ignored because

Options: A) He made the computers secretly B) his computers were very complicated and it took time for the people to recognize its power C) of political reasons. He was German. D) All of the above


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

Which of the following is NOT a type of Microsoft Access database object?
Options: a. Table b. Form c. Worksheets d. Modules

Ans:ndash; c,ndash; c

While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?

Ans:C ,C

. Which statement is valid about magnetic tape?
Options: A) It is a plastic ribbon B) It is coated on both sides with iron oxide C) It can be erased and reused D) All of above


30. Ctrl + Z
Options: a. Undo the last Action b. Redo the last Action c. Add the new page d. Paste the contents from clipboard

Ans:–  A ,–  A

What is the name given to the organized collection of software that controls the overall operation of a computer?
Options: Working system,    Peripheral system,    Operating system,    Controlling system

Ans:C ,C

. 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

Which of the following is true concerning the following statement: class Manager extends Employee
Options: Manager is a concrete class and a superclass.,    Manager is a concrete class and a subclass.,    Manager is an abstract class and a superclass.,    Manager is an abstract class and a subclass.

Ans:B ,B

Which term is not used to describe the memory component of a computer?
Options: ROM,    PROM,    RAM,    SAM


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

Ans:D ,D

What will be the output of the program ? #include<stdio.h> int main() { float arr[] = {12.4, 2.3, 4.5, 6.7}; printf("%d\n", sizeof(arr)/sizeof(arr[0])); return 0; }
Options: 5,    4,    6,    7

Ans:B ,B

Which of the following are likely to jam the read/write head of a disk pack?
Options: Dust,    Smoke particle,    Finger print smudge,    All of the above

Ans:D ,D

.   When an image is selected, it displays which of the following?
Options: a. Two corner handles b. Six middle handles c. Eight sizing handles d. Six boxes

Ans:0 – C ,0 – C

The Cancel and Enter buttons appear in the:
Options: Title bar B. Formula bar C. Menu bar D. Sheet tabs

Ans:– B ,

The communication mode that supports two-way traffic but only one direction at a time is
Options: simplex,    duplex,    half duplex,    multiplex

Ans:C ,C

Which of the following is an unsupervised data mining technique?
Options: Cluster analysis only,    Regression Analysis only,    RFM Analysis only,    Both Regression Analysis and RFM Analysis

Ans:A ,A

Which of the following is tactical decision?
Options: capital-source decision,    product decision,    plant-location decision,    budget allocation

Ans:D ,D

Small squares, called _____, on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphic.
Options: a. scroll boxes b. sizing handles c. status indicators d. move handles

Ans:– B,– B

. The most open source DBMS.
Options: a. Microsoft SQL Server b. Microsoft Access c. MySQL d. Oracle

Ans:9 – c ,9 – c

  We can replace a font on all slides with another font using the option :
Options: Edit –> Fonts B. Tools –> Fonts C. Tools -> Replace Fonts D. Format -> Replace Fonts

Ans:– D ,

During what phase, the requirement analysis is performed?
Options: system design phase,    system development phase,    system analysis phase,    system investigation phase

Ans:C ,C

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


. The ALU of a computer normally contains a number of high speed storage element called
Options: A) Semiconductor memory B) Registers C) Hard disks D) Magnetic disk


. Which operating system does not support long file names?
Options: a. OS/2 b. Windows 98 c. DOS 6.2 d. Windows NT

Ans:3 – c ,3 – c

A condition that led to the development of databases was:
Options: the proliferation of data files,    an increase in the amount of data handled by organizations,    a demand for more data to support informational needs,    all the above.

Ans:D ,D

. Getting data from a cell located in a different sheet is called….
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:– b,– b

Doubling the operating frequency of a capacitive circuit:
Options: doubles the amount of a capacitive reactance,    has no effect on the capacitive reactance,    cuts the capacitive reactance in half,    multiplies the capacitive reactance by 6.28

Ans:C ,C

When did IBM close the last of its punched card manufacturing plant?
Options: June, 1989,    December, 1984,    March, 1982,    November, 1979


When you are testing a fuse, you should set the Volt-OHM meter to what scale?
Options: AC,    DC,    AMPS,    OHMS

Ans:D ,D

Which language was created by Charles H. Moore at National Radio Astronomy Observatory.
Options: BASIC,    FORTH,    dBASE,    COBOL

Ans:B ,B

Programmers use _____ to organize and summarize the results of their problem analysis.
Options: Flowcharts,    Input charts,    IPO charts,    Output charts

Ans:C ,C

.  Macros can recover from _______ in a controlled manner.
Options: a.            events b.           modules c.           arguments d.            errors

Ans:– a,– a

. Which of the following is the structure of the Database?
Options: a. Table b. Schema c. Relation d. None of these

Ans: – b ,

. To select an entire column in MS-EXCEL, press?
Options: a. CTRL + C b. CTRL + Arrow key c. CTRL + S d. None of the above

Ans:– d,– d

The most important part of a multiple DHCP configurations is to make sure you don't have which of the following in the different scopes? Select the best answer.
Options: Duplicate addresses,    Duplicate pools,    Duplicate subnets,    Duplicate default gateways

Ans:A ,A

During the MIS development process, progress reporting meeting are held
Options: daily,    weekly,    monthly,    all of the above

Ans:B ,B

How can you remove tab stop markers from ruler?
Options: a. Double click the tab marker and choose Clear All b. Drag the tab stop marker out of the ruler c. Right click the tab stop marker and choose remove d. All of above

Ans:– B,– B

What is the name given to the exchange of control signals which is necessary for establishing a connection between a modem and a computer at one end of a line and another modem and computer at the other end?
Options: Handshaking,    Modem options,    Protocol,    Duplexing

Ans:A ,A

. Ctrl + K
Options: Insert Page Humber B. Insert Hyperlink C. Insert Header D. Insert Footer

Ans:– B ,

A 4 KHz noise less channel with one sample ever 125 per sec is used to transmit digital signals. Differential PCM with 4 bit relative signal value is used. Then how many bits per second are actually sent?
Options: 32 Kbps,    64 Kbps,    8 Kbps,    128 Kbps.

Ans:A ,A

Which statements are true regarding ICMP packets? They acknowledge receipt of a TCP segment. They guarantee datagram delivery. They can provide hosts with information about network problems. They are encapsulated within IP datagrams.
Options: 1 only,    2 and 3,    3 and 4,    2, 3 and 4

Ans:C ,C

What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample one two three /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { int i=0; i+=strlen(argv[1]); while(i>0) { printf("%c", argv[1][--i]); } return 0; }
Options: three two one,    owt,    eno,    eerht

Ans:C ,C

. MSI stands for

Options: A) Medium Scale Integrated Circuits B) Medium System Integrated Circuits C) Medium Scale Intelligent Circuit D) Medium System Intelligent Circuit


Which command displays RIP routing updates?
Options: show ip route,    debug ip rip,    show protocols,    debug ip route

Ans:B ,B

Which of the following column properties specifies whether or not cells in a column must contain a data value?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:A ,A

Which of the following is not true about indexes?
Options: Indexes are created to enforce uniqueness on columns.,    Indexes are created to enable fast retrieval by column values.,    Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.,    Indexes are created with the ALTER TABLE command.

Ans:D ,D

. The capacity of 3.5 inch floppy disk is

Options: A) 1.40 MB B) 1.44 GB C) 1.40 GB D) 1.44 MB


Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Options: a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home

Ans:#8211; a,#8211; a