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

More MS-Excel Related questions:

. Which types of charts can excel produce?
Options: a. Line graphs and pie charts only b. Only line graphs c. Bar charts, line graphs and pie charts d. Bar charts and line graphs only

Ans:– c,– c

What is the meaning of Bandwidth in Network?
Options:  Transmission capacity of a communication channels B.  Connected Computers in the Network C.  Class of IP used in Network D.  None of Above

Ans:– A ,

You type Router#sh ru and receive an % ambiguous command error. Why did you receive this message?
Options: The command requires additional options or parameters.,    There is more than one show command that starts with the letters ru.,    There is no show command that starts with ru.,    The command is being executed from the wrong router mode.

Ans:B ,B

The FIFO algorithm
Options: executes first the job that last entered the queue,    executes first the job that first entered the queue,    execute first the job that has been in the queue the longest,    executes first the job with the least processor needs

Ans:B ,B

In which addressing mode, the address of the location of the operand is given explicitly as a part of the instruction.
Options: absolute mode,    immediate mode,    index mode,    modulus mode

Ans:A ,A

If there are multiple recycle bin for a hard disk
Options: a. you can setdifferent size for each recycle bin b. you can choose which recycle bin to use to store your deleted files c. You can make any one of them default recycle bin d. None of above


The term "push" and "pop" is related to the
Options: a. array b. lists c. stacks d. all of above  


The probability that a single bit will be in error on a typical public telephone line using 4800 bps modem is 10 to the power -3. If no error detection mechanism is used, the residual error rate for a communication line using 9-bit frames is approximately equal to
Options: 0.003,    0.009,    0.991,    0.999

Ans:B ,B

Which of the following commands is used to display your working directory?
Options: dir,    prompt $p$g,    pwd,    path

Ans:C ,C

Which command is used to sort the lines of data in a file in alphabetical order?
Options: sort,    sh,    st,    sort -r

Ans:A ,A

Page-Table length register (PTLR) indicates size of
Options: Page Table B. Paging File C. Main Memory D. Virtual Memory

Ans:– A ,

A characteristic of a distributed MIS structure is:
Options: computers supporting local DP operations,    a multiprocessing environment,    integrative sharing of the workload,    All of the above

Ans:C ,C

. Which of the following programming language were used in first generation computers?
Options: A) Machine language B) Assembly language C) Both of above D) None of above


Which of the following tool allows you to change your default X Window desktop?
Options: switchdesk,    intrc,    xinitre,    Xchange

Ans:A ,A

What command is used to count the number of files in the current directory by using pipes?
Options: ls | ws - c,    ls | wc - w,    ls | wc - l,    ls | wc

Ans:C ,C

Which language has been selected as the basis for the Japanese "fifth generation" computers.
Options: ALGOL,    COBOL,    PROLOG,    C

Ans:C ,C

. In MS Word, Ctrl+S is for …..
Options: a. Scenarios b. Size c. Save d. Spelling Check

Ans:–  C,–  C

The register which keeps track of the execution of a program and which contains the memory address of the instruction currently being executed is known as
Options: Index register,    Memory address register,    Program counter,    Instruction register

Ans:C ,C

The benefits of object-oriented modeling are which of the following?
Options: The ability to tackle more challenging problems,    Reusability of analysis, design, and programming results,    Improved communication between users, analysts, etc.,    All of the above.

Ans:D ,D

The intersection of a column and row in a spreadsheet is called a bon or
Options: Key,    Field,    Cell,    Menu

Ans:C ,C

Which of the following isn't a type of computer facility?
Options: decentralized,    centralized,    de-distributed,    distributed

Ans:C ,C

What is the maximum length a text field can be?
Options: a. 120 b. 255 c. 265 d. 75

Ans:ndash; b,ndash; b

Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,

The disadvantage of dynamic RAM over static RAM is
Options: higher power consumption,    variable speed,    need to refresh the capacitor charge every once in two milliseconds,    higher bit density

Ans:C ,C

A file produced by a spreadsheet 
Options: a. is generally stored on disk in an ASCII text fromat b. can be used as is by the DBMS c. both a and b d. none of the above


Hardware _____ memory is seldom used in modern computers.
Options: ROM,    RAM,    LIFO,    PROM

Ans:C ,C

Which of the following statements correctly assigns 12 to month using pointer variable pdt? #include<stdio.h> struct date { int day; int month; int year; }; int main() { struct date d; struct date *pdt; pdt = &d; return 0; }
Options: pdt.month = 12,    &pdt.month = 12,    d.month = 12,    pdt->month = 12

