. Which of the following syntax is correct regarding to SUM function in Excel?


Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 10244 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


. A factor which would strongly influence a business person to adopt a computer is its

Options: A) Accuracy B) Reliability C) Speed D) All of above

Ans:D,D


. An application that executes on separate PCs like this is called a(n) __________ application.
Options: a. enterprise b. distributed c. tier d. global

Ans:6 – b ,6 – b


The term "remote job entry" relates to
Options: batch processing,    realtime processing,    transaction processing,    distributed processing

Ans:A ,A


What is the general name of the device which produces hardcopy graphics?
Options: COM,    Plotter,    Printer,    Microfilm

Ans:B ,B


A high quality CAD system uses the following for printing drawing and graphs
Options: Dot matrix printer,    Digital plotter,    Line printer,    All of the above

Ans:B ,B


The _____ command allows you to modify the default prompt to provide other information
Options: prompt,    windows,    cursor,    click

Ans:A ,A


Which command is used to list out all the hidden files along with the other files?
Options: ls -l,    ls -x,    ls -F,    ls -a

Ans:D ,D


A _____ is simply an arrangement where multiple disk drives appear as a single disk drive to the user.
Options: disk,    disk array,    bunch of disks,    disk pack

Ans:B,B


The marketing authority contributing the most to a definition of a structure for the marketing information system is
Options: Philip Vegas,    F.A. Fisher,    Philip Kotler,    Roger McSack

Ans:C ,C


Data items grouped together for storage purposes are called a
Options: record,    title,    list,    string

Ans:A ,A


Which one of the following kinds of materials has the highest permeability?
Options: A diamagnetic material,    A ferromagnetic material,    A paramagnetic material,    All of the above

Ans:B ,B


What is the main advantage of magnetic core memory over semiconductor RAM memory?
Options: more compact and smaller,    more economical,    a bit does not have to write after reading,    non volatile

Ans:D,D


55. A feature of MS Word that saves the document automatically after certain interval is available on
Options: a. Save tab on Options dialog box b. Save As dialog box c. Both of above d. None of above

Ans:– A ,– A


The register or main memory location which contains the effective address of the operand is known as
Options: pointer,    indexed register,    special location,    scratch pad

Ans:A ,A


Which command is used to determine if an IP access list is enabled on a particular interface?
Options: show access-lists,    show interface,    show ip interface,    show interface access-lists

Ans:C ,C


Which of the following memory unit that processor can access more rapidly
Options:  Main Memory B.  Virtual Memory C.  Cache memory D.  Read Only Memory

Ans:– C ,


The subsystem appearing in each of the functional information systems is the
Options: internal accounting subsystem,    environmental intelligence subsystem,    information processor subsystem,    system analysis subsystem

Ans:A ,A


Which of the following are layers in the TCP/IP model? Application Session Transport Internet Data Link Physical
Options: 1 and 2,    1, 3 and 4,    2, 3 and 5,    3, 4 and 5

Ans:B ,B


Sending a file from your personal computer's primary memory or disk to another computer is called
Options: uploading,    downloading,    logging on,    hang on

Ans:A ,A


. Which command will be used to display only the file name and extensions in wide format?
Options: a. Dir/b b. Dir A: c. Dir/s d. Dir/w

Ans:8 – d ,8 – d


Which of the following TCP/IP protocol is used for transferring files from one machine to another?
Options: RARP,    ARP,    TCP,    FTP

Ans:D ,D


To test for AC ripple on a PC power supply, you would set the volt/ohm meter for:
Options: DC voltage scale,    AC voltage,    OHM scale,    Farad scale

Ans:B ,B


. Floppy disks which are made from flexible plastic material are also called?
Options: A) Hard disks B) High-density disks C) Diskettes D) Templates

Ans:C,C


A regular subquery can be processed:
Options: from the top down.,    from the bottom up.,    by nesting.,    None of the above is correct.

Ans:B ,B


To enable EIGRP, which of the following would you use? Router1(config-if)# ipv6 ospf 10 area 0.0.0.0 Router1(config-if)# ipv6 router rip 1 Router1(config)# ipv6 router eigrp 10 Router1(config-rtr)# no shutdown Router1(config-if)# ipv6 eigrp 10
Options: 1, 3 and 5,    3, 4 and 5,    1 and 3,    5 only

