. A smart tag will be removed from a cell when


Options: the cell is moved B. the cell is hidden C. the data in the cell is changed or deleted D. the formatting of the cell is changed

Ans:– C ,


Description: mcqquestions

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

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


What is the name of the system which deals with the running of the actual computer and not with the programming problems?
Options: Operating system,    Systems program,    Object program,    Source program

Ans:B ,B


If in a computer, 16 bits are used to specify address in a RAM, the number of addresses will be
Options: A) 216 B) 65,536 C) 64K D) Any of the above

Ans:-B,-B


A network administrator views the output from the show ip route command. A network that is advertised by both RIP and IGRP appears in the routing table flagged as an IGRP route. Why is the RIP route to this network not used in the routing table?
Options: IGRP has a faster update timer.,    IGRP has a lower administrative distance.,    RIP has a higher metric value for that route.,    The IGRP route has fewer hops.

Ans:B ,B


in which year was UK’s premier computing event called ?The which computer? started?
Options: A) 1980 B) 1985 C) 1986 D) 1987

Ans:-A,-A


What is meant by a dedicated computer?
Options: a . which is used by one person only b . which is assigned to one and only one task c . which does one kind of software d . which is meant for application software only

Ans:3.b,3.b


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

Ans:0.a,0.a


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

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


. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Options: a. formula b. format c. layout d. record

Ans:3 – d ,3 – d


In a computer with an eide adapter, where should you connect an ATA CD-ROM drive?
Options: on the floppy bus,    on the primary IDE,    on the secondary IDE,    on the SCSI bus

Ans:C ,C


Quantitative evaluation of new products assures that
Options: the important factors receive management attention,    the factors are weighted according to their relative importance,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


. Which is an example of a function?
Options: a. =add(A1:A2) b. =A1+A2 c. =SUM(A1:A2) d. A1+A2

Ans:– c,– c


For a memory system, the cycle time is
Options: same as the access time,    longer than the access time,    shorter than the access time,    submultiple of the access time

Ans:B ,B


The term used to represent the recycling of unused memory is:
Options: garbage collection,    diagnostic routine,    memory dump,    direct memory access

Ans:A ,A


. Which bar is usually located below that Title Bar that provides categorized options?
Options: a. Menu bar b. Status Bar c. Tool bar d. Scroll bar

Ans: –  A , –  A


A device or system not directly connected to the CPU is
Options: On-line,    Keyboard,    Memory,    Off-line

Ans:D ,D


Where can you change the vertical alignment?
Options: a. Formatting toolbar b. Paragraph dialog box c. Page Setup dialog box d. Standard toolbar

Ans:– C,– C


Which one of the following is most likely used for measuring the rate of electron flow?
Options: Voltmeter,    Ammeter,    Wattmeter,    Ohmmeter

Ans:B ,B


The load and index is which of the following?
Options: A process to reject data from the data warehouse and to create the necessary indexes,    A process to load the data in the data warehouse and to create the necessary indexes,    A process to upgrade the quality of data after it is moved into a data warehouse,    A process to upgrade the quality of data before it is moved into a data warehouse

Ans:B ,B


The memory which is programmed at the time it is manufactured
Options: ROM,    RAM,    PROM,    EPROM

Ans:A ,A


Which one of the following statements most accurately reflects the nature of ac power?
Options: The current in an ac circuit flows in one direction, but changes value periodically,    The current in an ac circuit flows in one direction at a steady level,    The current in an ac circuit changes direction periodically,    The current in an ac circuit flows in two directions at the same time

Ans:C ,C


Which of the following is not a database object?
Options: a. Tables b. Queries c. Relationships d. Reports

Ans:dash; c,dash; c


The primary interactive method of communication used by humans is:
Options: reading,    writing,    speaking,    All of the above

Ans:C ,C


. To make file in MS Dos we need command
Options: a. Copy b. Copy con c. MD d. Make File

Ans:0 – b ,0 – b


When did John Napier develop logarithm?
Options: 1416 B. 1614 C. 1641 D. 1804

Ans:– B ,


