In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?


Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,






More MS-Excel Related questions:


. Charles Babbage was awarded by Royal Society for his
Options: A) Difference Engine B) Analytic Engine C) Binary System in Analytic Engine D) His concept of input, mill, output and storage

Ans:A,A


Conversion of binary number 1010101000010111 to hexadecimal number is
Options: D8F916,    A8B916,    AA1716,    D9F816

Ans:C ,C


Which of the following is a voiceband channel?
Options: Telephone line,    Telegraph line,    Coaxial cable,    Microwave systems

Ans:A ,A


. We can start the application from?
Options: a. Log off b. Network place c. Recycle bin d. Run

Ans:2 – d ,2 – d


A computer system consisting of its processor, memory and I/O devices accepts data, processes it and produces the output results. Can you tell in which component is the raw data fed?
Options: Mass Memory,    Main memory,    Logic unit,    Arithmetic unit

Ans:B ,B


. Any files deleted in Windows goes into
Options: a. Trash can b. Recycle bin c. Deleted Files d. None of above

Ans:2 – b ,2 – b


. The notable features like keyboards, monitors, GUI were developed in
Options: A) First generation B) Second generation C) Third generation D) Fourth generation

Ans:C,C


Conversion of an octal number 1428 to binary number is
Options: 11000102,    1101102,    11000112,    11011012

Ans:A ,A


What is the output of the program in Turbo C (in DOS 16-bit OS)? #include<stdio.h> int main() { char *s1; char far *s2; char huge *s3; printf("%d, %d, %d\n", sizeof(s1), sizeof(s2), sizeof(s3)); return 0; }
Options: 2, 4, 6,    4, 4, 2,    2, 4, 4,    2, 2, 2

Ans:C ,C


Which of the following is used as "Input device" for the computer?
Options: Printer,    VDU,    TV,    Light pen

Ans:D ,D


The minimum number of MOS transistors required to make a dynamic RAM cell is
Options: 1,    2,    3,    4

Ans:A ,A


. Number crunchier is the informal name for
Options: A) Mini computer B) Super computer C) Microcomputer D) Mainframe computer

Ans:b,b


A common reason for changing an information system is
Options: new requirements,    new technology,    problems in the existing system,    All of the above

Ans:D ,D


. Memory unit is one part of
Options: A) Input device B) Control unit C) Output device D) Central Processing Unit

Ans:0-D,0-D


The complexity of Bubble sort algorithm is
Options: a. O(n) b. O(log n) c. O(n2) d. O(n log n)  

Ans:c,c


What should he used to extinguish a computer fire?
Options: fire hose,    class a extinguisher,    class c extinguisher,    silver foam water

Ans:C ,C


Which of the following is the default page setup orientation of slide in PowerPoint
Options: a. Vertical b. Landscape c. Portrait d. None of above

Ans: – B , – B


The SQL statement that queries or reads data from a table is ________ .
Options: SELECT,    READ,    QUERY,    None of the above is correct.

Ans:A ,A


Which of the following professions has not been affected by personal computers?
Options: medical,    clerical,    accounting,    law

Ans:E ,E


What will be the output of the program #include<stdio.h> void fun(int); int main(int argc) { printf("%d ", argc); fun(argc); return 0; } void fun(int i) { if(i!=4) main(++i); }
Options: 1 2 3,    1 2 3 4,    2 3 4,    1

Ans:B ,B


15. Which command in DOS is used to display the version of MSDOS?
Options: a. VERSION b. VERIFY c. VER d. VERSN

Ans:Correct Answer: c ,Correct Answer: c


The Personal Consultant is based on:
Options: EMYCIN,    OPS5+,    XCON,    All of the above

Ans:D ,D


The integrated circuit:
Options: often is called a "chip",    led to the development of the transistor,    has revolutionized electronics,    (b) and (c)

Ans:D ,D


. Ctrl + M
Options: New Document B. Close Document C. Right Indent D. Left Indent

Ans:– D ,


. Which is built directly on the hardware?
Options: a. Computer Environment b. Application Software c. Operating System d. Database System

