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


The first set of the three permissions (rw) pertains to the owner of the file, indicating that the owner has
Options: executable permission only,    write and executable permissions,    both read and executable permissions.,    both read and write permissions

Ans:D ,D


. The Input Mask wizard does NOT include the ability to do which of the following?
Options: a. Force all uppercase b. Define placeholder c. Store symbols with data d. Use preset masks

Ans:9 – a ,9 – a


When was the X Window System born?
Options: 1984,    1989,    1988,    1990

Ans:A,A


How many bytes of memory will the following code reserve? #include<stdio.h> #include<stdlib.h> int main() { int *p; p = (int *)malloc(256 * 256); if(p == NULL) printf("Allocation failed"); return 0; }
Options: 65536,    Allocation failed,    Error,    No output

Ans:B ,B


Can you name of the major Operating System used in computers?
Options: MS DOS,    OS/2,    UNIX,    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


The term gigabyte refers to
Options: 1024 bytes,    1024 kilobytes,    1024 megabytes,    1024 gigabytes

Ans:C,C


Acceptance testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate systems,    testing changes made in an existing or a new program

Ans:A ,A


. Each model of a computer has a unique

Options: A) Assembly of a computer B) Machine language C) High level language D) All of the above

Ans:B,B


Which of the following statements are true regarding the command ip route 172.16.4.0 255.255.255.0 192.168.4.2? The command is used to establish a static route. The default administrative distance is used. The command is used to configure the default route. The subnet mask for the source address is 255.255.255.0.
Options: 1 and 2,    2 and 4,    3 and 4,    All of the above

Ans:A ,A


. ENIAC uses
Options: A) Decimal Numbering System B) Octal Numbering System C) Binary Numbering System D) Hexadecial Numbering System

Ans:A,A


An electronic circuit with about 20 transistors fabricated on a silicon chip is known as
Options: SSI,    MSI,    DPS,    RJE

Ans:A ,A


ILLIAC is a
Options: Super computer,    Mini computer,    Mainframe computer,    Micro computer

Ans:A ,A


Excel uniquely identifies cells within a worksheet with a cell name
Options: Cell names,Column numbers and row letters,Column letters and row numbers,Cell locator coordinates

Ans:C,Column letters and row numbers


The two kinds of main Memory are:
Options: Primary and secondary,    Random and sequential,    ROM and RAM,    All of the above

Ans:C,C


The digital computer was developed primarily in
Options: A) USSR B) Japan C) USA D) UK

Ans:-C,-C


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


The arranging of data in a logical sequence is called
Options: A) Sorting B) Classifying C) Reproducing D) Summarizing

Ans:-A,-A


Which of the following is the correct order of keywords for SQL SELECT statements?
Options: SELECT, FROM, WHERE,    FROM, WHERE, SELECT,    WHERE, FROM,SELECT,    SELECT,WHERE,FROM

Ans:A ,A


. when you use the fill effects in the format data series dialog box, you can not
Options: a. rotate text on the chart b. select a fore ground color c. select a pattern d. select a background color

Ans:– a,– a


The packets switching concept was first proposed
Options: in the late 1980s for the Defense Ministry of US.,    in the early 1960s for military communication systems, mainly to handle speech,    in the late 1950s for Defense Ministry of US,    All of the above

Ans:B ,B


During the laser printer's conditioning phase a uniform charge of _____ is placed on the photosensitive drum.
Options: +1000 volt,    +600 volts,    -600 volts,    -1000 volts

Ans:C ,C


A __ name must be unique within a database
Options: a. Table b. Field c. Record d. Character

Ans:ndash; a,ndash; a


How can you remove tab stop markers from ruler?
Options: a. Double click the tab marker and choose Clear All b. Drag the tab stop marker out of the ruler c. Right click the tab stop marker and choose remove d. All of above

Ans:– B,– B


A word processor designed for programmers is called
Options: a formatter,    a compiler,    an editor,    a debugger

Ans:C ,C


In the PROLOG language system, facts are manipulated by:
Options: algorithms,    rules,    memory,    simulations

Ans:B ,B


