Which of the following function will return a value of 8?


Options: ROUNDUP(8.4999, 0) B. ROUNDDOWN(8.4999, 0) C. ROUND(8.4999, 0) D. Only B and C

Ans:– D ,


Description: mcqquestions

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

Hits Today: 19204 | 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 small button with three dots usually displayed at the right of field properties box
Options: a. Make button b. Expression button c. Build button d. None of above

Ans:ndash; c,ndash; c


The batch file uses the extension
Options: a. BAT b.DOC c..PRG d. .DOS

Ans:11 a       ,11 a      


Which one of the following phrases most accurately describes a purely inductive circuit?
Options: Resistances provide the only opposition to current flow,    Inductive reactance provides the only opposition to current flow,    Combinations of resistance and inductive reactance provide any opposition to current flow,    The ac voltage lags the current by 90 degree

Ans:B ,B


One byte can be used to encode any integer between 'O' and -inclusive
Options: 16,    256,    128,    255

Ans:D,D


Hungarian Method is a way of solving Operations Research problems in:
Options: Linear Programming by Graphical Method,    Simplex Method,    Assignment Method,    Transportation Method

Ans:C ,C


Which of the following is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,


Which of the following devices would be classified as a robot by the Robot Institute of America?
Options: Automobile,    Pick-and-place manipulator,    Artificial hand,    All of the above

Ans:B ,B


. A ....is a flash memory storage device that plugins into a USB port
Options: a. USB snapdrive b. USB flashdrive c. USB memory makerdrive d. None of above

Ans: b, b


What is the maximum number of entries in the HOSTS file?
Options: 8,    255,    500,    Unlimited

Ans:D ,D


21. Which command is used to undelete delete a bunch of files with extension doc that you have just deleted
Options: a. Undelete b. Undelete *.doc c. Undelete/all d. All of the above

Ans:Correct Answer: b ,Correct Answer: b


. The modern keyboard typically has __________ Function keys.
Options: a. 10 b. 12 c. 14 d. 16

Ans:8 – b ,8 – b


A circuit which can store information is known as
Options: Integrated circuit,    Chip,    Memory cell,    Gate

Ans:C ,C


. Animation Schemes can be applied to ________ in the presentation.
Options: a. All slides b. Select slides c. Current Slide d. All of the above

Ans:6 – D ,6 – D


To verify that the note text is positioned correctly on the page, switch to _____ view or display the document in print preview.
Options: a. normal b. print layout c. page layout d. page edit

Ans:– B,– B


Which of the following capabilities is required for a system program to execute more than one program at a time?
Options: word processing,    compiling,    virtual memory,    multitasking

Ans:D ,D


. In MS Access “Hyperlink” Data Type can store
Options: a. Web Address b. email Address c. Path of a File d. All of Above

Ans:– d,– d


Which command will create a dynamic pool named Todd that will provide you with 30 global addresses?
Options: ip nat pool Todd 171.16.10.65 171.16.10.94 net 255.255.255.240,    ip nat pool Todd 171.16.10.65 171.16.10.94 net 255.255.255.224,    ip nat pool todd 171.16.10.65 171.16.10.94 net 255.255.255.224,    ip nat pool Todd 171.16.10.1 171.16.10.254 net 255.255.255.0

Ans:B ,B


. Columns dialog box can be opened from
Options: a. Format menu Columns submenu b. Double click on column space in ruler c. Press Alt + O + C d. All of above

Ans:– D,– D


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 two classification of inputs are:
Options: energies and maintenance,    products and waste,    maintenance and waste,    maintenance and signal

Ans:D ,D


If the values of a variable in one module is indirectly changed by another module, this situation is called
Options: A)internal change b.inter-module change c.side effect d.side-module update

Ans:C,Side effect


"User friendly" computers have ensured that
Options: management requires no system analysis and design.,    programmers are no longer needed,    structured programming is not needed,    All of the above

Ans:E ,E


Ctrl + E
Options: Exit Application B. Select All C. Clear All D. Align Center

Ans:– D ,


Changing oil in an automobile is an example of
Options: preventative maintenance,    scheduled maintenance,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Which of the following specifies the network address and host address of the computer?
Options: The IP address,    The TCP address,    The subnet mask,    The default gateway

Ans:A ,A


A CASE SQL statement is which of the following?
Options: A way to establish an IF-THEN-ELSE in SQL.,    A way to establish a loop in SQL.,    A way to establish a data definition in SQL.,    All of the above.

