. How to fit long texts in a single cell with multiple lines?

Options: Start typing in the cell and press the Enter key to start another line B. Use the Wrap Text option in the Format -> Alignment menu C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu D. All of above

Ans:– B ,

Description: mcqquestions

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

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

A word field may consist of an optional field instruction called a(n) ______
Options: subdocument B. symbol C. signal D. switch

Ans:– D ,

What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C

Match the device driver HIMEM.SYS to its operation.
Options: Supports (ANSI) terminal emulation,    Manages the use of extended memory,    Uses expanded memory on a 80386 processor,    Supports code page switching

Ans:B ,B

An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape

Ans:A ,A

LISP was developed by
Options: John Mc Carthy,    Blaise Pascal,    Dr. Hollerith,    John Napier

Ans:A ,A

Time during which a job is processed by the computer is
Options: Delay time,    Real time,    Execution time,    Down time

Ans:C ,C

A data structure where elements can be added or removed at either end but not in the middle
Options: a. Linked lists b. Stacks c. Queues d. Deque  


Shimmer, Sparkle text, Blinking Background etc. are known as
Options:  A) font styles, B) font effects, C) word art, D) text effects, 


PowerPoint Application allows you to produce
Options: Animated Presentations B. Paper Printouts of Slides C. Notes for the Speaker D. All of the above.

Ans:– D ,

.    Which command is used to display all the files having the (.exe) extension but different filename?
Options: a.    Dir filename.* b.    Dir filename.ext c.    Dir *.sys d.    Dir *.ext

Ans:.a,Correct Answer: d. Dir *.ext

Conversion of binary number 1010101000010111 to hexadecimal number is
Options: D8F916,    A8B916,    AA1716,    D9F816

Ans:C ,C

Use of a supertype/subtype relationship is necessary when which of the following exists?
Options: An instance of a subtype participates in a relationship that is unique to that subtype.,    An instance of a subtype participates in a relationship that is the same as the other subtypes.,    Attributes apply to all of the instances of an entity type.,    No attributes apply to any of the instances of an entity type.

Ans:A ,A

Ctrl + I
Options: Italic B. Left Indent C. Save Document D. Close Document

Ans:– A ,

. Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
Options: a. Color Schemes b. Animation c. Transition Settings d. Handouts

Ans:2 – C ,2 – C

What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample "*.c" /* sample.c */ #include<stdio.h> int main(int argc, int *argv) { int i; for(i=1; i<argc; i++) printf("%s\n", argv[i]); return 0; }
Options: *.c,    "*.c",    sample *.c,    List of all files and folders in the current directory

Ans:A ,A

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


A key:
Options: must always be composed of two or more columns.,    can only be one column.,    identifies a row.,    identifies a column.

Ans:C ,C

Which of the following do you use to change margins?
Options: a. formatting toolbar b. page setup dialog box c. Standard toolbar d. paragraph dialog box

Ans:–  B,–  B

To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
Options: a. Edit b. Format c. Tools d. Data


. Which command is used to combine F1 and F2 file into the file F3
Options: a. Copy F1+F2 F3 b. Copy F3 F1+F2 c. Copy F1+F2+F3 d. Copy F1 F2+F3

Ans:2 – a ,2 – a

The logical data structure with a one-to-many relationship is a :
Options: network,    tree,    chain,    relational

Ans:B ,B

.  A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
Options: a.            properties b.           procedures c.           macros d.            commands

Ans:– b,– b

Which SQL-92 standard SQL command can be used to change a table name?
Options: RENAME TABLE,    CHANGE TABLE,    ALTER TABLE,    None of the above is correct.

Ans:D ,D

Alice is setting up a small network in her home so that she can study for her MCSE exams. She doesn't have a lot of money to spend on hardware, so she wants to use a network topology that requires the least amount of hardware possible. Which topology should she select?
Options: Star,    Right,    Token-Ring,    Ethernet

Ans:E ,E

