0. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

Options: Enclose the number is brackets B. Place the character T before the number C. Place the character TX before the number D. Apply the Text format in the cell and type the numbers

Ans: – D ,

Description: mcqquestions

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

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

What does the acronym RTS represent?
Options: Required to save,    Ready to start,    Request to send,    Right to separate

Ans:C ,C

DEC advertises that it helped to create "the world's first expert system routinely used in an industrial environment," called XCON or:
Options: PDP-11,    Rl,    VAX,    MAGNOM

Ans:B ,B

. While inserting a diskette into the diskette drive of a PC, the diskette’s label side should face

Options: A) East B) North C) South D) Up


. When was the company named IBM?
Options: A) 1914 B) 1924 C) 1975 D) None of above


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

Ans: B ,

. Page Down Key
Options: Moves the cursor one line down B. Moves the cursor one page down C. Moves the cursor one screen down D. Moves the cursor one paragraph down

Ans:– C ,

Data collection terminals gather data for use by the
Options: inventory subsystem,    cost subsystem,    production subsystem,    All of the above

Ans:D ,D

How many pins on a VGA?
Options: 15.,    9,    25,    32

Ans:A ,A

.   Which of the following should be used with the mouse when you want to draw a perfect shape?
Options: a. The spacebar b. The alt key c. The ctrl key d. The shift key

Ans:6 – D ,6 – D

. When you rename a file five times then the number of file in the disk is
Options: a. 1 b. 2 c. 3 d. 5

Ans:1 – a ,1 – a

Computer Keyboard can be classified as __________ Device?
Options: A. Memory B. Input C. Output D. Storage


. Which of the following pane is not available in Task Pane?
Options: a.  Getting Started b.  Clip Art c.  Word Art d.  Search Results

Ans:6 – C ,6 – C

In SQL, which command is used to remove a stored function from the database?

Ans:C ,C

. Search engines use a(n) __________ to automatically index sites.
Options: a. crawler b. query c. enterprise d. sitebuilder

Ans:1 – a ,1 – a

A PCMCIA measuring 10.5mm is what type?
Options: type 1,    type 2,    type 1 and 3,    type 3

Ans:D ,D

What is the shortcut key to Close Active Document in Microsoft Word?
Options: Ctrl + F4 B. Shift + F4 C. Ctrl + Shift + F4 D. None of above

Ans:– A ,

What is the impedance of a circuit composed of a 100 ohm resistor connected in parallel with an inductor that has a reactance of 200 W?
Options: 77.7 ohm,    89.3 ohm,    88.8 ohm,    224 ohm

Ans:B ,B

.   Which type of font is best suitable for large amount of text?
Options: a. serif fonts b. sans serif fonts c. text fonts d. picture fonts

Ans:4 – A ,4 – A

Suppose you had an incurable computer virus and decided to wipe out all the data and partitions on your hard drive and reformat. What is the order in which you must delete the partitions?
Options: Extended, Logical, Primary,    Primary, Extended, Logical,    Logical, Extended, Primary,    Logical, Primary, Extended

Ans:C ,C

To build a modularized kernel, the kernel-headers and kernel-source packages must first be installed. Where will you find the kernel-headers and kernel-source?
Options: /usr/local,    /usr/src/linux,    /usr/sre/redhat,    /usr/bin

Ans:B ,B

The ALU and control unit of most of the microcomputers are combined and manufacture on a single silicon chip. What is it called?
Options: a . monochip b . microprocessor c. ALU d . control unit 


. Find can be used to
Options: a. Locate a program b. Locate a document c. Locate a network computer d. All of above

Ans:7 – d ,7 – d

Which is NOT typically a Field Replaceable Unit?
Options: System ROM,    Power supply,    System chasis,    Video controller

Ans:C ,C

The ideal solution is to have a system coordinator who will interface with the engineering and manufacturing managers, as well as the:
Options: finance manager,    president,    marketing manager,    MIS manager

Ans:D ,D

Disadvantages of File systems to store data is:
Options: Data redundancy and inconsistency B. Difficulty in accessing data C. Data isolation D. All of the above

Ans:– D ,

