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






More MS-Excel Related questions:


The advantage(s) of incorporating the macro processor into pass 1 is(are):
Options: many functions do not have to be implemented twice.,    Functions are combined and it is not necessary to create intermediate files as output from the macros processor and input to the assembler.,    more flexibility is available to the programmer in that he may use all the features of the assembler in conjunction with macros.,    all of the above

Ans:D ,D


To get the Norton current, you have to
Options: Short the load resistor,    Open the load resistor,    Short the voltage source,    Open the voltage source

Ans:C ,C


A compound key
Options: is made up a several pieces of information,    uniquely identifies an item in a list,    both (a) and (b),    is a combination of each unique key

Ans:C ,C


. Using the ribbon where should you go to activate the ruler on your document?
Options: a. View >> toolbars b. File >> Open c. View >> Ruler d. Insert >> Reference

Ans: – C , – C


.   To adjust the width of table columns, you
Options: a. Click table menu. Column width, then make adjustments b. Drag the vertical gridline between two columns c. Drag the column markers on the table ruler bar d. b and c

Ans:7 – D ,7 – D


An Audit trial is
Options: a feature of data processing systems that allows for the study of data as processed from step to step; and auditor can then trace all transactions that affect an account.,    a data item that characterizes an object,    two or more data items handled as a unit,    All of the above

Ans:A ,A


What will be the output of the program? #include<stdio.h> #define SQR(x)(x*x) int main() { int a, b=3; a = SQR(b+2); printf("%d\n", a); return 0; }
Options: 25,    11,    Error,    Garbage value

Ans:B ,B


. The commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above

Ans:D,D


Which of the following is not a quotation system procedure set?
Options: delivery planning,    product data retrieval,    quotation preparation,    all of the above

Ans:A ,A


ODBC minimum SQL grammar contains which of the following?
Options: INSERT, UPDATE, DELETE only,    Stored Procedures only,    Literals for date, time and timestamp only,    CREATE VIEW, DROP VIEW only

Ans:A ,A


What is the default number of lines to drop for drop cap?
Options:  A) 3, B) 10, C) 15, D) 20,

Ans:-A,-A


You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
Options: user data.,    metadata,    A report,    indexes

Ans:B ,B


. The shortcut key to open a task manager is:
Options: a. Alt + F1 b. Alt + Ctrl + Delete c. Alt + Tab d. F1

Ans:0 – b ,0 – b


Which of the following is a graphical input device?
Options: light pen,    keyboard,    mouse,    Track ball

Ans:A ,A


An integrated circuit is
Options: a complicated circuit,    an integrating device,    much costlier than a single transistor,    fabricated on a tiny silicon chip

Ans:D ,D


In Computer terminology ‘CAD’ is stands for
Options: A. Computer And Design B. Computer Algorithm in Design C. Computer Aided Design D. None of the above

Ans:C,


. What lets you to create new presentation by selecting ready-made font color and graphics effects?
Options: a.  Presentation Template b.  Master Slide c.  Design Template d.  Animation Scheme

Ans:1 – C ,1 – C


Which of the following rules out the use of GO TO?
Options: Flowchart,    HIPO-DIAGRAMS,    Nassi-Shneiderman diagram,    All of the above

Ans:C ,C


Which of the following is an example of a standard IP access list?
Options: access-list 110 permit host 1.1.1.1,    access-list 1 deny 172.16.10.1 0.0.0.0,    access-list 1 permit 172.16.10.1 255.255.0.0,    access-list standard 1.1.1.1

Ans:B ,B


IEEE project 802 divides the data link layer into an upper _____ sublayer and a lower _____ sublayer.
Options: HDLC, PDU,    PDU, HDLC,    MAC, LLC,    LLC, MAC

Ans:D ,D


A 'number crunching' computer is one that can handle
Options: large spreadsheets,    large alphanumeric data,    large volume of numbers,    only numbers

Ans:C ,C


. Which of the following is correct syntax in Excel?
Options: a. =IF(LogicalTest, TrueResult, FalseResult) b. =IF(LogicalTest, (TrueResult, FalseResult)) c. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) d. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Ans:– a,– a


. To read through a document you may
Options: a. Use the arrow key b. Dragging the scroll box on the scroll bar c. Use your ENTER key to go down line by line d. Only A & B

Ans: – D , – D


