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: 10933 | 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:

The blocking factor is:
Options: a group of fields stored in adjacent memory.,    the number of physical records per page.,    attributes grouped together by the same primary key.,    attributes grouped together by the same secondary key.

Ans:B ,B

In SQL, the _____ command is used to recompile a view

Ans:D ,D

. To install the new font
Options: a. Start -> setting -> control panel -> font b. Start -> setting -> control panel -> font -> install new font c. Start -> control panel -> font -> install new font d. Start -> setting -> font

Ans: b, b

. Tree structure displays the
Options: a. File only b. Directory only c. File and directory name d. None of above

Ans:2 – c ,2 – c

The Cancel and Enter buttons appear in the:
Options: Title bar B. Formula bar C. Menu bar D. Sheet tabs

Ans:– B ,

Which DOS driver is used to emulate expanded memory?
Options: Himem.sys,    EMM386.exe,    Mem386.sys,    Ramdrive.sys

Ans:B ,B

. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Options: Logical B. Math & Trigonometry C. Statistical D. Financial

Ans: – D ,

Sales invoking is a:
Options: pre-sales activity,    job of finance department,    post-sales activity,    All of the above

Ans:A ,A

19. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.
Options: a. 1-inch left, right, top, and bottom b. 1.25-inch left, right, top, and bottom c. 1.25-inch left and right margins and 1-inch top and bottom d. 1-inch left and right margins and 1.25-inch top and bottom

Ans:– C ,– C

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

Conversion of binary number 1010101000010111 to hexadecimal number is
Options: D8F916,    A8B916,    AA1716,    D9F816


Programs prepared by an outside supplier & privided to a user in a machine readable form is known as
Options: Utility program,    Canned program,    Application program,    Application software

Ans:B ,B

. When a thread waits indefinitely for some resource, but other threads are actually using it is called
Options: Starvation B. Demand Paging C. Segmentation D. None of them

Ans: – A ,

.   Which of the following is/are true about rulers and guides?
Options: a. Rulers and guides can be turned on or off b. Rulers and guides print on the slide c. Rulers and guides help place objects on the slide d. A and c

Ans:8 – D ,8 – D

You want to implement a mechanism that automates the IP configuration, including IP address, subnet mask, default gateway, and DNS information. Which protocol will you use to accomplish this?
Options: SMTP,    SNMP,    DHCP,    ARP

Ans:C ,C

Who proposed the relational model?
Options: Bill Gates B. E.F. Codd C. Herman Hollerith D. Charles Babbage

Ans:– B ,

Because it contains a description of its own structure, a database is considered to be ________ .
Options: described,    metadata compatible,    self-describing,    an application program

Ans:C ,C

While working with MS-DOS, which command is used to display a list of deleted files that DOS can undelete?

Ans:C ,C

. Bold, Italic, Regular are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – A , – A

Which of the following is not considered as a tool at the system design phase?
Options: piechart,    data-flow diagram,    decision table,    systems flowchart

Ans:A ,A

. Which device can understand difference between data & programs?
Options: A) Input device B) Output device C) Memory D) Microprocessor


. To exit the PowerPoint application, you should
Options: a. Click the application minimize button b. Click the document close button c. Double click the application control menu icon d. Double click the document control menu icon

Ans:3 – C ,3 – C

Which of the following is not an input device?
Options: A) OCR B) Optical scanners C) Voice recognition device D) COM (Computer Output to Microfilm)


Group of instructions that directs a computer is called
Options: Storage,    Memory,    Logic,    Program

Ans:D ,D

Which of the following is not one of the three ways to classify an action assertion?
Options: Condition,    Integrity Control,    Authorization,    Enabler

Ans:D ,D

A form of modulation In which the amplitude of a carrier wave is varied in accordance with some characteristic of the modulating signal, is known as
Options: Aloha,    Angle modulation,    Amplitude modulation,    modem

Ans:C ,C