Which of the following tasks is not suited for sequential processing by a computer?
Options: Preparing of mailing labels,    Processing payroll cheques,    Accounting for credit card purchases,    Inventory control

Ans:D ,D

Which of the following is not a component of a data warehouse?
Options: Data extraction/cleaning/preparation programs,    Data warehouse data,    Data metadata,    None of the above are data warehouse components.

Ans:C ,C

A zener diode has a voltage of 10 V and a current of 20 mA. What is the power dissipation?
Options: 200 mW,    300 mW,    20 mW,    10 mW

Ans:A ,A

. Which of the following statements about PivotChart View is NOT true?
Options: a. It is used to graphically summarize and analyze data in a table, query, or form. b. It can be used to view different levels of detail or to specify custom layout. c. It displays field values that can be switched for different views of data. d. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

Ans:5 – d ,5 – d

Which of the following is not an Input Device?
Options: A. Touch Screen B. Optical Scanners C. Touch Pad D. Mouse Pad


The procedure for evaluating the relative performance of different computers, is done by the process called
Options: batch processing,    sequential processing,    bench marking,    All of the above

Ans:C ,C

What command is used to copy a file?
Options: tar,    cpio,    cp,    copy

Ans:C ,C

Which of the following statements concerning business rules is true?
Options: It should be complex.,    It should not be convertible to computer code.,    It may include restrictions.,    All of the above.

Ans:C ,C

A financial modeling package for a PC is similar to a spreadsheet package, but it can handle larger data files than a spreadsheet, and it has a built-in _____ seeking function.
Options: aim,    target,    goal,    plan

Ans:C ,C

A common data base is one requisite for converting CAD and CAM to CIM. Another is that:
Options: the system must make provision for new techniques.,    there should be a common 3-D part description system.,    the user must have access to both hardware and software,    technical assistance must be provided to the user.

Ans:B ,B

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

Ans:C ,C

Which one of the following statements is true?
Options: The secondary voltage for a step-down power transformer is greater than the primary voltage,    The secondary current for a step-down power transformer is greater than the primary voltage,    Parallel RLC circuit operated below its resonant frequency,    purely resistive circuit

Ans:B ,B

. Which mode loadsminimal set of drivers when starting Windows?
Options: a. Safe Mode b. Normal Mode c. VGA Mode d. Network Support Mode

Ans: a, a

Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:C ,C

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 ,D

Which of the following can be accesses by transfer vector approach of linking?
Options: External data segments,    External subroutines,    Data located in other procedures,    All of the above

Ans:B ,B

. What does the expression [detail] ! [product] * 1.30 do?
Options: a. multiplies the contents of detail and product fields by 1.3 b. First divides detail by product and then multiplies by 1.3 c. multiplies the contents of detail in the product table by 1.3 d. multiplies the contents of product in the detail table by 1.3

Ans:– d,– d

What voltage does a 586 system use?
Options: +12 volts,    + 5 volts,    + 8 volts,    +3.3 volts

Ans:B ,B

Information concerning the probability distribution of a profit rate can be generated by using:
Options: electronic spreadsheet,    artificial intelligence,    time-series analysis,    management science techniques

Ans:D ,D

. Which among the following are the best tools for fixing the errors?
Options: a. Fdisk b. Scandisk c. CHKDSK d. Fixdisk

Ans:1 – b ,1 – b

The transistor has a current gain of 175. If the base current is 0.1 mA, what is the collector current?
Options: 1750 mA,    17.5 mA,    175 mA,    1.75 mA

Ans:B ,B

Which of the following is being investigated as a means of automating the creation of a knowledge base?
Options: automatic knowledge acquisition,    simpler tools,    discovery of new concepts,    All of the above

Ans:D ,D

What is the inductive reactance of a 0.1-H coil that is operating at 1000 Hz?
Options: 100 Ohm,    Less than 1 Ohm,    628 Ohm,    444 Ohm

Ans:C ,C

Which of the following special shell variables is used to process number of the current shell?
Options: $!,    $$,    $0,    $*

Ans:B ,B

Which of the following store command to retrieve data from database?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:ndash; c,ndash; c