. Which of the following is correct syntax in Excel?


Options: =IF(LogicalTest, TrueResult, FalseResult) B. =IF(LogicalTest, (TrueResult, FalseResult)) C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Ans:– A ,


Description: mcqquestions

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

Hits Today: 13120 | 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:


We can receive data either through our television aerial or down our telephone lines and display this data on our television screen. What is the general name given to this process?
Options: Viewdata,    Teletext,    Telesoftware,    Videotex

Ans:D ,D


. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
Options: a. display all customers with CustID from 10 to 100 b. display all customers with CustID above 10 c. display all customers with CustID below 100 d. display all customers with CustID from 11 to 99

Ans:– d,– d


A file produced by a spreadsheet
Options: is generally stored on disk in an ASCII text format,    can be used as it by the DBMS,    can be used for graphic,    All of the above

Ans:A ,A


An open rectangle
Options: defines a source or destination of system data,    identifies data flow,    represents a process that transforms incoming data flow(s) into outgoing data flows,    is a data store-data at rest, or a temporary repository of data

Ans:D ,D


A one-bit signal that indicates the start of data transmission by an asynchronous device is
Options: Parity bit,    Status bit,    Zero bit,    Start bit

Ans:D ,D


. Which of the following file menu option saves document to disk?
Options: a. Save b. Create c. Rename d. All of above

Ans:5 – a ,5 – a


.  In a module, a(n) _______ is a series of commands and properties that perform a specific task.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– c,– c


. What is the full form of SQL?
Options: a. Sophisticated Question List b. Structured Question List c. Structured Query Language d. Small Query Length

Ans:– c,– c


What is an interpreter?
Options:  An interpreter does the conversion line by line as the program is run B.  An interpreter is the representation of the system being designed C.  An interpreter is a general purpose language providing very efficient execution D.  None of the above

Ans:– B ,


A dialog box with a bomb appears oh a Macintosh screen. What type of problem has occurred?
Options: A RAM problem,    A software problem,    A ROM problem,    An ADB problem

Ans:B ,B


. In Excel _______ may not contain in Formula
Options: a. Text Constant b. Number Constant c. Circular Reference d. All of them

Ans:– c,– c


In SQL, the CREATE TABLESPACE is used
Options: to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace,    to create a database trigger,    to add/rename data files, to change storage,    All of the above

Ans:A ,A


What is a free electron?
Options: An electron that has been freed from its parent atom,    An electron that costs nothing,    An electron that has no electrical charge,    An electron that has twice the amount of charge of a normal electron

Ans:A ,A


System design aid should primarily
Options: help analyse both data and activities,    help in documentation,    help in programming,    generate code

Ans:A ,A


What expansion types do most pll/plll motherboards support?
Options: MCA, PCI,    ISA, EISA,    ISA, PCI, AGP,    ISA, VESA, PCI

Ans:C ,C


Which option will be used with sort command to start sorting ofter the nth column of the (m+l)th field?
Options: -m.n,    +m.n,    + n.m+1,    +(m+l).n

Ans:B ,B


Which is the best process to access number of records from the same file?
Options: a batch job,    a real-time job,    an on-line job,    All of the above

Ans:A ,A


The NOT EXISTS keyword will be true if:
Options: any row in the subquery meets the condition.,    all rows in the subquery fail the condition.,    both of these two conditions are met.,    neither of these two conditions is met.

Ans:B ,B


Waveforms are graphs that show:
Options: frequency on the vertical axis and amplitude on the horizontal axis,    amplitude on the vertical axis and frequency on the horizontal axis,    amplitude on the vertical axis and the passage of time on the horizontal axis,    the passage of time on the vertical axis and amplitude on the horizontal axis

Ans:C ,C


In an intrinsic semiconductor, the number of free electrons
Options: Equals the number of holes,    Is less than the number of holes,    Is greater than the number of holes,    Impossible to say

Ans:A ,A


Corporate modeling software can be used for
Options: cash planning,    operational budgeting,    capital budgeting,    All of the above

Ans:D ,D


The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Options: record,    field,    file,    data base

Ans:A ,A


. Which of the following is valid statement?
Options: A) Data in itself is useless unless it is processed B) The data that is processed is called a program C) The data which is not yet processed is information D) Information is processed by computer to generate data.

Ans:A,A


A command that lets you change one or more fields in a record is
Options: Insert,    Modify,    Look-up,    All of the above

Ans:B ,B


