Which language is used to create macros in Excel?


Options: Visual Basic B. C C. Visual C++ D. Java

Ans:– A ,


Description: mcqquestions

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

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


. Which of the following is input device?
Options: A) scanner B) speaker C) monitor D) projector

Ans:A,A


8. Which command is used to see the version?
Options: a. Version b. Ver c. Verson d. None of above

Ans:Correct Answer: b ,Correct Answer: b


Composition is a stronger form of which of the following?
Options: Aggregation,    Encapsulation,    Inheritance,    All of the above.

Ans:A ,A


. Dial up connection allows you to
Options: a. Connect ISP b. Internet c. Server d. All of above

Ans:1 – a ,1 – a


In SQL, which command is used to remove a stored function from the database?
Options: REMOVE FUNCTION,    DELETE FUNCTION,    DROP FUNCTION,    ERASE FUNCTION

Ans:C ,C


to view a cell comment
Options: a. click the edit comment command on the insert menu b. click the display comment command on the window menu c. position the mouse pointer over the cell d. click the comment command on the view menu

Ans:#8211; c,#8211; c


Having compatibility and commonality in and between vendors' equipment is called:
Options: registration,    standardization,    integration,    networking

Ans:B ,B


Which of the following cannot be toggled from View >> Toolbars?
Options: a. Control Toolbox b. Slides c. Revisions d. Reviewing

Ans:– B ,– B


switching between portrait and landscape modes involves the:
Options: header and footer toolbar,print layout view, page setup dialog box, none of the above

Ans:C,page setup dialog box


Digitizers can be converted from "dumb" to "smart" through the addition of:
Options: a microprocessor,    an electromagnetic coupling,    keyboard,    a scanner

Ans:A ,A


17. What is the smallest width of a column?
Options: a. 0″ b. 0.5″ c. 1″ d. 1.5″

Ans:– B ,– B


When the graph of current versus voltage is a straight line, the device is referred to as
Options: Active,    Linear,    Nonlinear,    Bipolar

Ans:B ,B


16. Which command is used to copy all files from drive a with extension .txt to the currently logged drive and directory?
Options: a. Copy a. *.txt b. Copy *.txt a: c. Copy *.txt c: d. Copy *.txt all.txt

Ans:Correct Answer: a ,Correct Answer: a


Which of the following is tactical decision?
Options: capital-source decision,    product decision,    plant-location decision,    budget allocation

Ans:D ,D


. IBM 1401 is
Options: A) First Generation Computer B) Second Generation Computer C) Third Generation Computer D) Fourth Generation Computer

Ans:B,B


  To insert new slide in the current Presentation, we can choose:
Options: Ctrl+M B. Ctrl+N C. Ctrl+O D. Ctrl+F

Ans:– A ,


HMP (Host Monitoring Protocol) is:
Options: a TCP/IP protocol used to dynamically bind a high level IP Address to a low-level physical hardware address,    a TCP/IP high level protocol for transferring files from one machine to another.,    a protocol used to monitor computers,    a protocol that handles error and control messages

Ans:C ,C


A snowflake schema is which of the following types of tables?
Options: Fact,    Dimension,    Helper,    All of the above

Ans:D ,D


Indexed-Sequential organization
Options: means storing records in contiguous blocks according to a key.,    Stores records sequentially but uses an index to locate records,    uses an index for each key type,    has records placed randomly throughout the file

Ans:B ,B


. Which keys can be pressed quit without saving in DOS
Options: a. Ctrl + A b. Ctrl + B c. Ctrl + C d. Ctrl + D

Ans:Correct Answer: c ,Correct Answer: c


. Which switch will be used in dir to see screen full contents of disk at a time?
Options: a. /s b. /w c. /p d. /b

Ans:5 – c ,5 – c


The structure chart is
Options: a document of what has to be accomplished,    a statement of information processing requirement,    a hierarchical partitioning of the program,    All of the above

Ans:C ,C


What sign is used to erase or kill an entire line you have typed and start you are on a new line (but not display a new prompt)?
Options: !,    $,    #,    @

Ans:D ,D


23. What is the default font size of a new Word document based on Normal template in Word 2003?
Options: a. 10 pt b. 12 pt c. 14 pt d. None of above

Ans:– B ,– B


Which memory system is not as a mass memory medium?
Options: semiconductor memory,    magnetic tape,    magnetic disk,    magnetic drum

Ans:A,A


To preview a motion path effect using the custom animation task pane, you should
Options: a. click the play button b. click the show effect button c. double click the motion path d. all of above

Ans: – A , – A


. Which of the following types of joins displays records with the same value in the common field?
Options: a. Inner join b. Left outer join c. Right outer join d. Self join

Ans:0 – a ,0 – a


A device that both transmits and receives data, is
Options: Transducer,    Trapdoor,    Translator,    Transceiver

Ans:D ,D


The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B


In the instruction, 500 SUBA # 50 the command field is:
Options: 500,    # 50000,    SUBA,    (b) and (c)

Ans:C ,C


Time during which a job is processed by the computer is
Options: Delay time,    Real time,    Execution time,    Down time

Ans:C ,C


Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists  

Ans:a,a


A process that is repeated, evaluated, and refined is called:
Options: diagnostic,    descriptive,    interpretive,    iterative

Ans:D ,D


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

Ans:A ,A


The two classifications of inputs are
Options: energies and maintenance,    maintenance and waste,    maintenance and signal,    products and waste

Ans:C ,C


Which command is used to extract specific columns from the file?
Options: cat,    cut,    grep,    paste

Ans:B ,B


Which command will display all the EIGRP feasible successor routes known to a router?
Options: show ip routes *,    show ip eigrp summary,    show ip eigrp topology,    show ip eigrp adjacencies

Ans:C ,C


The feasibilities studied in preliminary investigation is (are):
Options: technical feasibility,    economic feasibility,    operational feasibility,    All of the above

Ans:D ,D


Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:B ,B


 In PowerPoint, when the mouse pointer appears as this it indicates that the Draw Table feature is on
Options:  Solid plus sign B.  Solid arrow C.  I-beam D.  Pencil

Ans:– D ,


DOS system file consists of
Options: a. IBMBIO.COM, IBMDOS.COM, COMMAND.COM b. COMMAND.COM, IBMBIO.COM, FORMAT.COM c. SYS.COM,IBMBIO.COM,IBMDOS.COM d. None of the above

Ans:10 a.             ,10 a.            


In table design view, which key can be used to switch between the field names and properties panels?
Options: a. F3 b. F4 c. F5 d. F6

Ans:ndash; d,ndash; d


A single packet on a data link is known as
Options: Path,    Frame,    Block,    Group

Ans:B,(Banswer


Which of the following is form of semi conductor memory in which it is possible to change the contents of selected memory locations by applying suitable electrical signals.
Options: CAM,    ROM,    EAROM,    ANACUS

Ans:C ,C


To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Options: ONLY,    UNIQUE,    DISTINCT,    SINGLE

Ans:C ,C


In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______
Options: a. Child , Parent b. Parent , Child c. Brother , Sister d. Father , Son

Ans:dash; b,dash; b


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

Ans:D ,D


A self check digit is useful in detecting
Options: transcription errors only,    transposition errors only,    Random errors only,    All of the above

Ans:D ,D


. The Name box
Options: a. Shows the location of the previously active cell b. Appears t the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:– b,– b


_____ is the use of a model in an attempt to identify and/or reflect the behaviour of a real person, process, or system.
Options: master,    decision,    plan,    simulation

Ans:D ,D

www.000webhost.com