. Which one is the last column header in Excel 2007?

Options: XFD B. XFX C. XFL D. XFT

Ans:– A ,

Description: mcqquestions

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

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

An EOQ formula is an example of a(n)
Options: optimizing model,    static model,    deterministic model,    All of the above

Ans:D ,D

What happens when you insert an AutoShape by simply clicking in the document?
Options: it appears near the insertion point B. it is inserted in its default size C. is selected D. all of the above

Ans: – C ,

Which of the following are integrity controls that a DBMS may support?
Options: Assume a default value in a field unless a user enters a value for that field.,    Limit the set of permissible values that a field may assume.,    Limit the use of null values in some fields.,    All of the above.

Ans:D ,D

Which of the following processor is software that accepts user ideas, manipulates and reorganises them in user-specified ways and then produces a refined model of those thoughts.
Options: Distribute,    Out-line,    Multi,    On-line

Ans:B ,B

The desirable characteristic(s) of a memory system is (are)
Options: speed and reliability,    low power consumption,    durability and compactness,    All of the above

Ans:D ,D

How many simultaneous Telnet sessions does a Cisco router support by default?
Options: 2,    3,    4,    5

Ans:D ,D

16. MSD . exe does not have information on:
Options: a. Cache b. Video c. Operating System d. Com or port

Ans:Correct answer: a,Correct answer: a

A foreign key is:
Options: a column containing the primary key of another table.,    used to define data types.,    used to define null status.,    all of the above are above correct.

Ans:A ,A

. If we use the command prompt $P$L which of the following prompt may be set?
Options: a. C :> b. C: c. C: d. C :<

Ans:1 – d ,1 – d

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
Options: First normal form,    Second normal form,    Third normal form,    Fourth normal form

Ans:B ,B

What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options:  Compiler B.  Interpreter C.  Debugger D.  Assembler

Ans:– D ,

What is the name of the device that connects two computers by means of a telephone line?
Options: Tape,    modem,    bus,    cable

Ans:B ,B

. The …enables the user to load devices drivers and programs into upper memory area while running DOS in 386 or higher microprocessor
Options: a. Himem.sys b. Emm386.exe c. Config.sys d. All of above

Ans:6 – a ,6 – a

Which of the following is not a disadvantage of wireless LAN?
Options: Slower data transmission,    higher error rate,    interference of transmissions from different computers,    All of the above

Ans:D ,D

The standard suit of protocols used by the Internet, intranets, extranets, and some other networks.
Options: TCP/IP,    Protocol,    Open Systems,    Internetwork processor

Ans:A ,A

35. How can you make the selected character superscripted
Options: a. Ctrl + = b. Ctrl + Shift +  = c. Alt + Ctrl + Shift + = d. None of above

Ans:– B ,– B

Which language was created by Charles H. Moore at National Radio Astronomy Observatory.
Options: BASIC,    FORTH,    dBASE,    COBOL

Ans:B ,B

. Using the keyword _______________ will return records in which the field value equals a defined text.
Options: a. Between b. Is Null c. Like d. Not

Ans:3 – c ,3 – c

A notation for defining the form and structure of data is known as
Options: Data description language,    Binary language,    Data channel,    Data definition language

Ans:D ,D

What is the power dissipation of a resistance that has 24 V dropped across it and 0.25 A flowing through it?
Options: 3 W,    6 W,    64 W,    122 W

Ans:B ,B

. Which of the following is invalid statement?
Options: a. Sheet tabs can be colored b. Some picture can be applied as a background of a sheet c. You can set the column width automatically fit the amount of text d. The width of a row and be specified manually or fit automatically

Ans:– d,– d

. .... runs on a computer hardware and serves as a platform for other system to run on
Options: a. Operating system b. Application system c. System software d. All of above

Ans: a, a

. A song being played on comptuer speaker is
Options: A) hard output B) soft output C) both hard and soft output D) neither hard nor soft output


. ASCII stands for
Options: A) American Stable Code for International Interchange B) American Standard Case for Institutional Interchange C) American Standard Code for Information Interchange D) American Standard Code for Interchange Information


We combine hardware, software, people, procedures, and data to create an _____
Options: people,    icons,    information system,    on-line

Ans:C ,C

In LISP, the function returns the list that results after the first element is removed (the rest f the list), is
Options: car,    last,    cons,    cdr

