. 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: 16597 | 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:

Which option enables automatic updates in destination documents?
Options: embedding B. objects C. links D. relationships

Ans:– C ,

. How to show the same presentation continuously?
Options: a. by enabling the option “Loot continuously until ‘Esc’” b. by enabling the option “Repeat Presentation” c. by enabling the option “Show same Presentation” d. Presentation cannot be continue once it finished

Ans:6 – A ,6 – A

0 Who invented Integrated Circuit (IC)?
Options: Herman Hollerith B. Jack Kilby C. Semen Korsakov D. Bill Gates

Ans: – B ,

An electronic circuit with about 20 transistors fabricated on a silicon chip is known as
Options: SSI,    MSI,    DPS,    RJE

Ans:A ,A

You have just installed a new internal PCI modem on you desktop. It will not dial out. what is the problem?
Options: The port speed is set too high,    the modem has not been set up in control panel properties,    the phone line is plugged into the line-in port on the modem card,    the phone line out of the wall is plugged into the phone port on the modem card

Ans:D ,D

. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
Options: a. zipcode, firstname, lastname b. firstname, lastname, zipcode c. zipcode, lastname, firstname d. can’t sort by multiple fields

Ans:– c,– c

Which of the following is not an important principle for evaluating the raw data for decision-making:
Options: selection,    pattern,    everage,    overview

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

Ans: – C , – C

Coding and testing are done In a
Options: top-down manner,    bottom-up manner,    ad hoc manner,    cross sectional manner

Ans:A ,A

Which of the declaration is correct?
Options: int length;,    char int;,    int long;,    float double;

Ans:A ,A

You can jump to the next column by
Options:  A) Clicking with your mouse on the next column, B) Press Alt + Down-arrow, C) Both of above, D) None of Above, 


A public key encryption system
Options: allows anyone to decode the transmission,    allows only the correct sender to decode the data,    allows only the correct receiver to decode the data,    does not encode the data before transmitting it

Ans:C ,C

. 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 encapsulations can be configured on a serial interface? Ethernet Token Ring HDLC Frame Relay PPP
Options: 1 and 4,    2 only,    3, 4 and 5,    All of the above

Ans:C ,C

  ASCII stands for
Options: A. American Standard Code for Information Interchange B. American Scientific Code for International Interchange C. American Standard Code for Intelligence Interchange D. American Scientific Code for Information Interchange


. MSI is the abbreviation of
Options: A) Medium Scale Integrated B) Medium System Integrated C) Medium Scale Intelligent D) Medium System Intelligent


What is the name of the technique in which the operating system of a computer executes several programs concurrently by switching back and forth between them?
Options: Partitioning,    Multitasking,    Windowing,    Paging

Ans:B ,B

When a label is too long to fit within a worksheet cell, you typically must
Options: a. Shorten the label b. Increase the column width c. Decrease the column width d. Adjust the row height

Ans:#8211; b,#8211; b

The input and output devices are located away from the central computer facility in which particular type of processing.
Options: Time sharing,    Batch processing,    Interactive mode,    Real time processing

Ans:B ,B

The person contributing the idea of the stored program was
Options: John von Neumann,    Charles Babbage,    Howard Aiken,    Basic Pascal

Ans:A ,A

How many non-overlapping channels are available with 802.11a?
Options: 3,    12,    23,    40

Ans:B ,B

Which of the following provides a printed copy of your presentation?
Options: a. Outline b. Speaker notes c. Audience handouts d. All of the above

Ans: – C , – C

. Insert Date, Format Page Number, and Insert AutoText are buttons on the _____ toolbar.
Options: a. Formatting b. Header and Footer c. Standard d. Edit

Ans:– B,– B

. Which is not a view for displaying a report object?
Options: a. Datasheet view b. Design view c. Print preview d. Layout preview

Ans:– a,– a

Which of the following data structures are indexed structures?
Options: a. linear arrays b. linked lists c. both of above d. none of above  


The Primary job of the operating system is A)  Manage Commands B)  Manage Users         C)  Manage Programs D)  Manage Resources

