What is represented by the small, black square in the lower-right corner of an active cell or range?

Options: Copy handle B. Fill handle C. Insert handle D. Border

Ans:– B ,

Description: mcqquestions

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

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

23. What is the default font size of a new Word document based on Normal template in Word 2003?
Options: a. 10 pt b. 12 pt c. 14 pt d. None of above

Ans:– B ,– B

. Which of the following storage device can store the largest amount of data?
Options: A) Hard Disks B) Flash Disks C) Blu-Ray Disks D) DVDs


. To change the screen saver you can go from
Options: a. Control panel display b. Right click in desktop and properties c. Both of above d. None of these

Ans:0 – c ,0 – c

The EIA-232 interface has _____ pins.
Options: 20,    24,    25,    30

Ans:C ,C

What is offset error?
Options: the difference between the sensor input and the absolute sensed parameter.,    the difference between the controller output and the setting of the manipulated variable.,    the difference between the control setpoint value and the actual value.,    All of the above

Ans:C ,C

The function(s) of file system is (are):
Options: to provide complete file naming freedom to the users and to permit controlled sharing of files,    to provide for long and short term storage of files with appropriate economic tradeoffs.,    to provide security against loss of information due to system failure,    all of the above

Ans:D ,D

An example of a global allocation problem is
Options: defining plant capacities,    scheduling an entire development project,    setting general inventory guidelines,    All of the above

Ans:D ,D

When two computers communicate with each other, they send information back and forth. If they are separated by a reasonable distance, they can send and receive the information through a direct cable connection which is called a null-modem connection. Presently what is the maximum distance in metres permitted in this null-modem connection?
Options: 80,    100,    30,    150

Ans:C ,C

Which of the following is true for machine language.
Options: Repeated execution of program segments,    Depicting flow of data in a system,    A sequence of instructions which, when followed properly, solves a problem,    the language which communicates with the computer using only the binary digits 1 and 0.

Ans:D ,D

. The Second Generation Computer was based on ________.
Options: A) Vacuum Tube B) Silicon Chips C) Transistor D) Bio Chips


What can greatly reduce TCP/IP configuration problems?
Options: WINS Server,    WINS Proxy,    DHCP Server,    PDC

Ans:C ,C

. How many symbols exist in Baudot code?
Options: A) 32 B) 116 C) 58 D) 76


. Which number system is usually followed in a typical 32-bit computer?
Options: A) Binary B) Decimal C) Hexadecimal D) Octal


An organization containing manufacturing, marketing, and finance areas is called a
Options: matrix organization,    flow network organization,    modular organization,    functional organization

Ans:D ,D

Which memory is nonvolatile and may be written only once?
Options: RAM,    EE-ROM,    RAM,    PROM

Ans:D ,D

. In the Field List of a table, the primary key appears _______________.
Options: a. bold b. italicized c. underlined d. with key icon

Ans:6 – d ,6 – d

A network administrator wants to upgrade the IOS of a router without removing the image currently installed. What command will display the amount of memory consumed by the current IOS image and indicate whether there is enough room available to hold both the current and new images?
Options: show version,    show flash,    show memory,    show buffers

Ans:B ,B

Critical _____ factors are those that are vital if a manager is to make a full contribution to the achievement of an organization's goals.
Options: tactical,    success,    decision,    concise

Ans:B ,B

Point out the error in the following program. #include<stdio.h> int main() { char str[] = "IndiaBIX"; printf("%.#s %2s", str, str); return 0; }
Options: Error: in Array declaration,    Error: printf statement,    Error: unspecified character in printf,    No error

Ans:D ,D

A data warehouse uses:
Options: partial operational data.,    historical operational data.,    future operational data.,    health care data.

Ans:B ,B

The HAVING clause does which of the following?
Options: Acts like a WHERE clause but is used for groups rather than rows.,    Acts like a WHERE clause but is used for rows rather than columns.,    Acts like a WHERE clause but is used for columns rather than groups.,    Acts EXACTLY like a WHERE clause.

Ans:A ,A

 This task pane shows the design that is currently being used in a presentation.
Options:  Slide Show B.  Slide Style C.  Slide Design D.  Slide Format

Ans: – C ,