. Which of the following registers is loaded with the contents of the memory location pointed by the PC?
Options: A) Memory address registers B) Memory data registers C) Instruction register D) Program counter


A logical schema
Options: is the entire database,    is a standard way of organizing information into accessible parts,    describes how data is actually stored on disk,    All of the above

Ans:B ,B

. What is System Analysis?
Options: The design of the screen the user will see and use to enter or display data B. System analysis defines the format and type of data the program will use C. System Analysis involves creating formal model of the problem to be solved D. None of the above

Ans: – C ,

Which of the following is an example of a client-server model?
Options: TELNET,    FTP,    DNS,    All of the above

Ans:D ,D

In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options:  A) 35, B) 15, C) 63, D) 65, 


Each array declaration need not give, implicitly or explicitly, the information about
Options: a. the name of array b. the data type of array c. the first data from the set to be stored d. the index set of the array  


Which one of the following statements best describes magnetic hysteresis?
Options: Hysteresis is the amount of magnetic flux that is not confined to the core material of an electromagnet,    Hysteresis is most apparent when a steady amount of current is lowing through the coil of an electromagnet,    Hysteresis is most apparent when the current through the coil of an electromagnet changes frequently,    Hysteresis is most apparent when the core material is saturated

Ans:C ,C

. Which command is used to combine F1 and F2 file into the file F3
Options: a. Copy F1+F2 F3 b. Copy F3 F1+F2 c. Copy F1+F2+F3 d. Copy F1 F2+F3

Ans:2 – a ,2 – a

79. Which would you choose to save a document with a new name?
Options: a. Press Ctrl+S b. Click File, Save c. Click Tools, Options, Save d. Click File, Save As

Ans:–  D ,–  D

A BI reporting system does not ________ .
Options: create meaningful information,    deliver information to users on a timely basis,    use statistical procedures to predict future events,    use disparate data sources

Ans:C ,C

Which of the following allows a simple email service and is responsible for moving messages from one mail server to another?
Options: IMAP,    DHCP,    SMTP,    FTP

Ans:C ,C

A machine associated with card-based data processing is
Options: Codomain,    Collator,    Cartridge,    Digitizer

Ans:B ,B

A device or system not directly connected to the CPU is
Options: On-line,    Keyboard,    Memory,    Off-line

Ans:D ,D

In analyzing the compilation of PL/I program, the term "Lexical analysis" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:B ,B

Assuming 100% efficiency, what is the power being consumed at the secondary winding of the transformer described in question 91?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A

What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
Options: 5,430.00 B. 5,436.80 C. 5,436.8 D. 6.8

Ans:– B ,

What is the name of the earliest calculating machine which was based on concepts found in modern computers but was unfortunately never built?
Options: Babbage's Difference Engine,    Pascal's Adder,    Leibnitz's Multiplier,    Differential Analyser

Ans:A ,A

The executive vice-president usually has responsibility for the
Options: physical system of the firm,    conceptual information system of the firm,    vice-president of finance,    All of the above

Ans:A ,A

Which of the following technique is used for Time-To-Line (TTL)?
Options: a technique used in best-effort delivery system to avoid endlessly looping packets.,    a technique used by protocols in which a lower level protocol accepts a message from a higher level protocol and places it in the data portion of the low level frame,    One of the pieces that results when an IP gateway divides an IP datagram into smaller pieces for transmission across a network that cannot handle the original datagram size.,    All of the above

Ans:A ,A

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

.    Which command displays only file and directory names without size, date and time information?
Options: a.    Dir/w b.    Dir a: c.    Dir /b d.    Dir /s

Ans:c,Correct Answer: dir/b

What command is used to display the characteristics of a process?
Options: au,    ps,    du,    pid

Ans:B ,B

______ shares characteristics with both hardware and software
Options: Operating system B. Software C. Data D. None

Ans:– A ,

. Which of the following database object produces the final result to present?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:5 – b ,5 – b