. Multiple calculations can be made in a single formula using…..


Options: Standard Formulas B. Array Formula C. Complex Formulas D. Smart Formula

Ans: – B ,


Description: mcqquestions






More MS-Excel Related questions:


Which of the following is not currently a topic in computer science?
Options: Speech recognition,    Artificial intelligence,    Thermodynamics,    Multiprocessing

Ans:C,C


Which of the following systems software does the job of merging the records from two files into one?
Options: Security software,    Utility program,    Networking software,    Documentation system

Ans:B ,B


While working with MS-DOS, which command is used to specify the colour display, 40 columns and color?
Options: MODE COLOUR,    MODE/C,    MODE CO40,    MODE CHANGE

Ans:C ,C


. Microsoft Excel is a powerful………..
Options: a. Word processing package b. Spreadsheet package c. Communication S/W Package d. DBMS package

Ans:– b,– b


You have two switches connected together with two crossover cables for redundancy, and STP is disabled. Which of the following will happen between the switches?
Options: The routing tables on the switches will not update.,    The MAC forward/filter table will not update on the switch.,    Broadcast storms will occur on the switched network.,    The switches will automatically load-balance between the two links.

Ans:C ,C


Which of the following printer can be classified as a page-at-a-time printer?
Options: Laser printer,    Dot-matrix printer,    Thermal printer,    Inkjet printer

Ans:A ,A


In magnetic disks, data is organized on the platter in a concentric sets of rings called
Options: sector,    track,    head,    block

Ans:B ,B


If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:
Options:  A) Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box., B) Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect., C) AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry., D) Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.,

Ans:-A,-A


Assume integer is 2 bytes wide. How many bytes will be allocated for the following code? #include<stdio.h> #include<stdlib.h> #define MAXROW 3 #define MAXCOL 4 int main() { int (*p)[MAXCOL]; p = (int (*) [MAXCOL])malloc(MAXROW *sizeof(*p)); return 0; }
Options: 56 bytes,    128 bytes,    24 bytes,    12 bytes

Ans:C ,C


Which of the following system program forgoes the production of object code to generate absolute machine code and load it into the physical main storage location from which it will be executed immediately upon completion of the assembly?
Options: two pass assembler,    load-and-go assembler,    macroprocessor,    compiler

Ans:B ,B


. Which of the following search criteria is invalid?
Options: a. $45* b. *cal* c. D*m?? d. AS150*

Ans:6 – a ,6 – a


The complete information about an entity in a database is called
Options: a. Data b. Information c. Field d. Record

Ans:ndash; d,ndash; d


Repeaters are often used on an 802.3 network to help strengthen the signals being transmitted. As with the length of segments and the number of segments, a limit exists as to how many repeaters can be used between any two nodes. What is the maximum number of repeaters that can be used?
Options: Five,    Two,    Four,    Six

Ans:C ,C


In a worksheet you can select
Options: a. The entire worksheet b. Rows c. Columns d. All of the above

Ans:#8211; b,#8211; b


First generation computers are characterised by
Options: Vaccum tubes and magnetic drum,    Minicomputers,    Magnetic tape and transistors,    All of the above

Ans:A,A


. What is the use of “Hide Slide” option?
Options: a. to hide the selected slides during Presentation b. to hide the selected slides during Editing c. to hide the selected slides during Printing d. to hide the selected slides during Deleting

Ans:8 – A ,8 – A


A front-end processor is
Options: a user computer system,    a processor in a large-scale computer that executes operating system instructions,    a minicomputer that relieves main-frame computers at a computer centre of communications control functions,    preliminary processor of batch jobs.

Ans:C ,C


Which of the following commands is used to rename a file?
Options: rename,    remove,    mv,    ren

Ans:C ,C


The SQL statement to create a view is:
Options: CREATE VIEW.,    MAKE VIEW.,    SELECT VIEW.,    INSERT VIEW.

Ans:A ,A


. 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 co-processor
Options: a. Is relatively easy to support in software b. Causes all processor to function equally c. Works with any application d. Is quite common in modern computer

Ans:a,a


Everything computer does is controlled by its
Options: RAM,    ROM,    CPU,    Storage devices

Ans:C ,C


A _____ Contains fields of data about one entity.
Options: Record,    File,    Fields,    Document

Ans:A ,A


.   The best way to insert a new slide in a presentation is to use the
Options: a. Normal view b. Special view c. Slide show view d. Slide sorter view

