What do you mean by a Workspace?


Options: Group of Columns B. Group of Worksheets C. Group of Rows D. Group of Workbooks

Ans:– D ,






More MS-Excel Related questions:


A communications medium that uses pulses of laser light in glass fibers. Select the best fit for answer:
Options: Fiber optic cables,    Cellular phone systems,    Telecommunications processors,    Telecommunications software

Ans:A ,A


. “Ctrl + End” is used to
Options: Moves the cursor to the end of Line B. Moves the cursor to the end of Document C. Moves the cursor to the end of Paragraph D. None of the Above

Ans:– B ,


The unit of a computer system that executes program, communicates with and often controls the operation of other subsystems of the computer is known as
Options: CPU,    Control Unit,    I/O unit,    Peripheral unit

Ans:A,A


60. You need to jump to the next column breaking current column right at the cursor position. How can you break column?
Options: a. Pressing Ctrl+Enter b. Pressing Alt+Shift+Enter c. Break command from Insert menu d. Both b and c

Ans:– C ,– C


What will be the output of the program? #include<stdio.h> int main() { typedef int arr[5]; arr iarr = {1, 2, 3, 4, 5}; int i; for(i=0; i<4; i++) printf("%d,", iarr[i]); return 0; }
Options: 1, 2, 3, 4,    1, 2, 3, 4, 5,    No output,    Error: Cannot use typedef with an array

Ans:A ,A


Poor response times are caused by
Options: Processor busy,    High I/O rate,    High paging rates,    Any of the above

Ans:D ,D


A typical worksheet has …. Number of columns
Options: a. 128 b. 256 c. 512 d. 1024

Ans:#8211; b,#8211; b


. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Options: a. HTML b. Pivot Table Field List c. Pivot Table List d. Pivot Table Report

Ans:– d,– d


A hand-held device for optically reading bar codes on goods, labels & shelves is
Options: Wand,    Touch tablet,    Mouse,    Light pen

Ans:A ,A


What will be the output of the program? #include<stdio.h> #define SQR(x)(x*x) int main() { int a, b=3; a = SQR(b+2); printf("%d\n", a); return 0; }
Options: 25,    11,    Error,    Garbage value

Ans:B ,B


You are working with a network that has the network ID 192.168.10.0. What subnet should you use that supports up to 12 hosts and a maximum number of subnets?
Options: 255.255.255.192,    255.255.255.224,    255.255.255. 240,    255.255.255.248

Ans:C ,C


Which of the following is reliable communication?
Options: TCP B. IP C. UPD D. All of them

Ans:– A ,


You need to create an access list that will prevent hosts in the network range of 192.168.160.0 to 192.168.191.0. Which of the following lists will you use?
Options: access-list 10 deny 192.168.160.0 255.255.224.0,    access-list 10 deny 192.168.160.0 0.0.191.255,    access-list 10 deny 192.168.160.0 0.0.31.255,    access-list 10 deny 192.168.0.0 0.0.31.255

Ans:C ,C


What is a free electron?
Options: An electron that has been freed from its parent atom,    An electron that costs nothing,    An electron that has no electrical charge,    An electron that has twice the amount of charge of a normal electron

Ans:A ,A


What is the shortcut key to Update Formula in a table?
Options: F9 B. Alt + F9 C. Ctrl + F9 D. Shift + F9

Ans:– A ,


Which of the following option is not available in Insert >> Picture?
Options:  A) Chart, B) Word Art, C) Clip Art, D) Graph,

Ans:-D,-D


Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options: MUST COVER,    MUST NOT,    Both of the above.,    None of the above is correct.

Ans:A ,A


ow to remove all character formats?
Options: Shift + Spacebar B. Shift + Enter C. Ctrl + Spacebar D. Ctrl + Enter

Ans:– C ,


. UNIVAC was a first generation computer. What is its full form?

Options: A) Universal Automatic Computer B) Universal Array Computer C) Unique Automatic Computer D) Unvalued Automatic Computer

Ans:A,A


Linked lists are best suited
Options: A)for relatively permanent collections of data b.for the size of the structure and the data in the structure are constantly changing c.for both of above situation d.for none of above situation

Ans:B, For the size of the structure and the data in the structure are constantly changing


The slide that is used to introduce a topic and set the tone for the presentation is called the
Options: a. table slide b. graph slide c. bullet slide d. title slide

Ans: – D , – D


What is the default font size of a new Word document based on Normal template?
Options:  A) 10 pt, B) 12 pt, C) 14 pt, D) None of above,

Ans:B,B


. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Options: a. Between b. Is Null c. Like d. Not

Ans:7 – a ,7 – a


