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


The magnetic storage chips used to provide nonvolatile direct access storage of data and that have no moving parts are known as
Options: Magnetic core memory,    Magnetic tape memory,    Magnetic disk memory,    Magnetic bubble memory

Ans:D ,D


A 6-MHz channel is used by a digital signaling system utilizing 4-level signals. What is the maximum possible transmission rate?
Options: 1.5 Mbaud/sec,    6 Mband/sec,    12 Mbaud/sec,    24 Mbaud/sec

Ans:C ,C


We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
Options: dirty data,    inconsistent data,    non-integrated data,    a "wrong format" problem

Ans:C ,C


Sensitivity Analysis is the ability to perform:
Options: What-if analysis,    If-so analysis,    What-then analysis,    And-or analysis

Ans:A ,A


. A Smart Tag can be set using the _____ tab in the property sheet.
Options: a. Format b. Tag c. View d. Data

Ans:9 – d ,9 – d


Can you tell what passes into and out from the computer via its ports?
Options: Data,    Bytes,    Graphics,    Pictures

Ans:B,B


The first step in the problem-solving process is to _____.
Options: Plan the algorithm,    Analyze the problem,    Desk-check the algorithm,    Evaluate and modify (if necessary) the program

Ans:B ,B


The primary advantage of key-to-tape data-entry systems is:
Options: A large percentage of editing can be performed at the time of data entry,    Key verification is easily performed,    The tape is reusable,    Keying errors can be detected as they occur

Ans:C ,C


The rms value of a sine waveform is:
Options: the number of cycles completed in one second,    the time required to complete one full cycle,    equal to 0.707 times the peak amplitude,    equal to 1.41 times the peak amplitude

Ans:C ,C


. Intel corporation produces chips for which computers?
Options: A) IBM PCs B) Apple/Macintosh PCs C) Both of above D) None of above

Ans:A,A


An encoder:
Options: is used to send telegraph signals,    converts an input to a binary number,    converts a binary number to a decimal number.,    can have only four keys

Ans:B ,B


In order to edit a chart, you can
Options: a. Triple click the chart object b. Click and drag the chart object c. Double click the chart object d. Click the chart object

Ans: – C , – C


Which command is used with file named 'note' to remove the executable permission from the user and assign read permission to the group and others?
Options: chmod u-x, go+r note,    chmod go+r, u+x note,    chmod g-x, uo+r note,    chmod go+x, u-x note

Ans:A ,A


. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Options: a.  work sheet b.  chart sheet c.  module sheet d.  data sheet

Ans:– d,– d


Assembler language
Options: is usually the primary user interface,    requires fixed-format commands,    is a mnemonic form of machine language,    is quite different from the SCL interpreter

Ans:C ,C


Which device is on IRQ 6?
Options: Keyboard,    IDE,    Floppy drive,    Video card

Ans:C ,C


Report generators are used to
Options: store data input by a user,    retrieve information from files,    answer queries,    both (b) and (c)

Ans:D ,D


What does DMA stand for?
Options: Distinct Memory Access B. Direct Memory Access C. Direct Module Access D. Direct Memory Allocation

Ans:– B ,


“Ctrl + Right Arrow” is used to
Options: a. Moves the cursor one word right b. Moves the cursor end of the line c. Moves the cursor end of the document d. Moves the cursor one Paragraph down

Ans:–  A,–  A


Ethernet and Token-Ring are the two most commonly used network architectures in the world. Jim has heard of the different topologies for networks and wants to choose the architecture that will provide him with the most options. Which of the following would that be? Choose the most correct answer.
Options: Token-Ring because it currently can run at both 4Mbps and 16Mbps. This means that it can be used in any topology,    Ethernet, because it is cabled using fiber-optic cable,    Token-Ring, because it uses a MAU,    Ethernet, because it can be set up with most topologies and can use multiple transfer speeds

Ans:D ,D


From which menu you can insert Header and Footer?
Options:  A) Insert Menu, B) View Menu, C) Format menu, D) Tools Menu,

Ans:-B,-B


Which is the earliest and most widely used shell that came with the UNIX system?
Options: C shell,    Korn shell,    Bourne shell,    Smith shell

Ans:C ,C


. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be:
Options: a. word processing b. spreadsheet c. database d. graphics

Ans:– b,– b


What does MSCDEX.EXE do?
Options: Configures hard drives,    it's a SCSI driver,    BIOS setup,    it's a CD-ROM DOS driver