Ans:4 – D ,4 – D


A numeric value can be treated as label value if …… precedes it.
Options: Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Tilde (~)

Ans:– A ,


A logical description of some portion of database that is required by a user to perform task is called as
Options: System View B. User View C. Logical View D. Data View

Ans:– B ,


. A transaction completes its execution is said to be
Options: Saved B. Loaded C. Rolled D. Committed

Ans: – D ,


.   Which of the following is not one of PowerPoint’s views?
Options: a. Slide show view b. Slide view c. Presentation view d. Outline view

Ans:7 – C ,7 – C


. The command Edit >> Fill Across Worksheet is active only when
Options: a.  One sheet is selected b.  When many sheets are selected c.  When no sheet is selected d.  None of above

Ans:– b,– b


You suspect that your automatic modem dialer is not working correctly. Which of the following commands will manually dial the number 123-4567?
Options: AT1234567,    ATDT1234567,    AT1234567DL,    ATM 1234567

Ans:B ,B


Which of the following is not an advantage of magnetic disk storage?
Options: The access time of magnetic disk is much less than that of magnetic tape,    Disk storage is longer lasting than magnetic tape,    Disk storage is less expensive than tape storage,   None of the above

Ans:D,None of the above


The Ziegler-Nichols method:
Options: is a graphical solution method,    can be used to determine gain factors of a PI loop,    is a method of control,    a and b above

Ans:D ,D


A system design is said to be functionally modular if
Options: the system is able to handle all the function of the application,    each module performs a specific function and can be developed relatively independently by programmers,    the system makes extensive use of function. keys for maximum user assistance,    the system is developed using structured programming through COBOL or PASCAL

Ans:B ,B


. If you write criteria values vertically (one in a row) it will mean
Options: a. Or conditions b. And conditions c. Not condition d. None of above

Ans:6 – a ,6 – a


The cray X-MP, IBM 3090 and connection machine can he characterized as
Options: SISD,    SIMD,    MISD,    MIMD

Ans:B ,B


A popular technique for forecasting is
Options: correlation analysis,    regression analysis,    linear programming,    Monte Carlo

Ans:B ,B


ENIAC (Electronic Numerical Integrator and Calculator) had huge advantage over Mark I because it used electronic valves in place of the electromagnetic switches. In the beginning, ENIAC was used for calculating the path of artillery shells. For which other was weapon design was it utilized?
Options: hydrogen bomb,    atom bomb,    agnimissile,    fighter aircraft

Ans:A,A


Each data item in a record may be a group item composed of sub-items; those items which are indecomposable are called
Options: a. elementary items b. atoms c. scalars d. all of above  

Ans:d,d


In 1830, Charles Babbage disigned a machine called the Analytical Engine which he showed at the Paris Exhibition. In which year was it exhibited?
Options: 1820,    1860,    1855,    1870

Ans:C ,C


Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit

Ans:D ,D


A system investigation may result from
Options: an analysis investigation,    a scheduled systems reviewed,    a manager's formal request,    All of the above

Ans:D ,D


Which one of the following symbols is not used in an ERD?
Options: Rectangle,    Oval,    Diamond,    Circle

Ans:D ,D


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

Ans:A ,A


A record management system
Options: a. can handle many files of information at a time b. can be used to extract information stored in a computer file c. always uses a list as its model d. both a and b 

Ans:.b,.b


Which of the following is not true about indexes?
Options: Indexes are created to enforce uniqueness on columns.,    Indexes are created to enable fast retrieval by column values.,    Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.,    Indexes are created with the ALTER TABLE command.

Ans:D ,D


Paging
Options: is a method of memory allocation by which the program is subdivided into equal portions, or pages and core is subdivided into equal portions or blocks.,    consists of those addresses that may be generated by a processor during execution of a computation.,    is a method of allocating processor time.,    allows multiple programs to reside in separate areas of core at the time.

Ans:A ,A


Ctrl + C
Options: Copy the selected text B. Cut the selected text C. Print the selected text D. Paste the selected text

Ans:– A ,


The shifting of a program from one of the memory addresses to another is
Options: Data transmission,    Data collection,    Relocation,    Database

Ans:C ,C


A consideration evaluated by management when planning to convert to a computer system is
Options: available software,    vender maintenance,    CPU size and speed,    All of the above

Ans:D ,D


Which command will be used with vi editor to replace text from cursor to right?
Options: r,    R,    s,    S

Ans:B ,B

www.000webhost.com