What will be the output of the program? #include<stdio.h> typedef void v; typedef int i; int main() { v fun(i, i); fun(2, 3); return 0; } v fun(i a, i b) { i s=2; float i; printf("%d,", sizeof(i)); printf(" %d", a*b*s); }
Options: 2, 8,    4, 8,    2, 4,    4, 12

Ans:D ,D

In the following code what is 'P'? typedef char *charp; const charp P;
Options: P is a constant,    P is a character constant,    P is character type,    None of above

Ans:A ,A

Which command is used to concatenate all files beginning with the string 'emp' and followed by a non-numeric characters?
Options: cat emp[!0-9],    more [emp][!0-9],    cat emp[x-z],    cat emp[a-z]

Ans:A ,A

Which of the following is not a characteristic of good test data
Options: users do not participate at this preliminary stage,    should be comprehensive,    every statement should be executed,    All of the above

Ans:A ,A

5. you can copy command.com to your disk from hard disk
Options: a. true b. false    

Ans:Correct Answer: a ,Correct Answer: a

What are the data transmission channels available for carrying data from one location to another?
Options: Narrowband,    Voiceband,    Broadband,    All of the above

Ans:D ,D

Which of the following concept is best to preventing page faults?
Options:  Paging B.  The working set C.  Hit ratios D.  Address location resolution

Ans:– B ,

Queries in Access can be used as
Options: a. view, change and analyze data in different ways b. a source of records for forms and reports c. Only a d. Both a and b

Ans:ndash; d,ndash; d

Which option in File pull-down menu is used to close a file in MSWord?
Options: New B. Quit C. Close D. Exit

Ans:– C ,

Linked lists are best suited
Options: A)for relatively permanent collections of data b.for the size of the structure and the data in the structure are constantly changing c.for both of above situation d.for none of above situation

Ans:B, For the size of the structure and the data in the structure are constantly changing

Which of the following is not anti-viruses software?
Options: NAV B. F-Prot C. Oracle D. McAfee

Ans:– C ,

The first items defined for a new system are its :
Options: inputs,    outputs,    storage,    processing

Ans:B ,B

. Database properties do NOT include ___________.
Options: a. title b. author c. company d. size

Ans:8 – d ,8 – d

Which of the following commands is used to count the total number of lines, words, and characters contained in a file.
Options: count p,    wc,    wcount,    countw

Ans:B ,B

A process controller:
Options: can interface to digital and analog I/O,    is useful in a continuous process control application,    can solve a PID process control equation easily,    All of the above

Ans:D ,D

. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Options: a. Datasheet b. Justified c. Stacked d. Tabular

Ans:0 – d ,0 – d

Which of the following commands is used to display the filenames in multiple columns?
Options: ls,    ls -1,    ls -x,    lc

Ans:C ,C

Advantages of robots include:
Options: increased productivity,    ability to withstand hazardous environments,    good return on investment and better company image,    All of the above

Ans:D ,D

The Average case occur in linear search algorithm
Options: a. When Item is somewhere in the middle of the array b. When Item is not in the array at all c. When Item is the last element in the array d. When Item is the last element in the array or is not there at all  


.Finding the location of the element with a given value is:
Options: A)Traversal b.Search c.Sort d.None of above


What is the standard code the computer industry created to represent characters?
Options: DASI,    ASSH,    ASCII,    BASCII

Ans:C ,C

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

Ans:A ,A

Batch processing is appropriate if
Options: a . large computer system is available b . only a small computer system is avilbale c . only a few transactions are involved D . none of the above

Ans:D,none of the above

Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of child table if that value does not exist in  the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does  not exist in the primary key of the child table d. All of above

Ans:ndash; a,ndash; a

The earliest calculating devices are
Options: Abacus B. Clock C. Difference Engine D. None of these

Ans:– A ,

. A series of MS-DOS Commands can be performed by
Options: Typing all the commands Prompt in series by adding hyphen (-) B. Copying all the commands into single Directory C. Creating BAT File D. This is not possible in MS-Dos

Ans:– C ,

In comparison with static RAM memory, the dynamic RAM memory has
Options: lower bit density and higher power consumption,    higher bit density and higher power consumption,    lower bit density and lower power consumption,    higher bit density and lower power consumption


Most disk drives have a single read/ write head for each disk surface. What is the advantage of suing multiple heads on each movable access arm?
Options: Reduced seek time,    Less latency time,    Reduced search time,    Less disk speed

Ans:A ,A