. CAD software is most likely to be used by
Options: a. Web designer b. Engineers c. Project Manager d. Magazine Editor

Ans:0 – b ,0 – b


. In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
Options: a. calendar b. photograph of rainfall c. chart showing rainfall amounts d. database of rainfall

Ans:– c,– c


Which command of MS-DOS is used to copy only files that have been modified on or after the date you specify?
Options: XCOPY/D : date,    COPY/D : date,    COPY/M,    XCOPY/V

Ans:A ,A


What is the default subnet mask for a class B network?
Options: 127.0.01,    255.0.0.0,    255.255.0.0,    255.255.255.0

Ans:C ,C


Poor data administration can lead to which of the following?
Options: A single definition of the same data entity,    Familiarity with existing data,    Missing data elements,    All of the above.

Ans:C ,C


Which one of the following equations most directly determines the power dissipation of a resistance when you know the power dissipation of a resistance when you know the voltage drop and current?
Options: P = IE,    P = E2/R,    P = I2R,    I = P/E

Ans:A ,A


Which of the following file retrieval methods use hypermedia?
Options: HTTP,    WAIS,    Veronica,    Archie

Ans:A ,A


Word length of a Personal Computer is ___
Options: 4 bits B. 8 bits C. 16 bits D. 64 bits

Ans:– B ,


It is most common type of query. It retrieves records from one or more tables and then displays the
Options: a. Parameter b. Select c. crosstab d. All of above

Ans:ndash; b,ndash; b


What command is used to assign only read permission to all three categories of the file'letter'?
Options: chmod u + r, g + r, o - x letter,    chmod ugo = r letter,    chmod a - rw letter,    chmod go + r letter

Ans:B ,B


87. Which of the following is not available in Font Spacing?
Options: a. Normal b. Loosely c. Condensed d. Expanded

Ans:– B ,– B


The relational model consists of:
Options: data in the form of tables.,    data redundancy.,    operations using non-SQL languages.,    unorganized data.

Ans:A ,A


For speech understanding systems to gain widespread acceptance in office automation, they must feature:
Options: speaker independence,    speaker dependence,    isolated word recognition,    All of the above

Ans:A ,A


. Pick out odd
Options: a. Windows b. Window c. DOS d. Linux

Ans:5 – b ,5 – b


. Which query do you use to answer the question “What is the average salary of the employees”?
Options: a. Search query b. Cross tab query c. Select query d. Update query

Ans:– c,– c


A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options: Network,    Relational,    Client Server,    Hierarchical

Ans:C ,C


.   Animation schemes can be applied to ….. in the presentation
Options: a. All slides b. Select slides c. Current slide d. All of the above

Ans:5 – D ,5 – D


The slide that is used to introduce a topic and set the tone for the presentation is called the
Options: a. table slide b. graph slide c. bullet slide d. title slide

Ans: – D , – D


Which is not a data source component?
Options:  A) mail merge toolbar, B) header row, C) data fields, D) data records, 

Ans:-A,-A


Assembler is
Options: a program that places programs into memory and prepares them for execution.,    a program that automate the translation of assembly language into machine language.,    a program that accepts a program written in a high level language and produces an object program.,    is a program that appears to execute a source program as if it were machine language.

Ans:B ,B


. Which of the following registers is used to keep track of address of the memory location where the next instruction is located?

Options: A) Memory address register B) Memory data register C) Instruction register D) Program counter

Ans:D,D


A printed document reader which scans the characters and then encodes them in a computer-compatible code for direct transmission to the computer is called
Options: Optical character reader,    Kurzweil Data Entry Machine (KDEM),    MICR,    Laser scanner

Ans:B,B


. How do you connect internet in your system?
Options: a. My computer >> dialup networking b. Control panel >> modem c. Network neighborhood d. None of above

Ans:3 – a ,3 – a


. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a


Pipelining strategy is called implement
Options: a . instruction execution b . instruction prefetch c . instruction decoding d . instruction manipulation

Ans:5.b,5.b


Business Intelligence (BI) systems do not obtain their data by which of the following means?
Options: Read and process data from an operational database,    Process transactions,    Process extracts from operational databases,    Process data purchased from data vendors

Ans:B ,B


. Which of the following is not a logical database structure?
Options: a. Chain b. Network c. Tree d. Relational

Ans:– a,– a

www.000webhost.com