Ans:0 – c ,0 – c


The institute for Certification of Computer Professionals (ICCP) currently administers the Certificate in Computer Programming (CCP) and the _____ examinations.
Options: CDP,    CISA,    DPMA,    ACM

Ans:A ,A


. When using the MLA style, position explanatory notes either at the _____.
Options: a. top of the page as head notes or at the end of the paper as endnotes b. bottom of the page as footnotes or at the end of the paper as endnotes c. top of the page as head notes or at the beginning of the paper as front notes d. bottom of the page as footnotes or at the beginning of the paper as front notes

Ans: – B , – B


When measuring AC (Alternating Current) with a multimeter, it is important to maintain the proper polarity.
Options: true,    false,    true,    false

Ans:B ,B


Which command is used with vi editor scroll half page backward?
Options: [Control-d],    [Control - u],    [Control-c],    [Control -P]

Ans:B ,B


A machine associated with card-based data processing is
Options: Codomain,    Collator,    Cartridge,    Digitizer

Ans:B ,B


. Getting data from a cell located in a different sheet is called….
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:– b,– b


Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
Options: Both TCP and IP are needed.,    TCP is needed but IP is not needed.,    TCP is not needed but IP is needed.,    Neither TCP and IP are needed.

Ans:A ,A


.  Power Point can display data from which of the following add-in software of MS Office?
Options: Equation Editor B. Organization Chart C. Photo Album D. All of these

Ans: – D ,


84. Which feature do you use to create a newspaper like document?
Options: a. Bullets & numbering b. Tables c. Columns d. Tab stops

Ans:–  C ,–  C


Which command is used to delete all files in the current directory as well as all files and sub-directories in its subdirectories?
Options: rm *,    rm -r *,    rm all,    rm *.*

Ans:B ,B


User-Friendly Systems are:
Options: required for object-oriented programming,    easy to develop,    common among traditional mainframe operating systems,    becoming more common

Ans:D ,D


Who is the creator of the PASCAL language?
Options: Niklaus Wirth,    Dijkstra,    Donald Knuth,    Basic Pascal

Ans:A ,A


An important first step in troubleshooting which component in a laser printer is causing a jam is to:
Options: note where in the paper path the paper stops,    check all voltages,    look up error codes,    turn the printer off, then on again

Ans:A ,A


The details of all external symbols and relocation formation (relocation list or map) is provided to linker by
Options: Macro processor,    Translator,    Loader,    Editor

Ans:B ,B


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


Four routers have to be interconnected in a point-to-point Network. Each pair of root us may connected by a high-speed line, a medium speed line or a low speed line. Find the total number of topologies.
Options: 12,    81,    48,    729

Ans:D ,D


During the planning phase, the main activity of the vice-president of information systems is one of
Options: planning,    control,    staffing,    support

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


. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Options: a. Go to File-Save As – Save As Type – Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert – Entire Column d. None of above

Ans:– b,– b


. What is the extension of paint brush?
Options: a. .pbs b. .bmp c. .pmb d. None of the above

Ans:0 – b ,0 – b


Which part of the diskette should never be touched?
Options: Hub,    Centre,    Oval slot,    Corner

Ans:C ,C


. WAN stands for
Options: A) Wap Area Network B) Wide Area Network C) Wide Array Net D) Wireless Area Network

Ans:5-B,5-B


. FORTRAN programming language is more suitable for ____
Options: A) Business Applications B) Marketing Applications C) Scientific Applications D) None of the above

Ans:C,C


. Which of the following is true regarding page Orientation of a Document?
Options: a. Page Orientation can be change at any time b. Page Orientation of document determines by printer c. Page Orientation must be set before start typing d. Page Orientation of a document cannot be changed.

Ans:–  A,–  A


Which of the following expresses correct order?
Options: a. Characters, Fields, Records, Tables, Files, Databases b. Characters, Fields, Records, Tables, Database, Files c. Databases, Tables, Files, Records, Field, Character d. Files, Databases, Tables, Records, Fields, Characters

Ans:ndash; a,ndash; a

www.000webhost.com