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: 7145 | 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 operating system does not support networking between computers?
Options: a. Windows 3.1 b. Windows 95 c. Windows 2000 d. Windows NT

Ans: a, a


. One of the main feature that distinguish microprocessors from micro-computer is
Options: A) Words are usually large in microprocessors B) Words are shorter in microprocessors C) Microprocessor does not contain I/O device D) Exactly the same as the machine cycle time

Ans:C,C


Type one PC cards:
Options: are used only in desktops,    are no longer being produced,    are the thinnest of the PC cards,    don't exist

Ans:C ,C


What type of FRU is a SCSI host adapter?
Options: CPU,    I/O card,    video card,    hard drive

Ans:B ,B


What is the output of the program in Turbo C (in DOS 16-bit OS)? #include<stdio.h> int main() { char *s1; char far *s2; char huge *s3; printf("%d, %d, %d\n", sizeof(s1), sizeof(s2), sizeof(s3)); return 0; }
Options: 2, 4, 6,    4, 4, 2,    2, 4, 4,    2, 2, 2

Ans:C ,C


First CAD system called AutoCAD for the PCs was announced in the year 1982. Can you tell who announced it?
Options: Intel Corpn.,    Rolta India Ltd.,    Autodesk Inc,    AT & T Corp.

Ans:C ,C


The main idea behind computer files is that it is convenient to
Options: arrange them,    store information together,    create them,    access them

Ans:B ,B


Which is considered a direct entry input device?
Options: Optical scanner,    All of the above,    Light pen,    Digitizer

Ans:All of the above,All of the above


. An embedded object might appear in a document as
Options: a. Embedding b. Linking c. Both d. None of above

Ans:4 – a ,4 – a


Changing the appearance of a document is called
Options:  A) Proofing, B) Editing, C) Formatting, D) All of above, 

Ans:-C,-C


What will be the output of the program in TurboC? #include<stdio.h> int fun(int **ptr); int main() { int i=10, j=20; const int *ptr = &i; printf(" i = %5X", ptr); printf(" ptr = %d", *ptr); ptr = &j; printf(" j = %5X", ptr); printf(" ptr = %d", *ptr); return 0; }
Options: i= FFE2 ptr=12 j=FFE4 ptr=24,    i= FFE4 ptr=10 j=FFE2 ptr=20,    i= FFE0 ptr=20 j=FFE1 ptr=30,    Garbage value

Ans:B ,B


Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:B ,B


. Ctrl + F
Options: a. Open Find and Replace Dialog box with activating Find Tab b. Open Page Setup Dialog box with activating Layout Tab c. Open Font Dialog Box with activating Font tab d. Open File Save as Dialog box

Ans:–  A,–  A


Messages from one computer terminal can be sent to another by using data networks. The message to be sent is converted to an electronic digital signal, transmitted via a cable, telephone or satellite and then converted back again at the receiving end. What is this system of sending messages called?
Options: Paperless office,    Electronic mail,    Global network,    Electronic newspaper

Ans:B ,B


A loadstone is:
Options: a natural magnet,    a temporary magnet,    an artificial magnet,    a paramagnetic alloy

Ans:A ,A


What is the i/o address for com2?
Options: 2vb,    2f8,    8f8,    330

Ans:B ,B


In processing controls must be established in a system, in order to
Options: prohibit tampering with information by unauthorized person,    Verify that all data have been processed,    block or trap faulty data from entry into processing,    All of the above

Ans:D ,D


Positive ions are atoms that have
Options: Gained a proton,    Lost a proton,    Gained an electron,    Lost an electron

Ans:D ,D


Frames from one LAN can be transmitted to another LAN via the device
Options: Router,    Bridge,    Repeater,    Modem

Ans:B ,B


What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Options: DASD,    FMS,    EMMS,    DBMS

Ans:D ,D


The graph of current gain versus collector current indicates that the current gain
Options: varies enormously,    is contant,    varies slightly,    equals the collector current divided by the base current

Ans:D ,D


. The memory which allocates space for DOS and application is called
Options: a. Expanded memory b. Cache memory c. Virtual memory d. Conventional memory

Ans: d,Conventional memory


.   auto clip art is a feature that
Options: a. automatically places clip art in your presentation b. scans your presentation for incorrect spelling of words on each slide c. scans your presentation for incorrect spelling in word art objects d. all of the above

Ans:5 – D ,5 – D


. From where do you change mouse setting?
Options: a. Setting >> mouse b. Hardware setting c. Control panel >> mouse d. None of the above

Ans:1 – c ,1 – c


