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






More MS-Excel Related questions:


A shared lock allows which of the following types of transactions to occur?
Options: Delete,    Insert,    Read,    Update

Ans:C ,C


The seventh field of /etc/password is
Options: password,    login,    shell,    home

Ans:C ,C


. Which of the following is the largest manufacturer of Hard Disk Drives?

Options: A) IBM B) Seagate C) Microsoft D) 3M

Ans:B,B


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

Ans:A ,A


The total capacitance of a series capacitor circuit is:
Options: equal to the sun of the individual capacitive-reactance values,    equal to the sum of the individual capacitance values,    equal to the source voltage divided by total current,    less than the value of the smallest capacitor

Ans:D ,D


You get a CMOS checksum error during bootup. What is most likely the cause?
Options: power supply is bad,    BIOS needs updating,    CMOS battery is nearing end of life,    hard drive types are incorrectly defined

Ans:C ,C


The procedure for evaluating the relative performance of different computers, is done by the process called
Options: batch processing,    sequential processing,    bench marking,    All of the above

Ans:C ,C


It is an association established between common fields of two tables.
Options: a. line b. relationship c. primary key d. records

Ans:ndash; b,ndash; b


A LISP environment consists of a language, a programming environ¬ment, and:
Options: random-access storage,    a processor,    a large address,    a set of functions

Ans:D ,D


During the system study, analysts determine manager's information needs by
Options: conducting tours of a nearby computer center,    asking questions,    showing samples of computer reports,    teaching short courses in programming languages

Ans:B ,B


If you want to execute more than one program at a time, the systems software you are using must be capable of:
Options: word processing,    virtual memory,    compiling,    multitasking

Ans:D ,D


Which of the following decides which systems development projects to work on first ?
Options: data diagram,    project dictionary,    systems flowcharts,    steering committee

Ans:A ,A


Which of the following enables you to paste data multiple times?
Options: Windows Clipboard B. Office Clipboard C. Both Windows & Office Clipboard D. None of the all

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


72. Microsoft Office Word is a (n) _____.
Options: a. area in the computer’s main memory in which Microsoft Office text files are stored temporarily b. program included with Windows 2000 that can be used only to create or edit text files, smaller than 64K, that do not require formatting c. classified password that prevents unauthorized users from accessing a protected Microsoft Office item or document d. full-featured word processing program that can be used to create and revise professional looking documents easily

Ans:– D ,– D


In Word, the default alignment for paragraphs is _____.
Options: a. left-aligned, or flush margins at the left edge and uneven edges at the right edge b. centered, or equidistant from both the left edge and the right edge c. right-aligned, or flush margins at the right edge and uneven edges at the left edge d. justified, or flush margins at both the left and right edges

Ans:– A,– A


. The meaning of Straight-through Cable is
Options: Four wire pairs connect to the same pin on each end B. The cable Which Directly connects Computer to Computer C. Four wire pairs not twisted with each other D. The cable which is not twisted

Ans: – A ,


What is a form in MS Access
Options: a. It is a printed page where users will write their data to fill it up b. It is an input screen designed to make the viewing and entering data easier c. This is an important part of database used by analysts to draw conclusions d. All of above

Ans:ndash; b,ndash; b


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


Which of the following signals is not standard RS - 232-C signal?
Options: VDR,    RTS,    CTS,    DSR

Ans:A ,A


With respect to personnel matters in the United States, ERISA stands for
Options: Earnings and Revenue Information System Administration,    Early Retirement Income Standards Act,    Employee Review-in-Service Administration,    Employee Retirement Income Security Act

Ans:D ,D


The primary tool used in structured design is a:
Options: data-flow diagram,    module,    structure chart,    program flowchart

Ans:C ,C


Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files?
Options: COM,    BAT,    EXE,    SYS

Ans:B ,B


. “Ctrl + Left Arrow” is used to
Options: Moves the cursor beginning of the Line B. Moves the cursor one word left C. Moves the cursor one paragraph up D. Moves the cursor one paragraph down

Ans:– B ,


What is the loopback address?
Options: 127.0.0.1,    255.0.0.0,    255.255.0.0,    255.255.255.255.0

Ans:A ,A


. Which of the following is a Data Model?
Options: Entity-Relationship model B. Relational data model C. Object-Based data model D. All of the above