Which of the following decides which systems development projects to work on first ?
Options: data diagram,    project dictionary,    systems flowcharts,    steering committee

Ans:A ,A


The entity integrity rule states that:
Options: no primary key attribute may be null.,    no primary key can be composite.,    no primary key may be unique.,    no primary key may be equal to a value in a foreign key.

Ans:A ,A


In LISP, the function evaluates both <variable> and <object> is
Options: set,    setq,    add,    eva

Ans:A ,A


How can you access the font size tool on formatting toolbar?
Options:  A) Ctrl + S, B) Ctrl + Shift + S, C) Ctrl + P, D) Ctrl + Shift + P,

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


In analyzing the compilation of PL/I program, the description "resolving symbolic address (labels) and generating machine language" is associated with
Options: Assembly and output,    Code generation,    Storage assignment,    Syntax analysis

Ans:A ,A


.    Which command displays comma for thousand separating on file size while listing?
Options: a.    Dir/w b.    Dir/s c.    Dir/b d.    Dir/c

Ans:.c,Correct Answer: d. Dir/c


. A computer can solve more than one kind of problem. This is related to which of the following characteristics?
Options: A) Accuracy B) Reliability C) Versatility D) Automatic

Ans:8-C,8-C


An operational system is which of the following?
Options: A system that is used to run the business in real time and is based on historical data.,    A system that is used to run the business in real time and is based on current data.,    A system that is used to support decision making and is based on current data.,    A system that is used to support decision making and is based on historical data.

Ans:B ,B


Who is considered the 'father' of the minicomputer and one of the founder fathers of the modern computer industry world-wide?
Options: George Tate,    Kenneth H. Olsen,    Seymour Cray,    Basic Pascal

Ans:B ,B


Which of the following is not a desired characteristic of objectives?
Options: understandable,    relistic,    valid,    ambitious

Ans:D ,D


In order to increase the amount of memory available for a system, what is the maximum size of a swap partition (with kernel version 2.2.x)?
Options: 2GB,    128MB,    64MB,    32MB

Ans:A ,A


A word field may consist of an optional field instruction called a(n) ______
Options: subdocument B. symbol C. signal D. switch

Ans:– D ,


What is defined by Handout Master?
Options: Slide Formatting B. Slide Transaction C. Layout of Handout D. Layout of Slide

Ans:– C ,


Which type of OSPF network will elect a backup designated router? Broadcast multi-access Non-broadcast multi-access Point-to-point Broadcast multipoint
Options: 1 and 2,    3 and 4,    3 only,    None of the above

Ans:A ,A


. The first Macintosh computer was from
Options: A) First generation B) Second generation C) Third generation D) Fourth generation

Ans:D,D


A set of information that defines the status of resources allocated to a process is
Options: A) Process control B) ALU C) Register Unit D) Process description

Ans:-D,-D


The DBMS that is most difficult to use is ________ .
Options: Microsoft's SQL Server,    Microsoft's Access,    IBM's DB2,    Oracle Corporation's Oracle

Ans:D ,D


An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program

Ans:C,C


You have just installed a new internal PCI modem on you desktop. It will not dial out. what is the problem?
Options: The port speed is set too high,    the modem has not been set up in control panel properties,    the phone line is plugged into the line-in port on the modem card,    the phone line out of the wall is plugged into the phone port on the modem card

Ans:D ,D


The steady-state error is:
Options: independent of the type of input,    a function of the transient response,    zero for all inputs to type 1 systems,    decreased by increasing gain.

Ans:D ,D


  Which is the shortcut key to jump to the first slide of the presentation? A.  Home B.  Alt + Home C.  Ctrl + Home D.  Shift + Home
Options:

Ans:– C ,


. One of the main feature that distinguish microprocessors from micro-computer is
Options: A) Words are usually large in microprocessors B) Words are shorter in microprocessors C) Microprocessor does not contain I/O device D) Exactly the same as the machine cycle time

Ans:C,C


An input device that converts data punched into paper lape into a binary format is
Options: Page reader,    Paper tape punch,    Paper tape reader,    Card punch

Ans:C ,C

www.000webhost.com