Ans:D ,D

Point out the error in the following program. #include<stdio.h> #include<stdlib.h> int main() { int *a[3]; a = (int*) malloc(sizeof(int)*3); free(a); return 0; }
Options: Error: unable to allocate memory,    Error: We cannot store address of allocated memory in a,    Error: unable to free memory,    No error

Ans:B ,B

. In latest generation computers, the instructions are executed
Options: A) Parallel only B) Sequentially only C) Both sequentially and parallel D) All of above


Which command is used to backup in DOS 6+ Version
Options: a. BACKUP b. MSBACKUP c. MSBACKEDUP d. All of the above

Ans:Correct Answer: b ,Correct Answer: b

Systems that supply data for operations execution or supervision all concern
Options: exception reports,    computing systems,    orders,    All of the above

Ans:C ,C

. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
Options: a. primary, foreign b. primary, common c. foreign, primary d. foreign, common

Ans:1 – a ,1 – a

The difference between Slide Design and Auto Content Wizard is
Options: a. Both are same b. AutoContent Wizard is just the wizard version of Slide Design c. Slide Design does not provide sample content but Auto Content Wizard provides sample content too! d. Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices

Ans: – C , – C

. Personnel who design, program, operates and maintains computer equipment refers to
Options: A) Console-operator B) Programmer C) Peopleware D) System Analyst


An object can have which of the following multiplicities?
Options: Zero,    One,    More than one,    All of the above.

Ans:D ,D

You wished to justify text over the height of paper, which option will you choose
Options:  A) Page Setup from File menu, B) Paragraph from Format menu, C) From formatting toolbar, D) Font from Format menu, 


Which statement describes a spanning-tree network that has converged?
Options: All switch and bridge ports are in the forwarding state.,    All switch and bridge ports are assigned as either root or designated ports.,    All switch and bridge ports are in either the forwarding or blocking state.,    All switch and bridge ports are either blocking or looping.

Ans:C ,C

The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
Options: Database,    Table,    Flat file,    Data structure

Ans:C ,C

The term Parallel Run refers to
Options: the same job run on two different computer to test their speeds,    the processing of two different jobs initiated from two terminals.,    the concurrent operation of an existing system and a new system,    All of the above

Ans:C ,C

. What is the use of bookmarks in Microsoft Word?
Options: To easily correct the spelling errors B. To quickly jump to a specific location in the document C. To quickly jump to the ending of the document D. To create a link within the document

Ans:– B ,

. What is the process of eliminating redundant fields by separating data into tables called?
Options: a. Renormalizations b. Filtering c. Normalization d. Sorting

Ans:4 – c ,4 – c

Which command is used with vi editor to save file and remain in the editing mode?
Options: :q,    :w,    q!,    :x

Ans:B ,B

To exit from the Resume Wizard and return to the document window without creating a resume , click the _____ button in any panel in the Resume Wizard dialog box.
Options: a. Cancel b. Back c. Next d. Finish

Ans:– D,– D

Error detection at the data link level is achieved by?
Options: Bit stuffing,    Hamming codes,    Cyclic Redundancy codes,    Equalization

Ans:C ,C

Convert the 080D4E machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:B ,B

A modem that is attached to the telephone system by jamming the phone's handset into two flexible receptacles in the coupler?
Options: gateway,    bridge,    acoustic coupler,    time-division multiplexer

Ans:C ,C

Which of the following items is not used in Local Area Networks (LANs)?
Options: Computer,    Modem,    Printer,    Cable

Ans:B ,B

What does the passive command provide to dynamic routing protocols?
Options: Stops an interface from sending or receiving periodic dynamic updates.,    Stops an interface from sending periodic dynamic updates but not from receiving updates.,    Stops the router from receiving any dynamic updates.,    Stops the router from sending any dynamic updates.

Ans:B ,B

What causes the depletion layer?
Options: Doping,    Recombination,    Barrier potential,    Ions

Ans:C ,C

What command is used to hand up a MODEM when using the "AT Answer Command set"?
Options: ATZ,    ATD,    ATR,    ATH

Ans:D ,D

. The arrangement of elements such as Title and subtitle text, pictures, tables etis called :
Options: a. Layout b. Presentation c. Design d. Scheme

Ans:2 – A ,2 – A