How to remove the unwanted action from recorded macro without recording the whole macro again?


Options: By using the Find and Edit Action Option B. By clicking on the Refresh button in the Macro toolbar C. By edit the macro in the Visual Basic Editor D. Macro cannot be edited.

Ans:– C ,






More MS-Excel Related questions:


Which of the following is true concerning a global transaction?
Options: The required data are at one local site and the distributed DBMS routes requests as necessary.,    The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.,    The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.,    The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Ans:B ,B


Router operates in which layer of OSI Reference Model?
Options:  Layer 1 (Physical Layer) B.  Layer 3 (Network Layer) C.  Layer 4 (Transport Layer) D.  Layer 7 (Application Layer)

Ans: – B ,


What can greatly reduce TCP/IP configuration problems?
Options: WINS Server,    WINS Proxy,    DHCP Server,    PDC

Ans:C ,C


A binary relationship cannot be which of the following?
Options: One-to-One,    One-to-Many,    Many-to-Many,    Zero-to-Zero

Ans:D ,D


. Oncetext has been cut to the clipboard, you can .....that text into another document
Options: a. Paste b. Copy c. Transfer d. None of the above

Ans: a, a


Inventory is also referred to as:
Options: stock,    warehouse capacity,    materials,    materials in hand

Ans:A ,A


52. Ctrl + B
Options: a. Search the selected text b. Paste the selected text c. Bold the selected text d. Open the specified file

Ans:–  C ,–  C


. What is the quickest way to select entire worksheet?
Options: a. Choose Edit -> Select all from the Menu b. Click on the first column, press Ctrl, and then click on the last column c. Click on the first column, press Shift, and then click on the last column d. Click on the rectangle box on the upper left corner where column headings and row headings meet

Ans:– d,– d


The merging of a free electron and a hole is called
Options: Covalent bonding,    Lifetime,    Recombination,    Thermal energy

Ans:C ,C


What is the name of the earliest calculating machine which was based on concepts found in modern computers but was unfortunately never built?
Options: Babbage's Difference Engine,    Pascal's Adder,    Leibnitz's Multiplier,    Differential Analyser

Ans:A ,A


Computing systems can provide strategic information by
Options: making decision analysis possible,    providing corporate models for long-range planning,    causing managers to think,    All of the above

Ans:D ,D


. It is the default folder for many Windows Applications to save your file
Options: a. My Document b. My Pictures c. Documents and Settings d. My Computer

Ans:7 – a ,7 – a


Conversion method in which users, being used to an old system, continue to use the old system, along with the new system, is
Options: Multiprocessing,    Multitasking,    Parallel run,    All of the above

Ans:C ,C


What is a slide-title master pair?
Options: a. The title area and text area of a specific slide b. a slide master and title master merged into a single slide c. A slide master and title master for a specific design template d. All of above

Ans: – C , – C


The disk concept for reducing time lost from rotational delay is:
Options: fixed block addressing,    cylinder, track, sector data,    staggered addressing,    graduated block identification

Ans:C ,C


. Netscape navigator is a
Options: a. Browser b. Compose c. Editor d. None of these

Ans:7 – a ,7 – a


UDP is:
Options: Not a part of the TCP/IP suite,    Connection oriented and unreliable,    Connection orientated and reliable,    Connectionless and unreliable

Ans:D ,D


. Which of the following computer implemented binary numbers, perform calculations using electronics and implemented separate computation and memory for the first time?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:B,B


In cyclic redundancy checking, the divisor is _____ the CRC.
Options: the same size as,    one bit less than,    one bit more than,    two bits more

Ans:C ,C


In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of register?
Options: absolute mode,    indirect mode,    immediate mode,    index mode

Ans:D ,D


A base register table
Options: is a term that refers to the control programs of an operating system,    is used to remember which of the general-purpose registers are currently available as base registers, and what base addresses they contain,    allows multiple programs to reside in separate areas of core at the same time,    allows the programmer to write base registers and displacements explicitly in the source program

Ans:B ,B


An operating system intended for use on microprocessor based systems that support a single user is
Options: PC-DOS,    MS-DOS,    UNIX,    CP/M

