Which Chart can be created in Excel?


Options: Area B. Line C. Pie D. All of the above

Ans:– D ,


Description: mcqquestions

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

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


Communication ports are found on the back of microcomputers. They are used to connect the computer to _____
Options: printers,    modems,    other hardware,    All of the above

Ans:D ,D


The first mechanical calculating machine was made by
Options: William Oughtred,    Gottfried Leibnitz,    Blaise Pascal,    Charles Babbage

Ans:C ,C


Environmental information is especially important to
Options: top-level managers,    middle-level managers,    low-level managers,    All of the above

Ans:A ,A


The computer can potentially be used to monitor most of our actions, thus robbing us of _____
Options: tapping,    privacy,    back log,    security

Ans:B ,B


The first two steps in the ____ process are to establish goals or standards, and then measure actual performance.
Options: expert,    centers,    control,    MIS

Ans:C ,C


What does EXT indicator on status bar of MS Word indicate?
Options:  A) It indicates whether the external text is pasted on document or not, B) It indicates whether extended add-ons are installed on MS Word or not, C) It indicates whether Extended Selection mode is turned on or off, D) None of above,

Ans:-C,-C


What should be first considered in choosing a plotter?
Options: The hardware you currently own,    The application for which it will be used,    The type of data you will input,    The cost

Ans:B ,B


To copy cell contents using drag and drop press the
Options: a. End key b. Shift key c. Ctrl key d. Esc key

Ans:#8211; a,#8211; a


Usually, it takes 10-bits to represent one character. How many characters can be transmitted at a speed of 1200 BPS?
Options: 10,    12,    120,    1200

Ans:C ,C


How many address lines are needed to address each memory locations in a 2048 x 4 memory chip?
Options: a. 10 b. 11 c. 8 d. 12 

Ans:3.b,3.b


The first industrial robot for commercial uses was installed in a Japanese plant at Toyota Automatic Loom Company, the parent company of the Toyota Automobile Group. When did this robot go into operation?
Options: June 1965,    November 1966,    December 1967,    April 1970

Ans:C ,C


Which of the following is an absolute cell reference?
Options: a. !A!1 b. $A$1 c. #a#1 d. A1

Ans:#8211; b,#8211; b


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B ,B


Which disk interface standard includes support for up to eight peripheral devices?
Options: ST50G/412,    IDE,    SCSI,    ESDI

Ans:C ,C


The process of entering data into a storage location
Options: adds to the contents of the location,    cause variation in its address number,    is known as a readout operation,    is destructive of previous contents

Ans:D,D


A subquery in an SQL SELECT statement:
Options: can only be used with two tables.,    can always be duplicated by a join.,    has a distinct form that cannot be duplicated by a join.,    cannot have its results sorted using ORDER BY.

Ans:C ,C


Which of the following tool enables you to add text to a slide without using the standard placeholders?
Options: a. Text tool box b. Line tool c. Drawing tool d. Auto shapes tool

Ans: – A , – A


Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?
Options:  A) Wingdings, B) Wingdings 3, C) Webdings, D) Symbol,

Ans:-D,-D


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 layer 1 devices can be used to enlarge the area covered by a single LAN segment? Switch NIC Hub Repeater RJ45 transceiver
Options: 1 only,    1 and 3,    3 and 4,    5 only

Ans:C ,C


. Which of the following font effect is not available in PowerPoint Font dialog box?
Options: a.  Underline b.  Shadow c.  Emboss d.  Strikethrough

Ans:4 – D ,4 – D


What will be the output of the program? #include<stdio.h> #define MAX(a, b) (a > b ? a : b) int main() { int x; x = MAX(3+2, 2+7); printf("%d\n", x); return 0; }
Options: 8,    9,    6,    5

Ans:B ,B


A central purpose of most decision-support systems is
Options: to build a model of the decision¬making problem,    to design a data-base manage¬ment system,    to build an expert system,    to determine the key decisions in the problem area

Ans:A ,A


Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above

Ans:D,D


. Which function is not available in the Consolidate dialog box?
Options: a. Pmt b. Average c. Max d. Sum

Ans:– a,– a


. What is the AutoComplete feature of Excel?
Options: a. It automatically completes abbreviated words b. It completes text entries that match an existing entry in the same column c. It completes text and numeric entries that match an existing entry in the same column d. It completes text entries that match an existing entry in the same worksheet

Ans:– b,– b


