. 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: 13816 | Level: Moderate


******************************************************

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

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




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




More MS-Excel Related questions:


A database management system
Options: allows simultaneous access to multiple files,    can do more than a record management system,    is a collection of programs for managing data in a single file,    both (a) and (b)

Ans:D ,D


A section of code that may only be executed by one process at any one time is
Options: CPM,    Critical resource,    Critical region,    Gray code

Ans:C ,C


. What PowerPoint feature will you use to apply motion effects to different objects of a slide?
Options: a.  Slide Transition b.  Slide Design c.  Animation Objects d.  Animation Scheme

Ans:3 – D ,3 – D


The fastest read/write time and most efficient data storage of any disk array type is:
Options: RAID-0.,    RAID-1.,    RAID-2.,    RAID-3.

Ans:A ,A


Pipeline implement
Options: A . fetch operand B . calculate operand C . execute instruction D . all of above

Ans:D, all of above


What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register

Ans:B ,B


If your router is facilitating a CSU/DSU, which of the following commands do you need to use to provide the router with a 64000bps serial link?
Options: RouterA(config)#bandwidth 64,    RouterA(config-if)#bandwidth 64000,    RouterA(config-if)#clock rate 64,    RouterA(config-if)#clock rate 64000

Ans:D ,D


Which hole is used to mark the location of the first sector in a soft-sectored disk.
Options: Address,    Location,    Index,    Label

Ans:C ,C


If every non-key attribute is functionally dependent on the primary key, the relation will be in
Options: First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Ans:– C ,


. Which control lets a user create multiple pages in a form?
Options: a. Check box control b. Combo box control c. Option group control d. Tab control

Ans:– d,– d


In cyclic redundancy checking, the divisor is _____ the CRC.
Options: the same size as,    one bit less than,    one bit more than,    two bits more

Ans:C ,C


You are unsuccessful in telnetting into a remote device. What could the problem be? IP addresses are incorrect. Access control list is filtering Telnet. There is a defective serial cable. The VTY password is missing.
Options: 1 only,    3 only,    2 and 4 only,    All of the above

Ans:C ,C


. What do you call a collection of records matching parameters of a query?
Options: a. Field b. Record c. Query d. Dynaset

Ans:– d,– d


. An operating system is a program or a group of programs that
Options: a. Helps in checking the spelling of Word b. Maintain the relationship in Database c. Manages the resources of the Computer d. Performs the calculations of cells in Excel

Ans:2 – c ,2 – c


A semi-continuous operation means:
Options: the operation is continuous each shift, but stops between shifts,    coffee breaks are allowed for the operator,    a computer is a required part of the machine,    each operation in a sequence is continuous, but subsequent operations in the sequence may be different.

Ans:D ,D


The operating system creates _____ from the physical computer
Options: Virtual space B. Virtual computers      C. Virtual device D. None

Ans:– B ,


Which of the following is not true about documentation?
Options: Documentation, of a system, should be as clear and direct as possible,    Documentation increases the maintenance time and cost,    Documentation gives better understanding of the problem,    All of the above

Ans:B ,B


In what file can you specify which users are not allowed to access a system via FTP?
Options: /etc/ftpusers,    /etc/hosts.deny,    /etc/ftpaccess,    All of the above

Ans:A ,A


Changing the appearance of a document is called
Options:  A) Proofing, B) Editing, C) Formatting, D) All of above, 

Ans:-C,-C


. ABC is a
Options: A) Special purpose computer B) General purpose computer C) All Purpose Computer D) None of above

Ans:A,A


________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Options: ASP,    XML,    ODBC,    ADO

Ans:D ,D


.   Microsoft PowerPoint is a
Options: a. Database program b. Spreadsheet program c. Presentation program d. Word processing program

Ans:7 – C ,7 – C


Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options: SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');,    SELECT NAME IN CUSTOMER WHERE STATE = 'VA';,    SELECT NAME IN CUSTOMER WHERE STATE = 'V';,    SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Ans:D ,D


Monte Carlo is an example of a(n)
Options: static model,    deterministic model,    optimizing model,    All of the above

Ans:D ,D