Ans:D,(Danswer


Which of the following is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,


An attribute that names or identifies entity instances is a(n):
Options: entity.,    attribute.,    identifier.,    relationship.

Ans:C ,C


. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b


Which of the following types of connections can use full duplex? Hub to hub Switch to switch Host to host Switch to hub Switch to host
Options: 1, 2 and 4,    3 and 4,    3 and 5,    2, 3 and 5

Ans:D ,D


How would you allow device drivers and TSR's to be loaded into Upper Memory Blocks?
Options: DOS=High,    Devicehigh=,    Loadhigh=,    DOS=UMB

Ans:D ,D


A general purpose single-user microcomputer designed to be operated by one person at a time is
Options: Special-purpose computer,    KIPS,    M,    PC

Ans:D,(Danswer


Which is a Common-Business oriented language.
Options: SNOBOL,    BASIC,    COBOL,    C

Ans:C ,C


The first practical commercial typewriter was invented in 1867 in the United States by
Options: Christopher Latham Sholes,    Carlos Glidden,    Samuel Soule,    All of the above

Ans:D,D


Which type of computers uses the 8-bit code called EBCDIC?
Options: A) Minicomputers B) Microcomputers C) Mainframe computers D) Super computer

Ans:-C,-C


What is the maximum distance running the lowest data rate for 802.11g?
Options: About 100 feet,    About 175 feet,    About 300 feet,    About 350 feet

Ans:C ,C


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


Virtual Memory is A)  Extremely Large Main memory B)  Extremely Large Secondary memory C)  An illusion of extremely large main memory D)  An illusion of extremely large secondary memory
Options:

Ans:– C ,


What tool is used to test serial and parallel ports?
Options: high volt probe,    cable scanner,    loop backs (wrap plugs),    sniffer

Ans:C ,C


Which provides the fastest access to large video files?
Options: Optical drives,    IDE hard drives,    SCSI hard drives,    EIDE hard drives

Ans:C ,C


Your router has the following IP address on Ethernet0: 172.16.2.1/23. Which of the following can be valid host IDs on the LAN interface attached to the router? 172.16.1.100 172.16.1.198 172.16.2.255 172.16.3.0
Options: 1 only,    2 and 3 only,    3 and 4 only,    None of the above

Ans:C ,C


Molecule is
Options: The smallest particle of a substance that retains the properties of that substance,    A atom that has a shortage of electrons in its outer orbit,    A atom that has an excessive number of electrons in its outer orbit,    A atom that flows whenever there is an imbalance of electrical charges between two points

Ans:A ,A


Which of the following devices would be classified as a robot by the Robot Institute of America?
Options: Automobile,    Pick-and-place manipulator,    Artificial hand,    All of the above

Ans:B ,B


The box on the chart that contains the name of each individual record is called the ________.
Options: cell B. title C. axis D. legend

Ans:– D ,


A monitor's _____ is the distance between the holes in the mask behind the screen. This helps determine how sharp the dots appear.
Options: refresh rate,    dot pitch,    resolution,    color depth

Ans:B ,B


What does the port number in a TCP connection specify?
Options: It specifies the communication process on the two end systems B. It specifies the quality of the data & connection C. It specify the size of data D. All of the above

Ans:– A ,


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


The applications in the Strategic Computing Program include:
Options: battle management,    autonomous systems,    pilot's associate,    All of the above

Ans:D ,D


Which command will be used with vi editor to append text at end of line?
Options: A,    a,    i,    I

Ans:A ,A


Which of the following tool is used to partition your hard drive?
Options: mkfs,    fdisk,    fsck,    mount

Ans:B ,B


. Who invented Mark I?
Options: A) Howard Aikin B) J. P. Eckert C) John Mauchley D) John v. Atanasoff

Ans:9-A,9-A


If a load resistance is 1 kW, a stiff current source has a resistance of
Options: At least 10 Ohm,    Less than 10 Ohm,    More than 100 k Ohm,    Less than 100 k Ohm

Ans:C ,C


For speech understanding systems to gain widespread acceptance in office automation, they must feature:
Options: speaker independence,    speaker dependence,    isolated word recognition,    All of the above

Ans:A ,A


. Which one of the following input device is user-programmable?
Options: A) Dumb terminal B) Smart terminal C) VDT D) Intelligent terminal

Ans:D,D

www.000webhost.com