. Which of the following shortcuts can be used to insert a new line in the same cell?


Options: Enter B. Alt + Enter C. Ctrl + Enter D. Shift + Enter

Ans:– B ,






More MS-Excel Related questions:


. What is placed to the left of horizontal scroll bar
Options: a. Tab stop buttons b. View buttons c. Split buttons d. Indicators

Ans:– B,– B


. The spelling dialog box can be involved by choosing spelling from ________ menu.
Options: a. insert b. file c. tools d. view

Ans:– c,– c


A form of code that uses more than one process and processor, possibly of different type, and that may on occasions have more than one process or processor active at the same time, is known as
Options: multiprogramming,    multi threading,    broadcasting,    time sharing

Ans:B ,B


What will be the output of the program ? #include<stdio.h> int main() { int a[5] = {5, 1, 15, 20, 25}; int i, j, m; i = ++a[1]; j = a[1]++; m = a[i++]; printf("%d, %d, %d", i, j, m); return 0; }
Options: 2, 1, 15,    1, 2, 5,    3, 2, 15,    2, 3, 20

Ans:C ,C


Critical path of the PERT chart is:
Options: path which takes the longest time to complete the project,    the shortest path,    both of the above,    path which takes the shortest time to complete the project

Ans:A ,A


ASCII stands for
Options: American standard code for information interchange,    All purpose scientific code for information interchange,    American security code for information interchange,    American Scientific code for information interchange

Ans:A,(Aanswer


What command is used to sort the lines of data in a file in reverse order?
Options: sort - r,    st,    sh,    sort

Ans:A ,A


From which menu you can access Picture, Test Box, Chart etc?
Options: a. File b. Edit c. Insert d. View

Ans: – C , – C


The report card and merit list forms the
Options: Output data,    Data processing,    Central Processing,    Input data

Ans:A,(Aanswer


In Data structure, main characteristic of "ring" is :
Options: last, record points to the first record,    first record points only to the last record,    many records point to one record,    All of the above

Ans:A ,A


. How many margins sare there on a page?
Options: a. Two (header and footer) b. Four (top, bottom, right and left) c. Two (landscape and portrait) d. Four (center, top, left and bottom)

Ans: – B , – B


A subtype discriminator is which of the following?
Options: An attribute of the supertype whose values determine the subtype,    An attribute of the subtype whose values determine the supertype,    An attribute of the supertype whose values determine the supertype,    An attribute of the subtype whose values determine the subtype

Ans:A ,A


. Which of the following setup options can not be set in the page setup dialog box?
Options: a. Printer selection b. Vertical or horizontal placement c. Orientation d. Row and column titles

Ans:– a,– a


What is placed to the left of horizontal scroll bar
Options: a. Tab stop buttons b. View buttons c. Split buttons d. Indicators

Ans:– B,– B


It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
Options: Database,    Table,    Record,    Flat File

Ans:A ,A


. Borders can be applied to
Options: a. cells b. paragraph c. text d. All of above

Ans: – D , – D


Doubling the operating voltage of a purely capacitive circuit:
Options: has no effect on the capacitive reactance,    doubles the amount of capacitive reactance,    multiplies the capacitive reactance by 7,    cuts the capacitive reactance in half

Ans:A ,A


In which circumstance are multiple copies of the same unicast frame likely to be transmitted in a switched LAN?
Options: During high-traffic periods,    After broken links are reestablished,    When upper-layer protocols require high reliability,    In an improperly implemented redundant topology

Ans:D ,D


The channel in the data communication model can be
Options: postal mail service,    telephone lines,    radio signals,    All of the above

Ans:D ,D


The first microprocessor built by the Intel Corpn. was called
Options: 8008,    8080,    4004,    8800

Ans:C ,C


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


Which of the following hardware components is the most important to the operation of a database management system?
Options: high-resolution video display,    printer,    high speed, large-capacity disk,    plotter

Ans:C ,C


What is the shortcut key for “Find and Replace ” dialog box?
Options: Ctrl + F B. Ctrl + R C. Ctrl + H D. Ctrl + Shift + F

Ans:– C ,


Mostly which of the following device is used to carry user files?
Options: Floppy Disk B. Hard Disk     C. RAM D. CDROM

Ans:– A ,


. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Options: a. IF b. AND c. OR d. NOT

Ans:– a,– a


Which technique is being investigated as an approach to automatic programming?
Options: generative CAI,    specification by example,    All of the above,    non-hierarchical planning

Ans:B ,B


. The three parts of an IIF function are separated by _____.
Options: a. dashes b. asterisks c. semicolons d. commas

Ans:8 – d ,8 – d


The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:D ,D


In ________ mode, the communication channel is used in both directions at the same time?
Options: Full-duplex B. Simplex C. Half-duplex D. None of the above

Ans:– A ,


. 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


What should be add before a fraction to avoid entering it as a date?
Options: // B. FR C. Zero D. Zero Space

Ans:– D ,


A band is always equivalent to
Options: a byte,    a bit,    100 bits,    16 bits

Ans:E ,E


A type of channel used to connect a central processor and peripherals which uses multipling is known as
Options: Modem,    Network,    Multiplexer,    All of the above

Ans:C ,C


Data link layer retransmits the damaged frames in most networks. If the probability of a frame's being damaged is p, what is the mean number of transmissions required to send a frame if acknowledgements are never lost.
Options: P I (K + 1),    KIK (1 + F),    1/ (1 - F),    K I (K - P)

Ans:C ,C


The functional area showing the greatest interest in the concept of functional information systems is the
Options: financial function,    manufacturing function,    both (a) and (6),    neither (a) nor (b)

Ans:D ,D


. The following applications may appear on system tray except
Options: a. System Clock b. Volume Control c. Network Connection d. MS Office Suite

Ans:4 – d ,4 – d


Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics

Ans:C ,C


. What does the expression [detail] ! [product] * 1.30 do?
Options: a. multiplies the contents of detail and product fields by 1.3 b. First divides detail by product and then multiplies by 1.3 c. multiplies the contents of detail in the product table by 1.3 d. multiplies the contents of product in the detail table by 1.3

Ans:– d,– d


    Which command divides the surface of the blank disk into sectors and assign a unique address to each one
Options: a.    Ver b.    Format c.    Fat d.    Chkdsk

Ans:.b,Correct Answer: b. Format


In analyzing the compilation of PL/I program, the term "Syntax analysis" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:A ,A


. The delete confirmation generated by …switch
Options: a. /p b. /b c. /w d. /c

Ans:4 – a ,4 – a


. Which of the following is not purely output device?
Options: A) Screen B) Printer C) Speaker D) Plotter

Ans:A,A


Which of the following is a block device
Options: mouse,    printer,    terminals,    disk

Ans:D ,D


A micro processor chip used in a PC system
Options: Performs the arithmetic-logic and control functions,    Is the only chip cound in most PC models,    Almost always operates on by-bits of data at a time,    Performs the primary storage function

Ans:A ,A


In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,


. To clear the content of recent opening files from document folder
Options: a. Start >> setting >> choose taskbar and start menu b. Start >> program and choose clear content c. Both of above d. None of above

Ans:8 – a ,8 – a


What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register

Ans:B,B


An oval represents which of the following in an EER?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:A ,A


Which of the following is considered to be the destination host before translation?
Options: Inside local,    Outside local,    Inside global,    Outside global

Ans:B ,B


What should he used to extinguish a computer fire?
Options: fire hose,    class a extinguisher,    class c extinguisher,    silver foam water

Ans:C ,C

www.000webhost.com