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 ,

More MS-Excel Related questions:

  Which option can be used to create a new slide show with the current slides but presented in a different order?
Options: Rehearsal B. Custom Slide show C. Slide Show Setup D. Slide Show View

Ans:– B ,

A Ring, refers to a record chain, the last of which refers to the first record, in the chain, is called a/an
Options: addressing,    location,    pointer,    loop

Ans:C ,C

The FIFO algorithm
Options: executes first the job that last entered the queue,    executes first the job that first entered the queue,    execute first the job that has been in the queue the longest,    executes first the job with the least processor needs

Ans:B ,B

The advantage of optimistic locking is that:
Options: the lock is obtained only after the transaction has processed.,    the lock is obtained before the transaction has processed.,    the lock never needs to be obtained.,    transactions that are best suited are those with a lot of activity.

Ans:A ,A

. What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options: A) Compiler B) Interpreter C) Debugger D) Assembler


. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Options: a. 5 b. 8 c. 24 d. Not enough information to tell

Ans:9 – c ,9 – c

Computer-based traffic control systems are implemented at the _____ level of government.
Options: Local,    Top,    bottom,    Top-to-bottom

Ans:A ,A

Compared to an open-loop system, a closed-loop control system is:
Options: more accurate,    more complex,    more stable,    All of the above

Ans:D ,D

Special programs that assist programmers are called:
Options: heuristic processors,    symbolic programmers,    intelligent programming tools,    program recognizers

Ans:C ,C

Which of the following is the oldest spreadsheet package?
Options: a. VisiCalc b. Lotus 1-2-3 c. Excel d. StarCalc

Ans:#8211; a,#8211; a

. A command to remove a relation from an SQL database
Options: Delete table <table name> B. Drop table <table name> C. Erase table <table name> D. Alter table <table name>

Ans: – B ,

The Al researcher who co-authored both the Handbook of Artificial Intelligence and The Fifth Generation is:
Options: Bruce Lee,    Randy Davis,    Ed Feigenbaum,    Mark Fox

Ans:C ,C

The two major types of computer chips are
Options: A) External memory chip B) Primary memory chip C) Microprocessor chip D) Both b and c


The company that grew out of research at the MIT AI lab is:
Options: AI corp,    LMI,    Symbolics,    both (b) and (c)

Ans:D ,D

The strategy of allowing processes that are logically runnable to be temporarily suspended is called
Options: preemptive scheduling,    non preemptive scheduling,    shortest job first,    first come first served

Ans:A ,A

What is a brand?
Options: A) The name of companies that made computers B) The name of product a company gives to identify its product in market C) A name of class to indicate all similar products from different companies D) All of above


. The expression builder is an access tool that controls an expression___ for entering an expression
Options: a. Table b. Box c. Cell d. Palette

Ans:6 – b ,6 – b

Bridge works in which layer of the OSI model?
Options: Appliation layer B. Transport layer                    C. Network layer D. Datalink layer

Ans:– D ,

The term scheme means
Options: the relationship service bureau,    a map of overall structure of a database.,    a parent with no owners,    two dimensional table

Ans:B ,B

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options: Data modeling,    Database design,    Metadata,    All of the above.

Ans:B ,B

.   Which of the following is not a transition effect?
Options: a. Blinks diagonal b. Dissolve c. Fade through black d. Blinds vertical

Ans:0 – A ,0 – A

. How can you get your photo album slide show to play continuously?
Options: a. Use random slide transition b. Launch an online broadcast c. Loop continuously d. All of above

Ans:8 – C ,8 – C

. The Search tool CANNOT be used on which major Access object?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:2 – c ,2 – c

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

Ans:– C ,

. Which among the following are the best tools for fixing the errors?
Options: a. Fdisk b. Scandisk c. CHKDSK d. Fixdisk

Ans:1 – b ,1 – b

A memory bus is mainly used for communication between
Options: processor and memory,    processor and I/O devices,    I/O devices and memory,    input device and output device

Ans:A ,A

