How do you wrap the text in a cell?

Options: Format, cells, font B. Format, cells, protection C. format, cells, number D. Format, cells, alignment

Ans:– D ,

Description: mcqquestions

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

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

A COM port is a _____ port.
Options: parallel,    serial,    static,    multi

Ans:B ,B

55. A feature of MS Word that saves the document automatically after certain interval is available on
Options: a. Save tab on Options dialog box b. Save As dialog box c. Both of above d. None of above

Ans:– A ,– A

Which of the following is a read only memory storage device?
Options:  Floppy Disk B.  CD-ROM      C.  Hard Disk D.  None of these

Ans:– B ,

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Options: record,    field,    file,    data base

Ans:A ,A

. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
Options: a. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows b. Select the range you want, include both cells, point to fill on the Edit menu, and then click down. c. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special d. All of above

Ans:– a,– a

. If you need to edit a relationship
Options: a. Right click the relationship line and choose edit relationship b. Double click the relationship line c. Both of above d. None of above

Ans:5 – c ,5 – c

Point out the error in the program? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a z1 = {512}; union a z2 = {0, 2}; return 0; }
Options: Error: invalid union declaration,    Error: in Initializing z2,    No error,    None of above

Ans:B ,B

. What are inserted as cross-reference in Word?
Options: a. Placeholders b. Bookmarks c. Objects d. Word fields

Ans:–  D,–  D

Which command allows you to view your file 24 lines at a time?
Options: more,    pg,    cat,    lp

Ans:B ,B

Control Unit of a digital computer is often called the
Options: Clock,    Nerve center,    ICs,    All of the above

Ans:B ,B

What is the minimum header size of an IP packet?
Options: 16 bytes B. 10 bytes             C. 20 bytes D. 32 bytes

Ans:– C ,

Which of the following is an absolute cell reference?
Options: a. !A!1 b. $A$1 c. #a#1 d. A1

Ans:#8211; b,#8211; b

. The shortcut key is used to open properties window of selected item is
Options: a. Ctrl+Enter b. Shift+Enter c. Alt+Enter d. None of above

Ans:9 – c ,9 – c

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

Database management systems are intended to:
Options: eliminate data redundancy,    establish relationships among records in different files,    manage file access,    maintain data integrity

Ans:E ,E

. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
Options: a. Referential integrity is enforced b. Referential integrity isn’t enforced c. An inner join is set d. An outer join is set

Ans:– a,– a

The symbols used in an assembly language are
Options: Codes,    Mnemonics,    Assembler,    All of the above

Ans:B ,B

The standard IRQ for the floppy drive is?
Options: 9,    6,    10,    All of the above

Ans:B ,B

. Which is true when you insert an excel worksheet into a word document?
Options: a. word is the destination document b. excel is the destination document c. the worksheet is the destination document d. the document is the source document

Ans: –  A , –  A

Error control is needed at the transport layer because of potential errors occurring _____.
Options: from transmission line noise,    in routers,    from out-of-sequence delivery,    from packet losses.

Ans:B ,B

In order to combat foreign competition, U.S. companies are:
Options: automating,    ignoring the situation,    seeking import tariffs,    decreasing the salaries

Ans:A ,A

Different components on the motherboard of a PC processor unit are linked together by sets of parallel electrical conducting lines. What are these lines called?
Options: Conductors,    Buses,    Connectors,    Connectively

Ans:B ,B

When entering field name, how many characters you can type in maximum?
Options: a. 60 b. 64 c. 68 d. Any number of character

Ans:ndash; b,ndash; b

Which of the following commands will allow you to set your Telnet password on a Cisco router?
Options: line telnet 0 4,    line aux 0 4,    line vty 0 4,    line con 0

Ans:C ,C

What will be the output of the program? #include<stdio.h> int main() { char huge *near *far *ptr1; char near *far *huge *ptr2; char far *huge *near *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(*ptr2), sizeof(**ptr3)); return 0; }
Options: 4, 4, 4,    2, 4, 4,    4, 4, 2,    2, 4, 8

Ans:A ,A

Production machines were first controlled by the computer by means of
Options: punched cards,    punched paper tape,    magnetic tape,    magnetic cards

