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

Which key deletes the character to the left of the cursor
Options: macros B. template C. mail merge D. none

Ans: B ,

The language that the computer can understand and execute is called
Options: Machine language,    Application software,    System program,    All of the above

Ans:A ,A

The geostationary satellite used for communication systems
Options: rotates with the earth,    remains stationary relative to the earth,    is positioned over equator,    All of the above

Ans:D ,D

How many bits are used in the data bus?
Options: 7,    8,    9,    16

Ans:B ,B

. Web cam is an
Options: A) input unit device B) output unit device C) processing device D) Input and Output device


18. By default, your document prints with:
Options: a. 1 inch top and bottom margins b. a portrait orientation c. 1.25 inches left and right margins d. all of the above

Ans:–  D ,–  D

Which of the following is not the required condition for binary search algorithm?
Options: a. The list must be sorted b. there should be the direct access to the middle element in any sublist c. There must be mechanism to delete and/or insert elements in list d. none of above

Ans:- c,- c

How many types of storage loops exist in magnetic bubble memory?
Options: 8,    4,    16,    2

Ans:D ,D

Which of the following memories contains a thin film of magnetic material sandwitched between two permanent bias magnets?
Options: ROM,    Magnetic disk,    Core memory,    Bubble memory


. Which of the following statements regarding charts is incorrect?
Options: a. It can be inserted into a form only. b. It can be designed as a stand-alone object. c. It can be linked to the object in which it is placed. d. It is a control linked to a data source.

Ans:– a,– a

. In Computer Architecture a Bus is _________
Options: a collection of various software B. a collection of various computers C. a collection of shared communication wires D. a collection of chairs where the user sits

Ans:– C ,

Which of the following statements is not true about the FORTRAN language?
Options: FORTRAN is a high level language,    A FORTRAN program, written for the IBM-PC, is totally different from a FORTRAN program written for execution on the SUN machine,    FORTRAN is extensively used to write programs for performing scientific computations,    All of the above

Ans:B ,B

. When creating a vertical page break
Options: a. The active cell must be A1 b. The active cell can be anywhere in the worksheet c. The active cell must be in row 1 d. The active cell must be in column A

Ans:– c,– c

Point out the error in the following program. #include<stdio.h> #include<stdarg.h> fun(...); int main() { fun(3, 7, -11.2, 0.66); return 0; } fun(...) { va_list ptr; int num; va_start(ptr, n); num = va_arg(ptr, int); printf("%d", num); }
Options: Error: fun() needs return type,    Error: ptr Lvalue required,    Error: Invalid declaration of fun(...),    No error

Ans:C ,C

What is the algebraic sum of this series of values:+2, -3, -6,+4?
Options: -6,    -3,    0,    +2

Ans:B ,B

. Which of the following views displays the field name, description, and properties of a table?
Options: a. Datasheet View b. Design View c. Layout View d. Table View

Ans:4 – b ,4 – b

What VTP mode allows you to change VLAN information on the switch?
Options: Client,    STP,    Server,    Transparent

Ans:C ,C

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

Ans:B ,B

Voltage is measured:
Options: in parallel,    in series,    after breaking the circuit,    after checking resistance

Ans:A ,A

Where have the program and data to be located before the ALU and control unit of a computer can operate on it?
Options: Internal memory,    Secondary memory,    Microprocessor,    Magnetic tapes

Ans:A ,A

A microprocessor unit, a memory unit, and an input/output unit form a:
Options: CPU,    compiler,    microcomputer,    ALU

Ans:C ,C

An organization containing manufacturing, marketing, and finance areas is called a
Options: matrix organization,    flow network organization,    modular organization,    functional organization

Ans:D ,D

In the system concepts, term organization
Options: implies structure and order,    refers to the mannar in which each component functions with other components of the system.,    means that parts of the computer system depend on one the another.,    refers to the holism of systems

Ans:A ,A

What is the name of the computer which was first used for programming and playing of music?
Options: ELLIAC,    ENIAC,    UNIVAC,    All of the above


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

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

