In Excel, the Fill Color button on the Formatting toolbar is used for what?

Options: To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.

Ans:– D ,

Description: mcqquestions

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

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

The table created by lexical analysis to describe all literals used in the source program, is:
Options: Terminal table,    Literal table,    Identifier table,    Reductions

Ans:B ,B

. Which command is used to undelete a bunch of files withextension .doc that you have just deleted?
Options: a. Undelete b. Undelete/all c. Undelete *.doc d. All of above

Ans:- c,- c

Which statement about sequences is not true?
Options: A sequence is an object that generates a sequential series of unique numbers.,    Sequences are most often used to provide values for surrogate keys.,    NextVal and CurrVal are both sequence methods.,    Sequences guarantee valid surrogate key values.

Ans:D ,D

Ctrl + C
Options: Copy the selected text B. Cut the selected text C. Print the selected text D. Paste the selected text

Ans:– A ,

Point out the error in the following program. #include<stdio.h> void display(int (*ff)()); int main() { int show(); int (*f)(); f = show; display(f); return 0; } void display(int (*ff)()) { (*ff)(); } int show() { printf("IndiaBIX"); }
Options: Error: invalid parameter in function display(),    Error: invalid function call f=show;,    No error and prints "IndiaBIX",    No error and prints nothing.

Ans:C ,C

The _____ symbol is used in a flowchart to represent a calculation task.
Options: Input,    Output,    Process,    Start

Ans:C ,C

. … show characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:3 – a ,3 – a

What is meant by quad-density (QD) diskette?
Options: It is double-sided disk,    It is double density disk,    It has double the number of tracks per inch,    All of the above


The relational database environment has all of the following components except
Options: a. users b. separate files c. database d. query languages


The name box
Options: a. Shows the location of the previously active cell b. Appears to the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:#8211; b,#8211; b

Which device uses much less computer time than the light pen and gives resolutions equal to that of the CRT display.
Options: Mouse,    Touch tablet,    Touch panel,    Data tablet

Ans:D ,D

. Poor response time are usually caused by
Options: a. Process busy b. High I/I rates c. High paging rate d. Any of the above

Ans:9 – d ,9 – d

What MySQL property is used to create a surrogate key in MySQL?
Options: UNIQUE,    SEQUENCE,    AUTO_INCREMENT,    None of the above -- Surrogate keys are not implemented in MySQL.

Ans:C ,C

A group of 2m - 1 routers are interconnected in a centralized binary tree, with router at each tree node. Router I communicate with router J by sending a message to the root of the tree. The root then sends the message back down to J. Then find the mean router-router path length.
Options: 2 (m - 2),    2 (2m - 1),    m - 1,    (2m - l)/mJ

Ans:A ,A

A 4 KHz noise less channel with one sample ever 125 per sec is used to transmit digital signals. If Delta modulation is selected, then how many bits per second are actually sent?
Options: 32 kbps,    8 kbps,    128 kbps,    64 kbps.

Ans:B ,B

What does the port number in a TCP connection specify?
Options: It specifies the communication process on the two end systems B. It specifies the quality of the data & connection C. It specify the size of data D. All of the above

Ans:– A ,

A noiseless 3 KHz Channel transmits bits with binary level signals. What is the maximum data rate?
Options: 3 Kbps,    6 Kbps,    12 Kbps,    24 Kbps.

Ans:B ,B

The Nolan _____ model identifies several phases that describe the development of information systems in organizations.
Options: stage,    plan,    decision,    master

Ans:A ,A

Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above


11. Word, by default, places a tab stop at every _____ mark on the ruler.
Options: a. .25″ b. .5″ c. .75″ d. 1″

Ans:– B ,– B

In analyzing the compilation of PL/I program, the description "resolving symbolic address (labels) and generating machine language" is associated with
Options: Assembly and output,    Code generation,    Storage assignment,    Syntax analysis

Ans:A ,A

RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A ,A

Which of the following commands is used to save the output of the who command in a file named user.lst, as well as display it?
Options: who | tee user.lst,    who > user.lst,    who >> user.lst,    who < user.lste

Ans:A ,A