Ans:A ,A


Which one of the following statements is true for current flowing in a series circuit?
Options: The amount of current flow through each part of a series circuit can be different, depending on the resistance of each part and the amount of voltage applied to it,    The total current in a series circuit is equal to the sum of the currents flowing through the individual components in the circuit,    The same current flows through every part of a series circuit,    The total current in a series circuit is equal to the total voltage multiplied by the total resistance

Ans:C ,C


The outstanding Invoice file should be stared on a Pardon Access Storage Device if
Options: invoice data entry is on-line.,    payment recording is done in a batch rode,    inquires concerning payable are to be answered on-line,    last record points to the first record

Ans:C ,C


Which of the following conditions is used to transmit two packets over a medium at the same time?
Options: Contention,    Collision,    Synchronous,    Asynchronous

Ans:B ,B


Concatenation of text can be done using
Options: a. Apostrophe ,b. Exclamation, c. Hash , d. Ampersand

Ans:d,Ampersand


How many copies of a JSP page can be in memory at a time?
Options: One,    Two,    Three,    Unlimited

Ans:A ,A


Inventory lead time can be broken into:
Options: review, order, manufacturing or purchasing and receiving,    order, manufacturing or purchasing, and receiving,    order, receiving,    All of the above

Ans:A ,A


  Microsoft PowerPoint can insert objects from the following add-ins? A.  Equation Editor B.  Organization Chart C.  Photo Album D.  All of these
Options:

Ans: – D ,


. The earliest calculating devices are
Options: A) Abacus B) Clock C) Difference Engine D) None of these

Ans:A,A


. This task pane shows the design that is currently being used in a presentation.
Options: a. Slide Show b. Slide Style c. Slide Design d. Slide Format

Ans:8 – C ,8 – C


Current is
Options: The flow of charged particles through a material,    An imbalance of electrical charges,    The force that causes electrons to flow,    The number of free electrons in an atom

Ans:A ,A


. The control unit of a microprocessor
Options: A) Stores data in the memory B) Accepts input data from keyboard C) Performs arithmetic/logic function D) None of above

Ans:D,D


14. With Word’s AutoCorrect entries, to display an indifferent face ( 😐 ) type _____.
Options: a.  : ) b.  : ( c.  : | d.  : /

Ans:– C ,– C


A subtype entity name should be which of the following?
Options: A singular noun,    Specific to the organization,    Concise,    All of the above

Ans:D ,D


What was the name of the Japanese worker who was killed by an industrial robot at the Akashi plant of Kawasaki Heavy Industries in Japan?
Options: M. Shubhagya,    Harun Shimada,    Kenji Urada,    K. Miceni

Ans:C ,C


How many DMA channels are in an AT-machine?
Options: 3,    4,    7,    8

Ans:B ,B


Which of the following protocols are used to configure trunking on a switch? VLAN Trunk Protocol VLAN 802.1Q ISL
Options: 1 only,    3 only,    3 and 4,    1, 3 and 4

Ans:C ,C


A DBMS that combines a DBMS and an application generator is ________ .
Options: Microsoft's SQL Server,    Microsoft's Access,    IBM's DB2,    Oracle Corporation's Oracle

Ans:B ,B


DCL provides commands to perform actions like
Options: a. Change the structure of tables b. insert, update or delete records and data values c. authorizing access and other control over database d. None of above

Ans:ndash; c,ndash; c


The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B ,B


. Which of the following is related to fifth generation computers?

Options: A) Knowledge information processing system B) Very large scale integration (VLSI) C) Both of above D) Only b

Ans:A,A


Holes are the minority carriers in which type of semiconductor?
Options: Extrinsic,    Intrinsic,    n-type,    p-type

Ans:C ,C


63. How to use Format Painter multiple times
Options: a. By Click on Lock Format Painter Icon b. By Double Click on the Format Painter Icon c. By Selecting Edit -> Format Painter -> Multiple Use d. Format Painter cannot be use multiple times

Ans:–  B ,–  B


Which is not a view to display a table in Access?
Options: a. Datasheet View b. Design View c. Pivot Table & Pivot Chart View d. None of above

Ans:ndash; d,ndash; d


In which way(s) can a macro processor for assembly language be implemented?
Options: independent two-pass processor,    independent one-pass processor,    processor incorporated into pass of a standard two-pass assembler,    All of the above

Ans:D ,D

www.000webhost.com