. The command refreshes the screen and places the cursor at the top left corner of screen
Options: a. CLS b. Clear c. Dir d. CHKDSK

Ans:3 – a ,3 – a


The three dimensions of system integrity do not include
Options: accuracy,    completeness,    security,    appropriateness

Ans:B ,B


In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of register?
Options: absolute mode,    indirect mode,    immediate mode,    index mode

Ans:D ,D


The CPU chip used in a computer is partially made out of:
Options: Copper,    Iron,    Gold and silver,    Silica

Ans:D ,D


An entity type is which of the following?
Options: A major category of data about people, place, and things,    The various departments of an organization,    The application software,    The business processes the support the mission of an organization

Ans:A ,A


. A characteristic of card systems is:
Options: A) Slowness in processing data B) Using cards as records of transactions C) Needing a larger DP staff D) All of the above

Ans:D,D


. Which function can not be used for calculated controls in a report?
Options: a. SUM b. AVG c. MPT d. COUNT

Ans:– c,– c


How many non-overlapping channels are available with 802.11a?
Options: 3,    12,    23,    40

Ans:B ,B


What command is used to reset a MODEM when using the
Options: ATR,    ATZ,    DTR,    DCE

Ans:B ,B


Flood guns bombard the phosphor surface of the tube in which one of the following types of CRT technology?
Options: Direct view storage tube,    Raster scan CRT,    Refresh-vector CRT,    Stroke CRT

Ans:A ,A


Which of the following is a machine language instruction?
Options: ADD 5,    10001101,    GOTO XOUT,    All of the above

Ans:B ,B


An econometric model requires
Options: a computer with large auxiliary storage capacity,    a data base of economic data,    a model base of quantitative analysis programs,    All of the above

Ans:D ,D


How much current flows through a 60-W light bulb that is operating at 120 V?
Options: 0.5A,    180 A,    2 A,    7200 A

Ans:A ,A


What is the shortcut key for “Font ” dialog box?
Options: Ctrl + F B. Ctrl + D C. Ctrl + G D. None of the above

Ans:– B ,


The Internet Control Message Protocol (ICMP)
Options: allows gateways to send error a control messages to other gateways or hosts,    provides communication between the Internet Protocol Software on one machine and the Internet Protocol Software on another,    reports error conditions to the original source, the source must relate errors to individual application programs and take action to correct the problem,    All of the above

Ans:D ,D


The advantage of a command processor running only built-in commands is:
Options: flexibility to the users in running lists of commands by simply collecting them in named batch command files,    the command set being common across different hardware configurations,    users can create system programs and run them as commands,    the processing is much faster than would other-wise be the case when user defined commands are used

Ans:B ,B


. 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 key is used to select all the text in the document?
Options: Ctrl+T B. Ctrl+A C. Ctrl+F D. Ctrl+N

Ans:– B ,


What command is used with vi editor to move forward to the end of a word?
Options: c,    d,    b,    e

Ans:D ,D


. Who built the first Mechanical Calculator
Options: Joseph Marie Jacquard B. John Mauchly C. Blaise Pascal D. Howard Aiken

Ans: – C ,


.   You edit an embedded table object by
Options: a. Clicking the edit sub command of the document object command on the edit menu b. Double clicking the table object c. Right clicking the table object, then clicking edit document on the edit menu d. All of above

Ans:1 – D ,1 – D


The active cell:
Options: is defined by a bold border around the cell. B. Receives the data the user enters. C. It is the formula bar. D. Only A and B.

Ans:– D ,


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 which of the following is a single-entity instance of one type related to many entity instances of another type?
Options: One-to-One Relationship,    One-to-Many Relationship,    Many-to-Many Relationship,    Composite Relationship

Ans:B ,B


. Registers which are partially visible to users and used to hold conditional codes (bits set by the CPU hardware as the result of operations), are known as
Options: A) PC B) Flags C) Memory Address Registers D) General Purpose Registers

Ans:B,B


. Which of the following will not set text in selected cells to italics?
Options: a. Pressing Ctrl + I on the keyboard b. Using the Tools – Wizard – Web Form menu item c. Using the Format – Cells – Font menu item d. None of the above

Ans:– b,– b

www.000webhost.com