. Which of the following computer implemented binary numbers, perform calculations using electronics and implemented separate computation and memory for the first time?
Options: A) Mark I B) ABC C) Z3 D) None of above


A microprocessor:
Options: is another name for a computer,    is a CPU in integrated circuit form,    executes a program of instructions,    (a) and (c)

Ans:D ,D

Floppy disks which are made from flexible plastic material are also called?
Options: hard disks,    high-density disks,    diskettes,    templates

Ans:C ,C

The lowest form of computer language is called:
Options: FORTRAN,    BASIC,    machine language,    COBOL

Ans:C ,C

In a pure inductor:
Options: ac current leads the voltage by 90 degree,    ac current and voltage are exactly in phase,    ac current lags the voltage by 90 degree,    ac current is converted to dc voltage

Ans:C ,C

Which of the following is not true of future computers?
Options: increased use of CAD/CAM techniques,    faster turnaround time,    developments in artificial intelligence systems,   All are true

Ans:D,all are true

The CAI (Computer-Assisted Instruction) technique based on programmed instruction is:
Options: frame-based CAI,    generative CAI,    problem-solving CAI,    intelligent CAI

Ans:A ,A

. In databases, Locking level is also called as
Options: a. Granularity b. S lock c. X lock d. Dead lock

Ans:– a,– a

The radian of a number system
Options: Is variable,    Has nothing to do with digit position value,    Equals the number of its distinct counting digits,    Is always an even number

Ans:C ,C

Versatile report generators can provide
Options: Columnar totals,    Subtotals,    Calculations,    All of the above

Ans:D ,D

Actuators are used to:
Options: sense an object,    activate a chemical,    make a mechanical movement,    All of the above

Ans:C ,C

. How do you rearrange the data in ascending or descending order?
Options: Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

Ans: – A ,

A WATS arrangement
Options: is always less expensive than flat-rate service,    is less expensive than flat-rate service only when the number of calls is large and the duration of each is short,    is less expensive than flat-rate service only when the number of calls is small and the duration of each is long,    is never less expensive than flat-rate service

Ans:B ,B

Distributed Queue Dual Bus is a standard for
Options: LAN,    MAN,    WAN,   LAN and MAN

Ans:D,LAN and MAN

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 types of charts can excel produce?
Options: a. Line graphs and pie charts only b. Only line graphs c. Bar charts, line graphs and pie charts d. Bar charts and line graphs only

Ans:– c,– c

Which option is not available in Insert Table Autofit behavior?
Options:  A) Fixed Column Width, B) AutoFit to Contents, C) Autofit to Window, D) Autofit to Column,


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

Point out the error in the program #include<stdio.h> int main() { int i; #if A printf("Enter any number:"); scanf("%d", &i); #elif B printf("The number is odd"); return 0; }
Options: Error: unexpected end of file because there is no matching #endif,    The number is odd,    Garbage values,    None of above

Ans:A ,A

Batch processing is appropriate if
Options: a large computer system is available,    only a small computer system is available,    only a few transactions are involved,    All of the above

Ans:E ,E

Which of the following is the second step in creating a macro?
Options:  A) Start recording, B) Using your mouse or keyboard, perform the task you want to automate, C) Assign a keyboard shortcut to the macro, D) Give the macro a name,


. What is one of the advantages for using a form over other Access objects?
Options: a. Utilizes field placement to improve the efficiency of data entry. b. Forms store information more efficiently. c. Forms show the summary of all the records. d. Forms cannot be edited.

Ans:0 – a ,0 – a

The necessary conditions needed before deadlock can occur?
Options:  No Mutual Exclusion, Hold and wait, Preemption, Circular Wait B.  Mutual Exclusion, No Hold and wait, Preemption, Circular Wait C.  Mutual Exclusion, Hold and wait, No Preemption, Circular Wait D.  Mutual Exclusion, Hold and wait, Preemption, No Circular Wait

Ans:– C ,

  Shortcut key to insert a hyperlink in a slide A.  Ctrl + H B.  Ctrl + K C.  Hyperlinks can’t be inserted in slides D.  None of the above

Ans:– B ,