Ans:B ,B

.   on which part of the chart are the values entered in a data sheet displayed?
Options: a. The title area b. The legend c. The y-axis d. The x-axis

Ans:8 – C ,8 – C

. The process of starting a or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called

Options: A) Duping B) Booting C) Padding D) CPS


The analyst learns of the manager's information needs through use of
Options: mail survey,    in depth interview,    controlled experiment,    observation

Ans:B ,B

An excellent linear programming software package for solving large-scale problems is
Options: MIDAS-2,    OPHELIE II,    PDQ/LP,    All of the above

Ans:B ,B

Which command loads a new version of the Cisco IOS into a router?
Options: copy flash ftp,    copy ftp flash,    copy flash tftp,    copy tftp flash

Ans:D ,D

The Second Generation Computer was based on ________.
Options: Vacuum Tube B. Silicon Chips C. Transistor D. Bio Chips

Ans:– C ,

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Options: a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home

Ans:#8211; a,#8211; a

CD-ROM is a
Options: A) Semiconductor memory B) Memory register C) Magnetic memory D) None of above


.   Ellipse Motion is a predefined ….
Options: a. Design template b. Color scheme c. Animation scheme d. None of these

Ans:1 – C ,1 – C

In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
Options: calendar B. photograph of rainfall C. chart showing rainfall amounts D. database of rainfall

Ans:– C ,

95. What is the shortcut key to Update Formula in a table?
Options: a. F9 b. Alt + F9 c. Ctrl + F9 d. Shift + F9

Ans:–  A ,–  A

An intrinsic semiconductor has some holes in it at room temperature. What causes these holes?
Options: Doping,    Valence electrons,    Free electrons,    Thermal energy

Ans:D ,D

.Only filenames and extensions are to be displayed in wide format, which command you’ll use?
Options: a.    Dir/w b.    Dir a: c.    Dir/s d.    Dir/b

Ans:a,Correct Answer: Dir/w

sp;1. What happens when you click on Insert >> Picture >> Clip Art
Options:  A) It inserts a clipart picture into document, B) It lets you choose clipart to insert into document, C) It opens Clip Art taskbar, D) None of above,


You suspect a virus has entered your computer. What will not be affected by the virus?
Options: CMOS,    Boot sector,    Floppy disks,    Program files

Ans:A ,A

A system design is said to be functionally modular if
Options: the system is able to handle all the function of the application,    each module performs a specific function and can be developed relatively independently by programmers,    the system makes extensive use of function. keys for maximum user assistance,    the system is developed using structured programming through COBOL or PASCAL

Ans:B ,B

Customer data (name and address, shipping instructions, credit terms, etc.) is provided by the:
Options: manufacturing information system,    order entry subsystem,    billing subsystem,    marketing information system

Ans:C ,C

To record a sequence of keystrokes and mouse actions to play back later we use:
Options: Media player B. Sound Recorder C. Calculator D. Macro Recorder

Ans:– D ,

Ctrl + Q
Options: a. Paragraph formatting (Line Space and Paragraph Space) b. Close Word Application without saving Document c. Print Whole Document without confirmation d. Does nothing

Ans:–  A,–  A

How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Options: a. Input mask b. Validation Rule c. Indexed d. IME Mode

Ans:ndash; a,ndash; a

You are working with a class C network. You are required to configure it for five subnets, each of which will support 25 nodes. What subnet should you use?

Ans:B ,B

You need the IP address of the devices with which the router has established an adjacency. Also, the retransmit interval and the queue counts for the adjacent routers need to be checked. What command will display the required information?
Options: show ip eigrp adjacency,    show ip eigrp topology,    show ip eigrp interfaces,    show ip eigrp neighbors

Ans:D ,D

Third generation computers
Options: were the first to use built-in error detecting devices,    used transistors instead of vacuum tubes,    were the first to use neural network,    All of the above

Ans:E ,E

. Which is not a command that is selectable from right click menu of a field column?
Options: a. Hide columns b. Rename columns c. freeze columns d. sort descending

Ans:– b,– b