The CAI (Computer-Assisted Instruction) technique based on programmed instruction is:
Options: frame-based CAI,    generative CAI,    problem-solving CAI,    intelligent CAI

Ans:A ,A

The step-by-step instructions that solve a problem are called _____.
Options: An algorithm,    A list,    A plan,    A sequential structure

Ans:A ,A

What is the shortcut key to “Center Align ” the selected text?
Options: Ctrl + C B. Ctrl + E C. Ctrl + F D. None of above

Ans:– B ,

. Which device is used to backup the data?
Options: A) Floppy Disk B) Tape C) Network Drive D) All of the above


The basic operations performed by a computer are
Options: Arithmetic operation B. Logical operation C. Storage and relative D. All the above

Ans:– D ,

To prevent toner from sticking to a laser printer's heat rollers, apply which of the following:
Options: Alcohol,    Oil,    Ammonia,    Beer or Jack Daniels

Ans:B ,B

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

Ans:A ,A

. To create queries in access
Options: a. You can drag and drop fields on query builders b. You can type the sql command in sql view c. You can use query wizard or design view d. All of above

Ans:5 – d ,5 – d

. The _____ on the right side of the menu bar lets users type free-form questions, such as how do I save, or terms, such as copy, and Word responds by displaying a list of topics related to the word or phrase entered.
Options: a. Type a question for help box b. Question Mark button c. What’s this? command d. Index sheet

Ans: – A , – A

Which protocol has been standardised by the International Standards Organisation.
Options: ISAM,    ISO,    LISP,    CALL

Ans:B ,B

. 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 autofill feature
Options: a. Extends a sequential series of data b. Automatically adds a range of cell values c. Applies a boarder around selected cells d. None of above

Ans:– a,– a

When a disk stack is serviced by a comb-like access mechanism, there is one read/write head for each
Options: disk,    disk surface,    track,    cylinder

Ans:B ,B

Which command is used to locate all the .profile files in the system?
Options: ls profile,    find /-name profile -print,    cd /.profile,    l -u .profile

Ans:B ,B

In which directory can you store system user default files used for creating user directories?
Options: /usr/tmp,    /etc/default,    /etc/skel,    /etc/users

Ans:C ,C

You can detect spelling and grammar errors by
Options:  A) Press Shift + F7, B) Press Ctrl + F7, C) Press Alt+ F7, D) Press F7, 


. In which language is source program written?
Options: A) English B) Symbolic C) High level D) Temporary


. What was the nick name of the computer used by the Americans in 1952 for their H-bomb project?



.   After moving a clip art image to a particular location on the slide, you can immediately reverse the action using the
Options: a. Click the not do move object command on the edit menu b. Click on the undo button c. Click on redo button d. All of above

Ans:9 – B ,9 – B

The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
Options: a. relationship b. Join c. Query d. None of these

Ans:dash; a,dash; a

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
Options: the pin code,    the last name,    a compound key consisting of the first name and the last name,    All of the above

Ans:C ,C

How many bytes of memory will the following code reserve? #include<stdio.h> #include<stdlib.h> int main() { int *p; p = (int *)malloc(256 * 256); if(p == NULL) printf("Allocation failed"); return 0; }
Options: 65536,    Allocation failed,    Error,    No output

Ans:B ,B

. The maximum length of any single path from the root directory?
Options: a. 54 b. 63 c. 80 d. 27

Ans:7 – b ,7 – b

In LISP, the function (minusp (-20 4 8 8 1) returns
Options: T,    F,    NIL,    -20

Ans:A ,A

. The MS DOS operating system is a
Options: a. Graphical user interface, single tasking operating system b. Graphical user interface, multitasking operating system c. Command driven interface, single tasking operating system d. Command driven interface, multitasking operating system

Ans:9 – c ,9 – c

The mistake, committed by interchanging two digits in a numeric held, during data entry, is called
Options: transposition error,    transcription error,    Beta testing error,    Alpha testing error

Ans:A ,A