Ans:– D ,

. What is Dr. Watson?
Options: a. IT Expert b. Diagnosis tool c. Surgeon d. None

Ans: b, b

There can be many ways to insert page number in a document. Which of the following lets you insert page number
Options:  A) Page number from Insert menu, B) Page Setup from file menu, C) Footnote from Insert menu, D) Both a & c, 


A _____ means that one record in a particular record type is related to only one record of another record type.
Options: One-to-one relationship,    One-to-many relationship,    Many-to-one relationship,    Many-to-many relationship

Ans:A ,A

How many protons does the nucleus of a silicon atom contain?
Options: 4,    29,    14,    48

Ans:C ,C

95. What is the shortcut key to Update Formula in a table?
Options: a. F9 b. Alt + F9 c. Ctrl + F9 d. Shift + F9

Ans:–  A ,–  A

The model for a record management system might be
Options: a. handwritten list b. a Rolodex card file c. a business form d. all of above

Ans:d,All of above

. Which of the following do you use to change margins?
Options: formatting toolbar B. page setup dialog box C. Standard toolbar D. paragraph dialog box

Ans: – B ,

Database management systems are intended to 
Options: a. eliminate data redundancy b. establish relationship among records in different files c. manage file access D. all of the above 

Ans:D,All of above

. Which of the following is not a valid Data Type in MS Access?
Options: a. Memo b. Picture c. Currency d. AutoNumber

Ans:– b,– b

A discrete parts process is:
Options: the same as a continuous process except a different controller must be used,    often encountered in manufacturing,    normally a repetitive series of operations,    (b) and (c)

Ans:A ,A

Which statement is valid about computer program?
Options: A) It is understood by a computer B) It is understood by programmer C) It is understood user D) Both a & b


    Which of the following extensions suggest that the file is a backup copy
Options: a.    Bak b.    Bas c.    Com d.    Txt

Ans:.a,Correct Answer: a. Bak

What happens if you edited an image inserted in PowerPoint
Options: a. The original file that was inserted is not changed b. The original file that was inserted is changed c. The original file is changed when you save presentation d. None of above

Ans: – A , – A

A Relation is a
Options: Subset of a Cartesian product of a list of attributes B. Subset of a Cartesian product of a list of domains C. Subset of a Cartesian product of a list of tuple D. Subset of a Cartesian product of a list of relations

Ans:– B ,

Which device uses a DMA channel?
Options: Modem,    Network Card,    Sound Card,    All of the above

Ans:C ,C

How many digits of the DNIC (Data Network Identification Code) identify the country?
Options: first three,    first four,    first five,    first six

Ans:A ,A

Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options: a. merge the two files b. create the main document c. set the mailing list parameters d. create the data source

Ans:– C,– C

.   We can replace a font on all sides with another font using the …. option
Options: a. Edit, Fonts b. Tools, Fonts c. Tools, Replace Fonts d. Format, Replace Fonts

Ans:3 – D ,3 – D

While running DOS on a PC, which command would be used to duplicate the entire diskette?
Options: COPY,    DISKCOPY,    CHKDSK,    TYPE

Ans:B ,B

The "snap" command feature in both AutoCAD and VersaCAD ensure that:
Options: template lines can be removed,    objects are entered at specific intervals.,    identified data are automatically segmented,    definable center markers are entered.

Ans:B ,B

Options: place your PC on a rubber mat,    wear leather soled shoes,    periodically touch a safe ground point on the PC to discharge yourself,   wear an ESD wrist strap

Ans:D,wear an ESD wrist strap

Which of the following is not a transmission medium?
Options: telephone lines,    coaxial cable,    modem,    microwave systems

Ans:C ,C

The coming together of three technologies i.e. microelectronics, computing and communications has ushered in
Options: information explosion,    information technology,    business revolution,    educational upgradation

Ans:B ,B

Ctrl + N
Options: a. Save Document b. Open Document c. New Document d. Close Document

Ans:–  C,–  C