The process of entering data into a storage location
Options: adds to the contents of the location,    cause variation in its address number,    is known as a readout operation,    is destructive of previous contents

Ans:D ,D


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

Ans:B ,B


Which of the following is the largest and most powerful computer manufacture in the world
Options: IBM,    Intel,    Novel,    Microsoft

Ans:A ,A


The extract process is which of the following?
Options: Capturing all of the data contained in various operational systems,    Capturing a subset of the data contained in various operational systems,    Capturing all of the data contained in various decision support systems,    Capturing a subset of the data contained in various decision support systems

Ans:B ,B


You can append to a file instead of overwriting by using the
Options: > symbols,    >> symbols,    < symbols,    << symbols

Ans:B ,B


Which is an electronic device that can store temporarily a single bit of data.
Options: Accumulator,    Buffer,    Memory,    Latch

Ans:D ,D


.  Which language is used to create macros in Excel?
Options: a. Visual Basic b. C c. Visual C++ d. Java

Ans:– a,– a


  Microsoft PowerPoint can insert objects from the following add-ins? A.  Equation Editor B.  Organization Chart C.  Photo Album D.  All of these
Options:

Ans: – D ,


When two computers communicate with each other, they send information back and forth. If they are separated by a reasonable distance, they can send and receive the information through a direct cable connection which is called a null-modem connection. Presently what is the maximum distance in metres permitted in this null-modem connection?
Options: 80,    100,    30,    150

Ans:C ,C


. Which tool you will use to join some cells and place the content at the middle of joined cell?
Options: a.  From Format Cells dialog box click on Merge Cells check box b.  From Format Cells dialog box select the Centered alignment c.  From Format Cells dialog box choose Merge and Center check box d.  Click on Merge and Center tool on formatting toolbar

Ans:– d,– d


. Macros are “run” or executed from the ….. menu.
Options: a. Insert b. Format c. Tools d. Data

Ans:– c,– c


A design that consists of a hierarchy of modules; each module has a single entry and a single exit subroutine, is known as
Options: hierarchy structure,    top-down design,    Tuple,    Turnaround

Ans:B ,B


A foreign key is which of the following?
Options: Any attribute,    The same thing as a primary key,    An attribute that serves as the primary key of another relation,    An attribute that serves no purpose

Ans:C ,C


.The operation of processing each element in the list is known as
Options: A)Sorting b.Merging c.Inserting d.Traversal

Ans:D,D


When a bearing in the power supply fan goes out, what should you replace?
Options: fan,    case,    bearing,    power supply

Ans:D ,D


Administrative supervision of the activities relating to a database is the responsibility of the:
Options: DP manager,    Database administrator,    VP-DP Administration,    DB manager

Ans:B ,B


. Which is an Office feature that makes it easy to edit embedded objects? 
Options: a. pasting b. visual editing c. tools, update, links d. edit, links

Ans: –  B , –  B


Declare the following statement? "A pointer to an array of three chars".
Options: char *ptr[3]();,    char (*ptr)*[3];,    char (*ptr[3])();,    char (*ptr)[3];

Ans:D ,D


What is the first thing you could do to check for damage to a printer after receiving it?
Options: Run MSD diagnostics,    Attach it to a PC and print something,    Check the cables,    Unbox it and examine it for physical damage

Ans:D ,D


A characteristic of a file server is which of the following?
Options: Manages file operations and is shared on a network.,    Manages file operations and is limited to one PC.,    Acts as a fat client and is shared on a network.,    Acts as a fat client and is limited to one PC.

Ans:A ,A


What flavor of Network Address Translation can be used to have one IP address allow many users to connect to the global Internet?
Options: NAT,    Static,    Dynamic,    PAT

Ans:D ,D


After you have compiled your kernel, what do you have to edit to boot your new kernel image?
Options: /boot/lilo.conf,    /etc/conf.modules,    /etc/named.boot,    /etc/lilo.conf

Ans:D ,D


. Internal commands are
Options: a. Incorporated in the command.com b. Incorporate in the command directory c. Have external files d. All of the above

Ans:0 – a ,0 – a


In the formula, which symbol specifies the fixed columns or rows?
Options: $ B. * C. % D. &

Ans:– A ,


MAC is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique or multiple-access transmission media,    a very common bit-oriented data link protocol issued to ISO.,    network access standard for connecting stations to a circuit-switched network

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


Which one of the following statements is true for the impedance of a series RC circuit?
Options: The impedance is greater than the sum of the resistance and capacitive reactance,    The impedance is equal to the sum of the resistance and capacitive reactance,    The impedance is greater than either the resistance or capacitive reactance but less than their sum,    The impedance is less than the sum of the resistance and capacitive reactance

Ans:C ,C

www.000webhost.com