. Which option allows you to Bold all the negative values within the selected cell range:

Options: Zero Formatting B. Conditional Formatting       C. Compare Formatting D. Negative Formatting

Ans:– B ,

Description: mcqquestions

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

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

Which is the correct for MIS:
Options: communication process wherein information is recorded, stored, processed and retrieved for managerial decision-making,    communication process wherein data is recorded, stored, processed and retrieved for managerial decision-making,    communication process wherein data is converted into information,    All of the above

Ans:B ,B

. Charles Babbage was awarded by Royal Society for his
Options: A) Difference Engine B) Analytic Engine C) Binary System in Analytic Engine D) His concept of input, mill, output and storage


A stack is
Options: a . an 8-bit register in the microprocessor b . a 16-bit register in the microprocessor c . a set of memory locations in R/WM reserved for storing information temporarily during the execution of computer d . a 16-bit memory address stored in the program counter


The acronym HDI stands for:
Options: Half duplex interface,    Hard disk interface,    Head to disk interference,    Help desk interference

Ans:D ,D

What will be the output of the program ? #include<stdio.h> int main() { enum days {MON=-1, TUE, WED=6, THU, FRI, SAT}; printf("%d, %d, %d, %d, %d, %d\n", ++MON, TUE, WED, THU, FRI, SAT); return 0; }
Options: -1, 0, 1, 2, 3, 4,    Error,    0, 1, 6, 3, 4, 5,    0, 0, 6, 7, 8, 9

Ans:B ,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

Which of the following in true regarding Null Value?
Options: Null = 0 B. Null < 0 C. Null > 0 D. Null <> 0

Ans:– D ,

. In the third Generation of computers

Options: A) Distributed data processing first became popular B) An operating system was first developed C) High level procedural language were first used D) Online real time systems first become popular


. The __________ key will launch the Start button.
Options: a. esc b. shift c. Windows d. Shortcut

Ans:4 – c ,4 – c

Finding the location of the element with a given value is:
Options: a. Traversal b. Search c. Sort d. None of above  


Machine language is
Options: A) Machine dependent B) Difficult to program C) Error prone D) All of above


. Selecting text means, selecting?
Options: a word B. an entire sentence C. whole document D. any of the above

Ans: – D ,

. Which command will be used to display only the file name and extensions in wide format?
Options: a. Dir/b b. Dir A: c. Dir/s d. Dir/w

Ans:8 – d ,8 – d

Client/server security includes which of the following?
Options: Physical security,    Change control security,    Measures taken to secure all systems,    All of the above.

Ans:D ,D

The _____ layer is the layer closest to the transmission medium.
Options: transport,    network,    data link,    physical

Ans:D ,D

....... transforms one interface into other interface
Options: a. Program b. Software c. Data d. None

Ans:1 – b ,1 – b

Large computer system typically uses:
Options: Line printers,    Ink-jet printers,    Dot-matrix printers,    Daisy wheel printers

Ans:A ,A

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,


Devices on one network can communicate with devices on another network via a
Options: file server,    utility server,    printer server,    gateway

Ans:D ,D

. In MS Access “Lookup Wizard” is used to
Options: a. to select from previous values b. to select values from Excel Sheet c. to select value from another table d. Not a valid Data Type

Ans:– c,– c

AutoCorrect was originally designed to replace _________ words as you type.
Options: a. short, repetitive b. grammatically incorrect c. misspelled d. none of the above

Ans:– C,– C

A technique used by codes to convert an analog signal into a digital bit stream is known as
Options: Pulse code modulation,    Pulse stretcher,    Query processing,    Queue management


One approach to standardizing storing of data
Options: MIS,    structured programming,    CODASYL specifications,    All of the above

Ans:C ,C

A screen element of MS Word that is usually located below the title bar that provides categorized options is
Options:  A) Menu mar, B) Tool Bar, C) Status Bar, D) All of the above, 


. The ability of a database to grow as the data tracking needs grow is its __________.
Options: a. scalability b. expandability c. maintainability d. platform-independence

Ans:8 – a ,8 – a

High-level languages are not concerned with computer but with
Options: Assembler,    Machine code,    Compiler,    All of the above

Ans:A ,A

