Which of the following is correct?


Options: =AVERAGE(4, 5, 6, 7) B. =AVERAGE(A1, B1, C1)               C. =AVERAGE(A1:A9, B1:B9) D. =All of the above

Ans:– D ,


Description: mcqquestions






More MS-Excel Related questions:


. Which of the following concept is best to preventing page faults?
Options: a. Paging b. The working set c. Hit ratios d. Address location resolution

Ans:8 – b ,8 – b


97. What is the shortcut key for “Find and Replace” dialog box?
Options: a. Ctrl + F b. Ctrl + R c. Ctrl + H d. Ctrl + Shift + F

Ans:–  C ,–  C


. Which programming languages are classified as low level languages?
Options: A) Basic, COBOL, FORTRAN B) Prolog 2, Expert Systems C) Knowledge based Systems D) Assembly Languages

Ans:D,D


Prior to the invention of time sharing, the prevalent method of computer access was:
Options: batch processing,    telecommunication,    remote access,    All of the above

Ans:A ,A


Which enables us to send the same letter to different persons?
Options: A. macros B. template C. mail merge D. none

Ans:C,mail merge


The basic components of a modern digital computer are :
Options: Input device,    Output device,    Central processor,    All of the above

Ans:D ,D


Which algebra is widely used in DBMS?
Options: a. Relational algebra b. Arithmetic algebra c. Both d. None

Ans:– a ,


. IBM 1401 is
Options: A) First Generation Computer B) Second Generation Computer C) Third Generation Computer D) Fourth Generation Computer

Ans:B,B


Microprocessors as switching devices are for which generation computers
Options: A) First Generation B) Second Generation C) Third Generation D) Fourth Generation

Ans:D,D


A 32 bit microprocessor has the word length equal to
Options: 2 bytes,    32 bytes,    4 bytes,    8 bytes

Ans:C,C


What does Router do in a network?
Options: Forwards a packet to all outgoing links B. Forwards a packet to the next free outgoing link C. Determines on which outing link a packet is to be forwarded D. Forwards a packet to all outgoing links except the originated link

Ans:– C ,


The process of writing computer instructions in a programming language is known as
Options: Coding,    Processing,    Programming,    File

Ans:A ,A


Which device is used as the standard pointing device in a Graphical User Environment?
Options:  Keyboard B.  Mouse C.  Joystick D.  Track ball

Ans:– B ,


Which is the easiest component to environmentally recycle?
Options: Motherboards,    CMOS batteries,    Toner cartridges,    Cathode ray tubes

Ans:C ,C


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    All of the above

Ans:E ,E


The total capacitance of a series capacitor circuit is:
Options: equal to the sun of the individual capacitive-reactance values,    equal to the sum of the individual capacitance values,    equal to the source voltage divided by total current,    less than the value of the smallest capacitor

Ans:D ,D


Which is used for manufacturing chips?
Options: A) Bus B) Control unit C) Semiconductors D) A and b only

Ans:-C,-C


Using ODL, you can define which of the following?
Options: Attribute,    Structure,    Operation,    All of the above.

Ans:D ,D


Which key do you press to check spelling?
Options: F3 B. F5 C. F7 D. F9

Ans:– C ,


. Dedicated Computer is A
Options: Computer having multiple Monitors B. Computer assigned one task at a time C. Computer having multiple Operating Systems D. Computer is designed to use by single person

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 auto calculate feature
Options: a. Can only add values in a range of cells b. Provides a quick way to view the result of an arithmetic operation on a range of cells c. Automatically creates formulas and adds them to a worksheet d. A and c

Ans:#8211; b,#8211; b


What will be the output of the program? #include<stdio.h> #define FUN(i, j) i##j int main() { int va1=10; int va12=20; printf("%d\n", FUN(va1, 2)); return 0; }
Options: 10,    20,    1020,    12

Ans:B ,B


Long-range planning report produced in an MIS are primarily designed for
Options: top management,    middle management,    lower management,    All of the above

Ans:A ,A


Which is not the function of “Edit, Clear” command?
Options: a. Delete contents, B. Delete notes, C. Delete cells, D. Delete formats

Ans:C ,Delete cells


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


The errors that can be pointed out by the compiler are
Options: Syntax errors,    Semantic errors,    Logical errors,    Internal errors

Ans:A ,A


. Which one is notoperating system?
Options: a. P11 b. OS/2 c. Windows d. Unix

Ans: a, a


Unlike text data type, this can store up to maximum of 65, 535 characters.
Options: a. memo b. data/time c. number d. All of above

Ans:ndash; a,ndash; a


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B,B


The number of management layers in a firm is determined by
Options: the scalar principle,    the span of control,    the degree of unity in the command,    the number of managers in the firm

Ans:B ,B


Which file starts MS Word?
Options: a. winword.exe b. word.exe c. msword.exe d. word2003.exe

Ans:– A,– A


.   Slide show options available to the presenter include all of the following except
Options: a. Transitions command b. Speaker notes command c. Meeting minder command d. Navigation commands

Ans:4 – A ,4 – A


The first generation of computers available was based on the bit micro processors.
Options: 4,    8,    16,    64

Ans:B,(Banswer


The major function of the language system is:
Options: to perform various processing tasks,    to provide artificial-intelligence capabilities to the DSS,    to provide data to the DSS,    to enable the users to interact with the DSS

Ans:D ,D


Which of the following commands is used to count the total number of lines, words, and characters contained in a file.
Options: count p,    wc,    wcount,    countw

Ans:B ,B


The component that forms the electrical connection between the rotating coil of wire in a motor and the external source of electrical energy is called the:
Options: rotor,    armature,    battery,    commutator

Ans:D ,D


A rectangle represents which of the following in an ERD?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:B ,B


75. When inserting Page number in footer it appeared 1 but you wish to show
Options: a. How can you do that?

Ans:– C ,– C


Logical models form the basis for computing systems that generate information useful in dealing with
Options: dynamic situations,    uncertain situations,    complex situations,    All of the above

Ans:D ,D


A bidirectional feedback loop links computer modelling with:
Options: artificial science,    heuristic processing,    human intelligence,    cognitive science

Ans:D ,D


Which of the following input/output devices is not associated with personal computers?
Options: mice,    color monitors,    punched cards,    dot-matrix printers

Ans:C ,C


When not in use, it is very important to keep 5 1/4 diskettes in _____.
Options: Their protective sleeves,    In a plastic bag,    On a shelf in an upright position,    In the floppy drive

Ans:A ,A


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

Ans:C ,C


. An online backing storage system capable of storing larger quantities of data is
Options: A) CPU B) Memory C) Mass storage D) Secondary storage

Ans:C,C


A double sided magnetic disk pack has six disks. Can you tell how many surfaces of this pack are normally used?
Options: 10,    12,    6,    9

Ans:A,A


Using Find command in Word, we can search?
Options: characters B. formats C. symbols D. All of the above

Ans:– D ,


12. While working with MS-DOS which command is used to copy all files with extension .txt into one file named all.txt?
Options: a. Copy a: *.txt b. Copy *.txt a: c. Copy *.txt c: d. Copy *.txt all.txt

Ans:Correct Answer: d,Correct Answer: d


. Validation Rule in a field will
Options: a. Checks the value entered when user leaves the field b. Displays the value in specified format when user leaves the field c. Defines the appearance for the text d. There is no option of Validation Rule

Ans:– a,– a


Which operation you will perform if you need to move a block of text?
Options: a. Copy and Paste b. Cut and Paste c. Paste and Delete d. Paste and Cut

Ans:– B,– B

www.000webhost.com