Ans: – D ,


Communication ports are found on the back of microcomputers. They are used to connect the computer to _____
Options: printers,    modems,    other hardware,    All of the above

Ans:D,D


What do the following declaration signify? int *ptr[30];
Options: ptr is a pointer to an array of 30 integer pointers.,    ptr is a array of 30 pointers to integers.,    ptr is a array of 30 integer pointers.,    ptr is a array 30 pointers.

Ans:B ,B


What operates in the Data Link and the Network layer?
Options: NIC,    Bridge,    Brouter,    Router

Ans:C ,C


. 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

Ans:B,B


The probability that a single bit will be in error on a typical public telephone line using 4800 bps modem is 10 to the power -3. If no error detection mechanism is used, the residual error rate for a communication line using 9-bit frames is approximately equal to
Options: 0.003,    0.009,    0.991,    0.999

Ans:B ,B


Which one of the following is a direct statement of Ohm's law?
Options: The voltage drop across a resistance is proportional to the value of resistance and the amount of current flowing through it,    The total resistance of a parallel circuit is less than the value of the smallest resistance,    The algebraic sum of voltages in a loop is equal to zero,    The algebraic sum of currents entering and leaving a point is equal to zero

Ans:A ,A


The accuracy of the floating point numbers representable in two 16 bit words of a computer is approximately
Options: 16 digits,    6 digits,    4 digits,    All of the above

Ans:B ,B


A compiler is
Options: a program that places programs into memory and prepares them for execution,    a program that automate the translation of assembly language into machine language,    program that accepts a program written in a high level language and produces an object program,    is a program that appears to execute a source program as if it were machine language

Ans:C ,C


A compiler for a high-level language that runs on one machine and produces code for a different machine is called is
Options: optimizing compiler,    one pass compiler,    cross compiler,    multipass compiler

Ans:C ,C


Which of the following commands will display the current IP addressing and the layer 1 and 2 status of an interface? show version show protocols show interfaces show controllers show ip interface
Options: 1, 2 and 4,    2, 3 and 5,    3 and 4 only,    None of the above

Ans:B ,B


. Which of the following data types automatically generates a consecutive number?
Options: a. Autonumber b. Memo c. Number d. Text

Ans:7 – a ,7 – a


1. What is contained in the page table?
Options: a. Base address of each frame and corresponding page number b. Memory address and corresponding page number c. File name and corresponding page number d. None of Above

Ans:1 – a ,1 – a


What will be the output of the program under DOS? #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,    4, 2, 2,    2, 8, 4,    2, 4, 8

Ans:B ,B


A condition that led to the development of databases was:
Options: the proliferation of data files,    an increase in the amount of data handled by organizations,    a demand for more data to support informational needs,    all the above.

Ans:D ,D


. Gridlines
Options: a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. a, b and c

Ans:– d,– d


Sequential or series testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate system,    testing changes made in an existing or a new program

Ans:C ,C


. The advantage of COM are its __ and __
Options: A) Compact size; speed readability B) Compact size, speed C) Readability; speed D) Low cost; readability

Ans:A,A


The key uniquely identifies each record in a table.
Options: a. primary key b. key word c. filed name d. All of above

Ans:ndash; a,ndash; a


An example of a global allocation problem is
Options: defining plant capacities,    scheduling an entire development project,    setting general inventory guidelines,    All of the above

Ans:D ,D


. Which of the following command is used to move the pointer from one pane to next pane?
Options: a. F3 b. F4 c. F5 d. F6

Ans:9 – d ,9 – d


The term used to represent the recycling of unused memory is:
Options: garbage collection,    diagnostic routine,    memory dump,    direct memory access

Ans:A ,A


.   Which is the best view for getting your thoughts for a presentation out on the computer?
Options: a. Outline view b. Notes page view c. Slide sorter view d. Slide view

Ans:5 – A ,5 – A


A hierarchical chart that divides a large program into modules, in which greater details is designed in successively lower programming levels, is called a
Options: Scheme,    sub-schema,    Structure,    All of the above

Ans:C ,C


A large number of computers in a wide geographical area can be efficiently connected using
Options: Twisted pair lines,    Coaxial cables,    Communications satellites,    All of the above

Ans:C ,C

www.000webhost.com