In SQL, which of the following is not a data definition language commands?
Options: RENAME,    REVOKE,    GRANT,    UPDATE

Ans:D ,D


.  Power Point can display data from which of the following add-in software of MS Office?
Options: Equation Editor B. Organization Chart C. Photo Album D. All of these

Ans: – D ,


Which of the following commands sets the secret password to Cisco?
Options: enable secret password Cisco,    enable secret cisco,    enable secret Cisco,    enable password Cisco

Ans:C ,C


.   A file which contains readymade styles that can be used for a presentation is called
Options: a. Auto style b. Template c. Wizard d. Pre-formatting

Ans:8 – B ,8 – B


The most popular language for interactive use is
Options: COBOL,    PASCAL,    BASIC,    FORTRAN

Ans:C ,C


What is the default subnet mask for a class A network?
Options: 127.0.0.1,    255.0.0.0,    255.255.255.0.0,    255.255.255.0

Ans:B ,B


You are working with a network that has the network ID 10.9.0.0 and contains 73 networks. In the next year, you will be adding an additional 27 branch offices to your company. For simplified management, you want to keep the most possible hosts per subnet. Which subnet mask should you management, you want to keep the most possible hosts per subnet. Which subnet mask should you use?
Options: 255.224.0.0,    255.240.0.0,    255.248.0.0,    255.252.0.0

Ans:E ,E


Which kind of planning consists of successive representations of different levels of a plan?
Options: hierarchical planning,    non-hierarchical planning,    All of the above,    project planning

Ans:A ,A


Which of the following are often used to ensure that data has been accurately input to the computer?
Options: digitizers,    light pens,    keyboards,    input controls

Ans:D ,D


The reports generated by a reporting system are usually not delivered in which of the following media?
Options: Web portal,    Commercial courier service,    Digital dashboard,    E-Mail

Ans:B ,B


While working with MS-DOS, which command is used to display a list of deleted files that DOS can undelete?
Options: UNDELETE *.*,    UNDELETE/ALL,    UNDELETE/LIST,    UNDELETE

Ans:C ,C


. The command fixes the minor errors of the disk
Options: a. Error.fix b. Scandisk c. CHKDSK/f d. Defrag

Ans:6 – c ,6 – c


Any method for controlling access to or use of memory is known as
Options: Memory map,    Memory protection,    Memory management,    Memory instruction

Ans:B ,B


UML is stands for
Options: Universal Modeling Language B. Unified Modeling Language C. United Modeling Language D. Uni Modeling Language

Ans:– B ,


. In computing and electronic systems BCD is abbreviation of
Options: Binary Coded Decimal B. Binary Coded Digit C. Bit Coded Decimal D. Bit Coded Digit

Ans:– A ,


Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:D ,D


Who developed the first personal computer spreadsheet package called Visicalc?
Options: Niklaus Wirth,    Dan Bricklin,    Bob Frankston,    both (b) and (c)

Ans:D,D


. The database language that allows you to access or maintain data in a database
Options: a. Dcl b. Dml c. Ddl d. None of above

Ans:7 – a ,7 – a


Which of the following set options is used with vi editor to ignore case while searching for patterns?
Options: ic,    ai,    sm,    ts

Ans:A ,A


. Ctrl + U
Options: Undelete the previously deleted text B. Undo the last changes C. Underline the document name D. Underline the selected text

Ans:– D ,


Getting data from a cell located in a different sheet is called….
Options: Accessing B. Referencing C. Updating D. Functioning

Ans:– B ,


First generation computers are characterised by
Options: Vaccum tubes and magnetic drum,    Minicomputers,    Magnetic tape and transistors,    All of the above

Ans:A ,A


Assembler language
Options: is usually the primary user interface,    requires fixed-format commands,    is a mnemonic form of machine language,    is quite different from the SCL interpreter

Ans:C ,C


What will be the output of the program? #include<stdio.h> #include<stdlib.h> int main() { union test { int i; float f; char c; }; union test *t; t = (union test *)malloc(sizeof(union test)); t->f = 10.10f; printf("%f", t->f); return 0; }
Options: 10,    Garbage value,    10.100000,    Error

Ans:C ,C


. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Options: a. The Settings tab under the menu Format -> Cells b. The Settings tab under the menu Data -> Validation c. The Settings tab under the menu Data -> Filter -> Advanced Filter d. the Settings tab under the menu Format -> Conditional Formatting

Ans:– b,– b


Which of the following will happen when data is entered into a memory location?
Options: It will add to the content of the location,    It will change the address of the memory location,    It will erase the previous content,    It will not be fruitful if thjere is already some data at that location

Ans:C ,C

www.000webhost.com