. After right click the field selector button, which do you choose to delete a field in design view?
Options: a. Delete field b. delete rows c. remove field d. remove rows

Ans:– b,– b

Round-robin scheduling
Options: allows interactive tasks quicker access to the processor,    is quite complex to implement,    gives each task the same chance at the processor,    allows processor-bound tasks more time in the processor

Ans:C ,C

During the maintenance phase
Options: System requirements are established,    System analysis is carried out,    Programs are tested,    All of the above

Ans:E ,E

Which of are following internal commands is used in mail to forward mail to user in user-list?
Options: r user-list,    m user-list,    d user-list,    e user-list

Ans:B ,B

  A Chart can be put as a part of the presentation using
Options: Insert -> Pictures –> Chart B. Insert –> Chart      C. Edit –> Chart D. View -> Chart

Ans:– A ,

Which of the following protocol is/are defined in Transport layer?
Options: FTP B. TCP C. UDP D. B & C

Ans: – D ,

Ctrl + P
Options: a. Open Paragraph Dialog Box b. Open Page Format Dialog Box c. Open Save Dialog Box d. Open Print Dialog box

Ans:–  D,–  D

A subtype discriminator is which of the following?
Options: An attribute of the supertype whose values determine the subtype,    An attribute of the subtype whose values determine the supertype,    An attribute of the supertype whose values determine the supertype,    An attribute of the subtype whose values determine the subtype

Ans:A ,A

. The box on the chart that contains the name of each individual record is called the ________.
Options: a. cell b. title c. axis d. legend

Ans:– d,– d

In a computer _____ is capable to store single binary bit.
Options: Capacitor B. Flip flop C. Register D. Inductor

Ans:– B ,

Which of the following is a graphic representation of the modules in the System and the interconnection between them
Options: Pie chart,    Flow chart,    Structural chart,    System chart

Ans:C ,C

Which of the following is a technique for hiding the internal implementation details of an object?
Options: Encapsulation,    Polymorphism,    Inheritance,    All of the above.

Ans:A ,A

Which of the following is not true of the traditional approach to information processing?
Options: There is common sharing of data among the various applications,    It is file-oriented,    Programs are dependent on the files,    It is inflexible

Ans:A ,A

A development strategy whereby the executive control modules of a system are coded and tested first, is known as
Options: Bottom-up development,    Top-down development,    Left-Right development,    All of the above

Ans:B ,B

. The computer that process both analog and digital is called
Options: A) Analog computer B) Digital computer C) Hybrid computer D) Mainframe computer


_____ write computer programs that perform jobs specified by the user.
Options: Programmer,    Data entry operator,    System Analyst,    Computer operator

Ans:A ,A

One of the following is not considered a method of input control in a CAD system.
Options: Joystick,    Programmable function box,    Plotter,    Touch terminal

Ans:C ,C

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options: LIKE only.,    IN only.,    NOT IN only.,    Both IN and NOT IN.

Ans:D ,D

What command is used with vi editor to delete three words?
Options: 3$d,    3 dw,    3 x,    3 dd

Ans:B ,B

The first step in systems Development Life Cycle is
Options: database design,    system design,    preliminary investigation and analysis,    graphical user interface

Ans:C ,C

95. What is the shortcut key to Update Formula in a table?
Options: a. F9 b. Alt + F9 c. Ctrl + F9 d. Shift + F9

Ans:–  A ,–  A

. What is the symbol for dividing? A ./ B. % C. & D. #
Options: A ./ B. % C. & D. #

Ans:– A ,/

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

Ans:A ,A

The [line number G] key allows you
Options: to move cursor left by one position,    to move cursor right by one position,    to move cursor down by one line,    to move cursor to the beginning of the line specified by the number

Ans:D ,D

93. What is the shortcut key to “Center Align” the selected text?
Options: a. Ctrl + C b. Ctrl + E c. Ctrl + F d. None of above

Ans:–  B ,–  B

Which of the following is not a computer bus?
Options: data bus,    timer bus,    control bus,    address bus

Ans:B ,B

A microporgram is sequencer perform the operation  
Options: a . read b . write c . execute d . read and execute

Ans:D,Read and Execute