Ans:B ,B

What is meant by quad-density (QD) diskette?
Options: It is double-sided disk,    It is double density disk,    It has double the number of tracks per inch,    All of the above


Devices interconnected by the LAN should include
Options: Computers and terminals,    mass storage device, printers and plotters,    bridges and gateways,    All of the above

Ans:D ,D

Sort/Report generators
Options: a . are faster than index/report generators b . require more disk space than indexed/report generators c . do not need to sort before generating report d . both a and b

Ans:D,Both A and B

We want to round off x, a float, to an int value, The correct way to do is
Options: y = (int)(x + 0.5),    y = int(x + 0.5),    y = (int)x + 0.5,    y = (int)((int)x + 0.5)

Ans:A ,A

In Bourne shell, which file sets the Unix environment for the user when the logs into his HOME directory.
Options: .exrc,    .profile,    lastlogin,    .mbox

Ans:B ,B

.   To insert a new slide in the current presentation, we can choose
Options: a. Ctrl + M b. Ctrl + N c. Ctrl + O d. Ctrl + F

Ans:6 – A ,6 – A

. 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


Which command is used to display the top of the file?
Options: cat,    head,    more,    grep

Ans:B ,B

What is the name given to the values that are automatically provided by software to reduce keystrokes and improve a computer user's productivity?
Options: Defined values,    Fixed values,    Default values,    Special values

Ans:C ,C

What is the size of Network bits & Host bits of Class A of IP address?
Options: Network bits 7, Host bits 24 B. Network bits 8, Host bits 24 C. Network bits 7, Host bits 23 D. Network bits 8, Host bits 23

Ans:– A ,

A transaction for which all committed changes are permanent is called:
Options: atomic.,    consistent.,    isolated.,    durable.

Ans:D ,D

A command that lets you change one or more fields in a record is
Options: Insert,    Modify,    Look-up,    All of the above

Ans:B ,B

. If you need a text to show vertically in a cell. How will you achieve this?
Options: a. Choose Vertical on Text alignment in Format Cells dialog box b. Choose 90 Degrees in Orientation of Format Cells dialog box c. Choose Distributed from the Vertical drop down list of Format Cells dialog box d. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

Ans:– b,– b

What will be the output of the program? #include<stdio.h> int X=40; int main() { int X=20; printf("%d\n", X); return 0; }
Options: 20,    40,    Error,    No Output

Ans:A ,A

The output voltages of a PC power supply are in the form of _____ current.
Options: AC,    DC,    amperage,    resistive

Ans:B ,B

. FORTRAN is a programming language. What does FORTRAN stand for?
Options: A) File Translation B) Format Translation C) Formula Translation D) Floppy Translation


. How to split a table in Word 2010?
Options: Tables group on the Insert ribbon and click the Split Table button B. Split group on the Layout ribbon and click the Split Table button C. Merge group on the Layout ribbon and click the Split Table button D. Split group on the Table ribbon and click the Split Table button

Ans:– C ,

You need to configure a router for a Frame Relay connection to a non-Cisco router. Which of the following commands will prepare the WAN interface of the router for this connection?
Options: Router(config-if)#encapsulation frame-relay q933a,    Router(config-if)#encapsulation frame-relay ansi,    Router(config-if)#encapsulation frame-relay ietf,    Router(config-if)#encapsulation frame-relay cisco

Ans:C ,C

Pointers are useful in
Options: Locating a particular sector of a magnetic disk,    Pointing mistakes in input data,    Traversing a linked list,    All of the above

Ans:C ,C

. Which of the following queries modifies fields not records?
Options: a. Append b. Delete c. Make-Table d. Update

Ans:4 – d ,4 – d

. The essential difference between an operating system like Linux and one like Windows is that
Options: a. Windows can run with an Intel processor, whereas Linux cannot b. Linux is a proprietary whereas Windows is not c. There are multiple versions of Linux, but only one version of Windows d. Any programmer can modify Linux code which is not permitted with Windows

Ans: d, d

Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit


. Which of the following database objects can have more than one Group Header/Footer section?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:7 – c ,7 – c

Conversion of hexadecimal number 1D7F16 to a decimal number is
Options: 755110,    877110,    555710,    778110