What is the AutoComplete feature of Excel?

Options: It automatically completes abbreviated words B. It completes text entries that match an existing entry in the same column C. It completes text and numeric entries that match an existing entry in the same column D. It completes text entries that match an existing entry in the same worksheet

Ans:– B ,

Description: mcqquestions

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

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

In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:A ,A

In which way is a managerial information system (MIS) superior to electronic data processing (EDP)?
Options: It is batch oriented,    It is most cost effective,    It provides summary reports without details,    All of the above

Ans:C ,C

Which of the following methods cannot be used to enter data in a cell
Options: a. Pressing an arrow key b. Pressing the Tab key c. Pressing the Esc key d. Clicking on the formula bar

Ans:C, Pressing the Esc key

The microelectronics is the technology of
Options: microwaves,    microcomputers,    chips,    automatic processing

Ans:C ,C

The basic difference between broadband and baseband is:
Options: availability,    capacity,    reliability,    transmission

Ans:B ,B

Why is the width of the data bus so important to the processing speed of a computer?
Options: The narrower it is, the greater the computer's processing speed,    The wider it is, the more data that can fit into main memory,    The wider it is, the greater the computer's processing speed,    The wider it is, the slower the computer's processing speed

Ans:C ,C

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

Which of the following is not a sequence storage device?
Options: Magnetic disk,    Magnetic tape,    Paper tape,    All of the above

Ans:A ,A

. When was the transistors invented?

Options: A) 1948 B) 1938 C) 1958 D) 1968


Which of the following is used for modulation and demodulation?
Options: modem,    protocols,    gateway,    multiplexer

Ans:A ,A

. If you want to keep track of different editions of a document which features will you use?
Options: a. Editions b. Versions c. Track Change d. All of above

Ans: – B , – B

. The first digital computer built with IC chips was known as
Options: A) IBM 7090 B) Apple ? 1 C) IBM System / 360 D) VAX-10


Which of the following tools is not used for process descriptions?
Options: pseudocodes,    decision tables,    structured english,    data dictionaries

Ans:D ,D

SQL stands for ________ .
Options: Structured Query Language,    Sequential Query Language,    Structured Question Language,    Sequential Question Language

Ans:A ,A

  Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
Options: Color Schemes B. Animation C. Transition Settings D. Handouts

Ans:– C ,

Which of the following are unary operators in C? 1. ! 2. sizeof 3. ~ 4. &&
Options: 1, 2,    1, 3,    2, 4,    1, 2, 3

Ans:D ,D

Data manipulation language (DML)
Options: describes how data are structured in the data base,    specifies for the DBMS what is required; the techniques used to process data,    determine how data must be structured to produce the user's view,    All of the above

Ans:B ,B

. On a PC, how much memory is available to application software?
Options: A) 1024 KB B) 760 KB C) 640 KB D) 560 KB


. Signals can be analog or digital and a computer that processes the both type of signals is known as
Options: A) Analog computer B) Digital Computer C) Hybrid Computer D) Mainframe Computer


Which of the following provide inter-switch VLAN communication? ISL VTP 802.1Q 802.3Z
Options: 2 only,    1 and 3,    2 and 4,    2, 3 and 4

Ans:B ,B

.   We can replace a font on all sides with another font using the …. option
Options: a. Edit, Fonts b. Tools, Fonts c. Tools, Replace Fonts d. Format, Replace Fonts

Ans:3 – D ,3 – D

In order to use a record management system
Options: You need to understand the low-level details of how information in stored,    You need to understand the model the record management system uses.,    Both (a) and (b),    All of the above

Ans:B ,B

. Which command is used to list out deleted files in DOS?
Options: a. list b. Undelete/list c. Recover d. All of the above

Ans:3 – b ,3 – b

The accuracy of the floating-point numbers representable in two 16-bit words of a computer is approximately
Options: A) 16 digits B) 6 digits C) 9 digits D) All of above


Which two commands enable you to move between directories?
Options: CD,    CHDIR,    MOVE,    MOVE DIR

Ans:A ,A

An internal storage consisting of arrays of small rings of magnetic material called ferrite is
Options: Magnetic tape,    Magnetic core,    Magnetic disk,    Optical mark reader