Which of the following way(s) the information system and capability are related to each other:
Options: improved processing speed,    increased volume of activities,    faster retrieval of information,    All of the above

Ans:D ,D


The term used to represent the recycling of unused memory is:
Options: garbage collection,    diagnostic routine,    memory dump,    direct memory access

Ans:A ,A


The Management Information system (MIS) structure with one main computer system is called a
Options: hierarchical MIS structure,    distributed MIS structure,    centralized MIS structure,    decentralized MIS structure

Ans:C ,C


Which of the following are the building blocks of all the circuits in a computer.
Options: Circuit switch,    Logic gates,    Logical Operators,    Instructions

Ans:B ,B


. What is the keyboard shortcut to move to the last records in a table?
Options: a. [Tab] b. [Shift]+[Tab] c. [Ctrl]+Home] d. [Ctrl]+[End]

Ans:0 – d ,0 – d


During what phase, the requirement analysis is performed?
Options: system design phase,    system development phase,    system analysis phase,    system investigation phase

Ans:C ,C


In vi editor, forward search is performed using the command.
Options: :pat,    ?pat,    /pat,    All of the above

Ans:C ,C


You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Options: a. Pie chart b. Row chart c. Line chart d. Column chart

Ans:#8211; c,#8211; c


. Which of the following method can insert a new slide in current presentation?
Options: a.  Right click on the Slide panel and choose New Slide b.  From Insert menu choose New Slide c.  Click on New Slide button on toolbar d.  All of above

Ans:2 – D ,2 – D


Alex is required to provide information on how many people are using the network at any one time. Which network will enable him to do so?
Options: Server-based,    Token-Ring,    Ethernet,    Star

Ans:A ,A


Front-end processor is a _____ designed specifically to handle the communications processing task.
Options: ALU,    Control unit,    CPU,    Register

Ans:C ,C


Which of the following is private IP address?
Options: 12.0.0.1,    168.172.19.39,    172.15.14.36,    192.168.24.43

Ans:D ,D


Which of the following symbol modes are used to input of graphics to General CAD system?
Options: Live and Rectangle mode,    Arc and Circle mode,    Dimension and Alphanumeric mode,    All of the above

Ans:D ,D


What would be the equivalent pointer expression for referring the array element a[i][j][k][l]
Options: ((((a+i)+j)+k)+l),    *(*(*(*(a+i)+j)+k)+l),    (((a+i)+j)+k+l),    ((a+i)+j+k+l)

Ans:B ,B


What command is used with vi editor to move back to the beginning of a word?
Options: w,    e,    a,    b

Ans:D ,D


Which, of the following checks, cannot be carried out on the input data to a system?
Options: consistency check,    Syntax check,    Range check,    All of the above

Ans:B ,B


Which of the following formulas is not entered correctly?
Options: a. =10+50 b. =B7*B1 c. =B7+14 d. 10+50

Ans:#8211; d,#8211; d


 Which type of template provides a design concept, fonts & color scheme for presentation?
Options:  Format B.  Design C.  Content D.  Normal

Ans:– B ,


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

Ans:C ,C


It is most common type of query. It retrieves records from one or more tables and then displays the
Options: a. Parameter b. Select c. crosstab d. All of above

Ans:ndash; b,ndash; b


On a dot matrix printer, you should never lubricate which part?
Options: carriage rails,    printhead pins,    paper advance bearings,    carriage bearings

Ans:B ,B


. The Delete key of keyboard is assigned to which command in Excel?
Options: a.  Edit >> Clear >> Contents b.  Edit >> Clear >> All c.  Edit >> Delete d.  All of above

Ans:– a,– a


What is meant by the term RAM?
Options: Memory which can only be read,    Memory which can be both^read and written to,    Memory which is used for permanent storage,    Memory which can only be written to

Ans:B,B


The Santa Clara Valley, California is popularly known as Silicon Valley of America because
Options: huge deposits of silicon are found there,    many silicon chip manufacturing firms are located there,    Santa Claus visits it every Christmas,    it is full of large grain sand

Ans:B ,B


A systems theory of management includes
Options: the manager as the control mechanism,    the use of both environmental and internal information describing what should be achieved,    the use of objectives or standards of performance describing what is being achieved,    All of the above

Ans:A ,A


Which of the following languages is more suited to a structured program?
Options: PL/1,    FORTRAN,    BASIC,    PASCAL

Ans:D ,D

www.000webhost.com