Virtual memory is
Options: simple to implement,    used in all major commercial operating systems,    less efficient in utilization of memory,    useful when fast I/O devices are not available

Ans:B ,B

Which of the following languages is often translated to pseudo code?
Options: Assembly,    FORTRAN,    PASCAL,    BASIC

Ans:C ,C

.   You can add multiple subordinates to a position by
Options: a. Clicking the subordinate button as you press and hold shift b. Clicking the subordinate button each and every time you add a subordinate c. Clicking the subordinate button as many times as the desired boxes d. All of above

Ans:4 – D ,4 – D

Options: A) Universal Automatic Computer B) Universal Array Computer C) Unique Automatic Computer D) Unvalued Automatic Computer


. which of the following should you use if you want all the slides in the presentation to have the same look?
Options: a. The slid layout option b. The add a slide option c. Outline view d. A presentation design template

Ans:5 – D ,5 – D

What is split horizon?
Options: Information about a route should not be sent back in the direction from which the original update came.,    It splits the traffic when you have a large bus (horizon) physical network.,    It holds the regular updates from broadcasting to a downed link.,    It prevents regular update messages from reinstating a route that has gone down.

Ans:A ,A

Which of the following is not a font style?
Options: a. Bold b. Italics c. Regular d. Superscript

Ans:– D,– D

. A tiny dot of light on the monitor is called
Options: a. Silicon chip b. Optical illusion c. Icon d. Pixel

Ans:4 – d ,4 – d

. Which of the following professions has not been affected by personal computers?
Options: A) Medical B) Clerical and law C) Accounting D) None of the above


Lower-level managers make day-to¬day ______ decisions to schedule and control specific tasks.
Options: operational,    decision,    success,    simulation

Ans:A ,A

In computer terminology a compiler means
Options: a person who computes source programs,    the same thing as a programmer,    key punch operator,    a program which translates source program into object program

Ans:D ,D

Four necessary conditions for deadlock to exist are: mutual exclusion, no-preemption, circular wait and
Options: hold and wait,    deadlock avoidance,    race around condition,    buffer overflow

Ans:A ,A

On the feasibility committee, department representatives serve as
Options: ready source of information,    liason to their departments,    direct users of the new system,    both (a) and (c)

Ans:A ,A

The OCR stand for?
Options: Outsized character reader,    Optical character recognition,    Operational character reader,    Only character reader

Ans:B ,B

A computer programmer
Options: does all the thinking for a computer,    can enter input data quickly,    can operate all types of computer equipment,    can draw only flowchart

Ans:A ,A

Any storage device added to a computer beyond the immediately usable main storage is known as
Options: Floppy disk,    Hard disk,    Backing store,    Punched card

Ans:C ,C

The physical layer of a network
Options: constructs packets of data and sends them across the network,    controls error detection and correction,    defines the electrical characteristics of signals passed between the computer and communication devices,    All of the above

Ans:C ,C

.   to save a presentation you
Options: a. click save on the windows start button b. press Ctrl + F5 c. select File, Save from the menu d. click the saver button on the formatting toolbar

Ans:2 – C ,2 – C

How can you apply exactly the same formatting you did to another text?
Options: a. Copy the text and paste in new location. Then type the new text again. b. Copy the text and click on Paste Special tool on new place c. Select the text then click on Format Painter and select the new text d. All of above

Ans:– C,– C

Thesaurus tool in MS Word is used for
Options:  A) Spelling suggestions, B) Grammar options, C) Synonyms and Antonyms words, D) All of above,


. In PC from where you will connect internet?
Options: a. Tools b. Network neighborhood c. Dial up network d. None of the above

Ans:7 – c ,7 – c

A transaction manager is which of the following?
Options: Maintains a log of transactions,    Maintains before and after database images,    Maintains appropriate concurrency control,    All of the above.

Ans:D ,D

.   Slide show options available to the presenter include all of the following except
Options: a. Transitions command b. Speaker notes command c. Meeting minder command d. Navigation commands

Ans:4 – A ,4 – A

SPSS stands for
Options: Statistical Package for Systems Science,    Systems Package for Social Science,    Statistical Package for Sociai Science,    All of the above

Ans:C ,C