Ans:B ,B

. In Excel, by default Numeric Values appears in
Options: a. Left aligned b. Right aligned c. Center aligned d. Justify aligned

Ans:– b,– b

A Processor
Options: is a device that performs a sequence of operations specified by instructions in memory.,    is the device where information is stored,    is a sequence of instructions,    is typically characterized by interactive processing and time of the CPU's time to allow quick response to each user.

Ans:A ,A

. Scandisk
Options: a. Checks the disk b. Give information about disk c. Run from DOS mode d. All of the above

Ans:9 – d ,9 – d

Which of the following situation requires the use of ID-dependent entities?
Options: Association relationships only,    Multivalued attributes only,    Archetype/instance relationships only,    All of the above use ID dependent entities

Ans:D ,D

A NAND gate has:
Options: LOW inputs and a LOW output,    HIGH inputs and a HIGH output,    LOW inputs and a HIGH output,    None of the these

Ans:C ,C

. An operating system is a program or a group of programs that
Options: a. Helps in checking the spelling of Word b. Maintain the relationship in Database c. Manages the resources of the Computer d. Performs the calculations of cells in Excel

Ans:2 – c ,2 – c

The time factor when determining the efficiency of algorithm is measured by
Options: a. Counting microseconds b. Counting the number of key operations c. Counting the number of statements d. Counting the kilobytes of algorithm  


What does fp point to in the program ? #include<stdio.h> int main() { FILE *fp; fp=fopen("trial", "r"); return 0; }
Options: The first character in the file,    A structure which contains a char pointer which points to the first character of a file.,    The name of the file.,    The last character in the file.

Ans:B ,B

hat is the shortcut key to show font dialog box?
Options: Ctrl + D B. Ctrl + Shift + F C. Ctrl + Shift + P D. All of the above

Ans:– D ,

Most of the flow of physical resources occurs on the
Options: top management level,    middle management level,    lower management level,    All of the above

Ans:C ,C

. Most of the inexpensive personal computers do not have any disk or diskette drive. What is the name of such computes?

Options: A) Home computers B) Diskless computers C) Dedicated computers D) General purpose computers


. “New Comment” option can be found under _________ tab
Options: Insert B. Data C. Review D. View

Ans:– C ,

An electronic logic gate whose output is logic 0 only when all inputs are logic 1 is
Options: NOR,    NAND,    OR,    NOT

Ans:B ,B

. Who invented Integrated Circuits?
Options: A) Jack Kilby B) Robert Noyce C) Both of above D) None of above


. Small pictures appear on the desktop
Options: a. Windows b. Icon c. Button d. None of above

Ans:4 – b ,4 – b

When an entity instance must be a member of only one subtype, it is which of the following?
Options: Disjoint with total specialization,    Disjoint with partial specialization,    Overlap with total specialization,    Overlap with partial specialization

Ans:A ,A

.   Ellipse Motion is a predefined ….
Options: a. Design template b. Color scheme c. Animation scheme d. None of these

Ans:1 – C ,1 – C

Which feature helps you to inserts the contents of the Clipboard as text without any formatting
Options: a. Paste Special b. Format Painter c. Page Setup d. Styles

Ans:–  A,–  A

On the PC side, the printer port is a:
Options: 25 pin female parallel connector,    15 pin female parallel connector,    25 pin male serial connector,    15 pin female serial connector

Ans:A,25 pin female parallel connector

Which of the following services dynamically resolves NetBIOS-to-IP resolution?
Options: DNS,    DHCP,    WINS,    LMHOSTS

Ans:C ,C

There are several procedures you can implement to provide maximum security. The most important of these is:
Options: do not leave training manuals unsecured,    run regular simulated tests using TARP (testing of Applications Recovery Planes),    Verify the reputation of the people installing your system,    do not allow unbonded service people to work on your equipment

Ans:B ,B

.   Which of the following is not a feature of PowerPoint?
Options: a. Printing transparencies b. Printing the speaker’s notes along with slide images c. Linking a slide transition with a laser pointer d. Drawing with a pen

Ans:7 – C ,7 – C

SQL query and modification commands make up a(n) ________ .
Options: DDL,    DML,    HTML,    XML

Ans:B ,B

. 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