Ans:D ,D

Which printer uses a combination of laser-beam & electro photographic techniques.
Options: Laser printers,    Dot-Matrix,    Line printer,    Daisy wheel


An audit trail
Options: a . is used to make backup copies b . is the recorded history of operations performed on a file c . can be used to restore lost information d . none of the aobve

Ans:B, is the recorded history

The personnel who deals with the computer & its management put together are called
Options: Software,    Humanware,    Firmware,    Hardware


A directly accessible appointment calendar is a feature of a _____ resident package.
Options: CPU,    Memory,    Buffer,    ALU


For connecting modem, a computer must be equipped with a port that conforms to the RS-232 standard of the Electronic Industries Association of America. What do the letters 'RS' stand for?
Options: Recognised standard,    Random sequence,    Recommended standard,    Registered source

Ans:C ,C

In a _____ topology, if there are n devices in a network, each device has n - 1 ports for cables.
Options: ring,    bus,    star,    mesh

Ans:D ,D

Data Definition Language (DDL)
Options: describes how data are structured in the data base,    specifies for the DBMS what is required; the techniques used to process data,    determine how data must be structured to produce the user's view,    All of the above

Ans:A ,A

Which of the following systems implementation approaches should be used if you want to run the old system and the new system at the same time for a specified period?
Options: direct,    pilot,    parallel,    phased

Ans:C ,C

What is the purpose of inserting header and footer in document?
Options:  A) To enhance the overall appearance of the document, B) To mark the starting and ending of page, C) To make large document more readable, D) To allow page headers and footers appear on document when printed,


You are installing an IDE hard drive that will be your boot drive. Which is the correct order of steps that need to be followed?
Options: A. jumper properly, auto-detect(or configure manually) in CMOS, low level format, high level format, partition B. jumper properly, auto-detect(or configure manually) in CMOS, partition, high level format with / s switch C. jumper properly, partition, auto-detect(or configure manually in CMOS, high level format with /s switch D. jumper properly, auto-detect in CMOS, regular format

Ans:B ,jumper properly, auto-detect(or configure manually) in CMOS, partition, high level format with / s s

The institute for Certification of Computer Professionals (ICCP) currently administers the Certificate in Computer Programming (CCP) and the _____ examinations.
Options: CDP,    CISA,    DPMA,    ACM

Ans:A ,A

. Which of the following is the system tool?
Options: a. Backup b. Disk defragmenter c. Both of above d. File

Ans:6 – c ,6 – c

. The category of software most appropriate for controlling the design and layout of complex document like newsletters and brochure is:
Options: a. Word processing b. Computer aided design c. Web page authoring d. Desktop publishing

Ans: d, d

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

Ans:B ,B

. Why Drop Caps are used in document?
Options: a. To drop all the capital letters b. To automatically begin each paragraph with capital letter c. To begin a paragraph with a large dropped initial capital letter d. None of above

Ans: – C , – C

Communication circuits that transmit data in both directions but not at the same time are operating in
Options: a simplex mode,    a half-duplex mode,    a full-duplex mode,    an asynchronous mode

Ans:B ,B

In SQL, which command(s) is(are) used to change a table's storage characteristics?
Options: ALTER TABLE,    MODIFY TABLE,    CHANGE TABLE,    All of the above

Ans:A ,A

How many pairs of stations can simultaneously communicate on Ethernet LAN?
Options: 1,    2,    3,    multiple

Ans:A ,A

When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that?
Options:  A) From format menu choose bullets and Numbering and configure necessary setting, B) From Insert menu choose Page Number and specify necessary setting, C) Click on Page Number Format tool and specify required setting, D) All of above,


What is the smallest width of a column?
Options:  A) 0", B) 0.5", C) 1", D) 1.5", 


 Which is the menu command to recolor a picture on a slide
Options:  Insert -> Picture -> Recolor B.  Tools -> Picture -> Recolor C.  Format -> Picture -> Recolor D.  Edit -> Picture -> Recolor

Ans:– C ,

What is the use of Notes in slides?
Options: It will be displays at the time of Slide Presentation B. This is just Note about the slide       C. This is just for printing purpose only D. Notes cannot be inserted in Slides

Ans:– B ,

Which of the following device is used with an X.25 network to provide service to asynchronous terminals
Options: repeater,    bridges,    gateway,    Packet assembler/disassemble

Ans:D ,D