. How can you remove tab stop markers from ruler?
Options: a. Double click the tab marker and choose Clear All b. Drag the tab stop marker out of the ruler c. Right click the tab stop marker and choose remove d. All of above

Ans:– B,– B


The methods used by COBOL to define that structure of a data item in terms of characters, digits, etc. is
Options: Password,    Pointer,    Picture,    Overlay

Ans:C ,C


Which of the following is not considered to be a basic element of an enterprise-class database system?
Options: Users,    Database applications,    DBMS,    COBOL programs

Ans:D ,D


When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options: Data source,    Driver,    Driver manager,    OLE DB

Ans:C ,C


. Which of the following separates primary file and extension is
Options: a. Dot b. Period c. Point d. All of the above

Ans:9 – d ,9 – d


. You can open the Sort dialog box by choosing Sort from the ….. menu
Options: a. View b. Format c. Tools d. Data

Ans:– d,– d


. What is the symbol for dividing? A ./ B. % C. & D. #
Options: A ./ B. % C. & D. #

Ans:– A ,/


If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options: Data modeling,    Database design,    Metadata,    All of the above.

Ans:B ,B


Which of the following input/output devices is not associated with personal computers?
Options: mice,    color monitors,    punched cards,    dot-matrix printers

Ans:C,C


. Shimmer, Sparkle text, Blinking Background etc. are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – D , – D


To create a new table, in which method you don’t need to specify the field type and size?
Options: a. Create table in Design View b. Create Table using wizard c. Create Table by Entering data d. All of above

Ans:dash; c,dash; c


What is the name of the reading device which mades use of photosensors and laser technologies to interpret printed, typed or even hand-written data directly from the source documents?
Options: MICR,    OCR,    Mark-sensing device,    ATM

Ans:B ,B


A condition that led to the development of databases was
Options: a demand for more data to support information needs,    an increase in the amount of data handled by organizations,    the proliferation of data files,    All of the above

Ans:D ,D


. Holding down the Shift key and rotate the image will rotate in increments of
Options: a. 10 degrees b. 15 degrees c. 20 degrees d. 25 degrees

Ans:8 – B ,8 – B


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


Computers in a LAN can be interconnected by radio and infrared technologies.
Options: Wireless LANs,    Network Topologies,    Multiplexer,    Modem

Ans:A ,A


Stephanie is in charge of a small network and wants to make it simple but secure. The users want to have full control over their data and still be able to share data with the rest of the office. The networking knowledge of the office staff is basic. Which network(s) would be the best for Stephanie to set up?
Options: Peer-to-peer,    Master domain,    Server-based,    WAN

Ans:C ,C


Which of the following are disadvantages of using NAT? Translation introduces switching path delays. Conserves legally registered addresses. Causes loss of end-to-end IP traceability. Increases flexibility when connecting to the Internet. Certain applications will not function with NAT enabled. Reduces address overlap occurrence.
Options: 1, 3 and 5,    3 and 4,    2, 4 and 5,    1 and 3

Ans:A ,A


. __________ are documents that when filled in create records.
Options: a. Forms b. Reports c. Tables d. Queries

Ans:7 – a ,7 – a


Which of the following is not a key component of the evaluation process in building a DSS?
Options: criteria for evaluation,    means of measuring system-development time spent on the project,    means of monitoring the progress of the DSS,    formal review process

Ans:B ,B


A report form
Options: appears on the computer monitor during data entry,    is used during report generation to format data,    both (a) and (b),    All of the above

Ans:B ,B


. 1 nibble equals to
Options: A) 1 bits B) 2 bits C) 4 bits D) 8 bits

Ans:8-C,8-C


For a type 2 system, the steady-state:
Options: error for a step input is always zero,    error for a velocity input is always zero,    input for acceleration input is always non-zero,    All of the above

Ans:D ,D


HDLC (High-level Data Link Control) is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique for multiple-access transmission media,    a very common bit-oriented data link protocol issued by ISO.,    network access standard for connecting stations to a circuit-switched network

Ans:C ,C


What command is used to display a file contents in octal form?
Options: oct,    of,    od,    cd

Ans:C ,C

www.000webhost.com