Ans:D ,D


Business Intelligence (BI) reporting analyses can be performed using ________ .
Options: standard SQL only,    extensions to SQL only,    OLAP only,    both standard SQL and extensions to SQL

Ans:A ,A


The equipment with which the computer talks to its users is called a
Options: word processor,    peripheral,    software,    diskette

Ans:B,B


MRP stands for
Options: management resource planning,    marketing research planning,    manufacturing resource planning,    material requirements planning

Ans:D ,D


The SQL -92 wildcards are ____ and ____ .
Options: asterisk (*); percent sign (%),    percent sign (%); underscore (_),    underscore(_); question mark (?),    question mark (?); asterisk (*)

Ans:B ,B


What is the result of segmenting a network with a bridge (switch)? It increases the number of collision domains. It decreases the number of collision domains. It increases the number of broadcast domains. It decreases the number of broadcast domains. It makes smaller collision domains. It makes larger collision domains.
Options: 1 and 5,    2, 3 and 5,    3, 4 and 6,    1, 3 and 6

Ans:A ,A


Design qualifications do not normally include
Options: Output requirements,    Input and storage requirements,    Control provisions,    Blueprints

Ans:D ,D


. Ctrl + R
Options: Re-Open the last closed document B. Re-Print the last printed page C. Re-Apply the last paragraph formatting D. Right align the selected Paragraph

Ans:– D ,


One of the major components of a PC is the Central Processing Unit (CPU) which can be best described as:
Options: The device that sends the monitor signals telling it what to display,    The area that regulates all of the system power usage,    The area where ail the of the Basic input/output routines are stored,    The area where all of the processing takes place

Ans:D ,D


ENIAC (Electronic Numerical Integrator and Calculator) had huge advantage over Mark I because it used electronic valves in place of the electromagnetic switches. In the beginning, ENIAC was used for calculating the path of artillery shells. For which other was weapon design was it utilized?
Options: hydrogen bomb,    atom bomb,    agnimissile,    fighter aircraft

Ans:A,A


. Which type of field is incremented automatically?
Options: a. Auto Elevate b. AutoNumber c. Auto Increment d. Auto Value

Ans:– b,– b


A technique for displaying applications where complex 3-D geometric are required for the exteror shall of a product is called:
Options: solid modeling,    2-D modeling,    3-D modeling,    surface modeling

Ans:D ,D


. How many numbers could ENIAC store in its internal memory
Options: A) 100 B) 20 C) 80 D) 40

Ans:B,B


. Desktop is a
Options: a. Provides workspace b. Screen saver c. Display program d. Working with my document

Ans:0 – a ,0 – a


. 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

Ans:3-A,3-A


An operational system is which of the following?
Options: A system that is used to run the business in real time and is based on historical data.,    A system that is used to run the business in real time and is based on current data.,    A system that is used to support decision making and is based on current data.,    A system that is used to support decision making and is based on historical data.

Ans:B ,B


What will you do to treat the constant 3.14 as a long double?
Options: use 3.14LD,    use 3.14L,    use 3.14DL,    use 3.14LF

Ans:B ,B


What command is used to display the characteristics of a process?
Options: au,    ps,    du,    pid

Ans:B ,B


. Ellipse Motion is a predefined ________
Options: a. Design Template b. Color Scheme c. Animation Scheme d. None of these

Ans:5 – C ,5 – C


Name the two persons who were the first to develop a model of the microprocessor chip.
Options: Marcian Ted Hoff,    Victor Poor,    Harry pyle,    Both (b) and (c)

Ans:D ,D


Which of the following is a machine language instruction?
Options: ADD 5,    10001101,    GOTO XOUT,    All of the above

Ans:B ,B


. In a junction table, the _____ field consists of the foreign key from both the linked tables.
Options: a. first defined b. last defined c. foreign key d. primary key

Ans:7 – c ,7 – c


Which of the following digits are known as the sub-address digits (for use by the user) of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:D ,D


Which of the following is not a basic configuration used in a data communication network?
Options: computer/peripheral-device configuration,    computer-to-computer commu¬nication,    computer to front-end processor communication,    communication through a data switch

Ans:C ,C


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 register in which of the following that holds the current instruction while it is being executed is called instruction register.
Options: ALU,    CPU,    Memory,    Address

Ans:B ,B


The most common input device used today is
Options: Motherboard,    Track ball,    Scanner,    Mouse

Ans:A,Motherboard

www.000webhost.com