Ans:B ,B


Which of the following commands is used to remove files with confirmation prompt from the user file system which have neither been accessed nor modified i the last one year?
Options: find -mtime +365 | rm,    grep (/usr/*) - mtime + 365 | -ok rm,    find -name - mtime + 365 / - ok rm,    find /user/* \(-mtime + 365 - a - atime +365 \) - OK rm {} \;

Ans:D ,D


Which are the most important features of Microsoft Windows program?
Options: Windows,    Pull-down menus,    Icons,    All of the above

Ans:D ,D


A cursor type in which the application can only move forward through the recordset is called:
Options: forward only.,    static.,    keyset.,    dynamic.

Ans:A ,A


What is the maximum number of lines you can set for lines to drop box?
Options:  A) 3, B) 5, C) 10, D) 15, 

Ans:-C,-C


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

Ans:B ,B


Which of the following can be Software?
Options: Routers B. Firewalls C. Gateway D. Modems

Ans:– B ,


. In Microsoft windows, the graphical pattern on the desktop used as background for windows is
Options: a. Icons b. Wall paper c. Picture d. Background

Ans:0 – b ,0 – b


A processing unit that coordinates networks and data communication is known as
Options: Control unit,    Communications processor,    Register unit,    CPU

Ans:B ,B


. For what Antikyathera was used?
Options: A) For counting B) For Calculating tax collection C) For calculating astronomical positions D) For calculating firing weapons

Ans:9-C,9-C


29. What is a Document Outline View?
Options: a. A preview in a full screen b. A preview with margins c. A View with a margins and gutter d. A view with a structure of heading at various levels

Ans:–  D ,–  D


. RATS stand for
Options: A) Regression Analysis Time Series B) Regression Analysis Time Sharing C) Real Analysis Series D) All of above

Ans:A,A


. PowerPoint presentations are widely used as
Options: a.  Note outlines for teachers b.  Project presentations by students c.  Communication of planning d.  All of above

Ans:3 – D ,3 – D


What is meant by computer literacy?
Options: Knowing what a computer can and cannot do,    Ability to write computer programs,    Knowing computer related vocabulary,    Ability to assemble computers

Ans:A ,A


What is the name of the computer which was first used for programming and playing of music?
Options: ELLIAC,    ENIAC,    UNIVAC,    All of the above

Ans:A ,A


Which of the following enables you to paste data multiple times?
Options: Windows Clipboard B. Office Clipboard C. Both Windows & Office Clipboard D. None of the all

Ans:– C ,


A common boundary between two systems is called
Options: Interdiction,    Interface,    Surface,    None of the above

Ans:B ,B


When a disk stack is serviced by a comb-like access mechanism, there is one read/write head for each
Options: disk,    disk surface,    track,    cylinder

Ans:B ,B


What is place to the left of horizontal scroll bar?
Options:  , A) Tab stop buttons, B) View buttons, C) Split buttons, D) Indicators

Ans:-B,-B


What is the default left margin in Word 2003 document?
Options:  A) 1", B) 1.25", C) 1.5", D) 2", 

Ans:-B,-B


Which of the following data structures are indexed structures?
Options: a. linear arrays b. linked lists c. both of above d. none of above  

Ans:a,a


. How can you stop a slide show?
Options: a. Press the right arrow b. Press Escape c. Press the left arrow d. Press the down arrow

Ans:7 – B ,7 – B


94. What is the shortcut key for Spelling Check in document?
Options: a. F7 b. Shift + F7 c. Ctrl + F7 d. Alt + F7

Ans:–  A ,–  A


The EIA-232 interface has _____ pins.
Options: 20,    24,    25,    30

Ans:C ,C


. Driver is
Options: a. Hardware controller b. Hardware and gain controller c. Data controller d. All of above

Ans:9 – a ,9 – a


______________ is a classical approach to database design?
Options: Left – Right approach B. Right – Left approach C. Top – Down approach D. Bottom – Up approach

Ans:– C ,

www.000webhost.com