Cisco's Unified Wireless Solution provides a mesh solution. What devices do you absolutely need to purchase to run a Cisco solution? WCS Controller Access point Bridge
Options: 1 and 2,    2 and 3,    1 and 4 only,    4 only

Ans:B ,B


In Decision trees
Options: nodes represent the conditions, with the right side of tree listing the actions to be taken,    the root is drawn on the left and is the starting point on the decision sequence.,    the branch depends on the condition and decisions to made,    All of the above

Ans:D ,D


On the PC side, the printer port is a:
Options: 25 pin female parallel connector,    15 pin female parallel connector,    25 pin male serial connector,    15 pin female serial connector

Ans:A,25 pin female parallel connector


If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?
Options:  A) in the left margin, B) in the right margin, C) both in left and right margin, D) None of Above, 

Ans:-D,-D


In OSI model, which of the following layer transforms information from machine format into that understandable by user
Options: application,    presentation,    session,    physical

Ans:B ,B


40. When the same word is used in multiple locations or a word is used that was not quite appropriate, a thesaurus can be used to look up a (n) _____ or a word similar in meaning.
Options: a. synonym b. homonym c. antonym d. metronym

Ans:– A ,– A


In data transmission, the bit coding scheme used to represent a byte is typically:
Options: EBCDIC,    ASCII,    SNA,    Hexadecimal

Ans:B ,B


In LISP, the function (list-length <list>)
Options: returns a new list that is equal to <list> by copying the top-level element of <list>,    returns the length of <list>,    returns t if <list> is empty.,    All of the above

Ans:B ,B


A design that consists of a hierarchy of modules; each module has a single entry and a single exit subroutine, is known as
Options: hierarchy structure,    top-down design,    Tuple,    Turnaround

Ans:B ,B


What is a TSR?
Options: test status request,    terminate and stay resident program,    take status request,    token set ready

Ans:B ,B


What is bytecode?
Options: Machine-specific code,    Java code,    Machine-independent code,    None of the above is correct.

Ans:C ,C


. The three parts of an IIF function are separated by _____.
Options: a. dashes b. asterisks c. semicolons d. commas

Ans:8 – d ,8 – d


  Which option can be used to set custom timings for slides in a presentation?
Options: Slider Timings B. Slider Timer C. Rehearsal D. Slide Show Setup

Ans:– C ,


. The system unit of a personal computer typically contains all of the following except:

Options: A) Microprocessor B) Disk controller C) Serial interface D) Modem

Ans:D,D


Microfilm reader is a
Options: OCR device,    COM device,    MICR device,    None of the above

Ans:B,B


A database can be best described as
Options: a. Organized collection of data b. Useful presentation of data c. Graphical representation of data d. All of above

Ans:ndash; a,ndash; a


One henry of inductance is defined as:
Options: the amount of counter emf required to reduce a current to 1 A,    the amount of inductance required for generating 1 V of counter emf when the current changes at the rate of 1 A per second,    the amount of inductance required to change the frequency of a current by 1 Hz,    the number of turns of wire in an inductor multiplied by the amount of current flowing through it

Ans:B ,B


During preventative maintenance on a dot matrix printer, do NOT lubricate:
Options: Platen assembly,    Print head pulley,    Print head pins,    Paper advance gear bushings

Ans:C ,C


Standards are provided by
Options: standards organizations,    user groups,    computer vendors,    All of the above

Ans:D ,D


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample 1 2 3 cmd> sample 2 2 3 cmd> sample 3 2 3 /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%s\n", argv[0]); return 0; }
Options: sample 3 2 3,    sample 1 2 3,    sample,    Error

Ans:C ,C


Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options: Using the Oracle Database Configuration Assistant.,    Using the Oracle-supplied database creation procedures.,    Using the SQL CREATE DATABASE command.,    None of the above is correct.

Ans:A ,A


Which of the following is correct way to define the function fun() in the below program? #include<stdio.h> int main() { int a[3][4]; fun(a); return 0; }
Options: void fun(int p[][4]) { } ,    void fun(int *p[4]) { } ,    void fun(int *p[][4]) { } ,    void fun(int *p[3][4]) { }

Ans:A ,A


If the memory slots have 30 pins then the chip is a?
Options: DIMM,    SIMM,    SDRAM,    All of the above

Ans:B ,B


You can add a row using SQL in a database with which of the following?
Options: ADD,    CREATE,    INSERT,    MAKE

Ans:C ,C

www.000webhost.com