In the formula, which symbol specifies the fixed columns or rows?


Options: $ B. * C. % D. &

Ans:– A ,






More MS-Excel Related questions:


A menu-driven operating system is one which allows you to pick up from the menu of choices it displays on the screen. What is the name given to the images which are used in such image oriented menus?
Options: Icon,    Figure,    Symbol,    option

Ans:A ,A


While working with MS-DOS, which command is used to restore only those files modified since the last backup, from the drive A to the currently logged drive or directory?
Options: RESTORE A: *.*/S,    RESTORE A: *.*/M,    RESTORE A: *.*/N,    RESTORE A: *.*/L

Ans:B ,B


The standard suit of protocols used by the Internet, intranets, extranets, and some other networks.
Options: TCP/IP,    Protocol,    Open Systems,    Internetwork processor

Ans:A ,A


In a _____ topology, if there are n devices in a network, each device has n - 1 ports for cables.
Options: ring,    bus,    star,    mesh

Ans:D ,D


Which is used for manufacturing chips?
Options: Bus,    Control unit,    Semiconductors,    (a) and (b) only

Ans:C ,C


MS-EXCEL can be used to automate
Options: Financial statements, Business forecasting B. Transaction registers, inventory control C. Accounts receivable, accounts payable D. Any of the above

Ans:– D ,


Which command of DOS is used to sort the file in reverse order?
Options: SORT > filename,    SORT < filename,    SORT/R < filename,    SORT/V < filename

Ans:C ,C


How many simultaneous Telnet sessions does a Cisco router support by default?
Options: 2,    3,    4,    5

Ans:D ,D


Backing storage is so named because it
Options: is always kept at the back of the CP.U.,    is slow and backward,    backs up the computer's main memory,    lags behind the main memory

Ans:C ,C


When operating below its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated above its resonant frequency,    purely resistive circuit

Ans:B ,B


.Finding the location of the element with a given value is:
Options: A)Traversal b.Search c.Sort d.None of above

Ans:B,B


Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,


Most algorithms follow the format of
Options: Entering the input items, then displaying the input items, and then processing the output items,    Entering the input items, then processing the output items, and then displaying the output items,    Entering the input items, then processing the input items, and then displaying the output items,    Entering the output items, then displaying the output items, and then processing the output items

Ans:C ,C


To define what columns should be displayed in an SQL SELECT statement:
Options: use FROM to name the source table(s) and list the columns to be shown after SELECT.,    use USING to name the source table(s) and list the columns to be shown after SELECT.,    use SELECT to name the source table(s) and list the columns to be shown after USING.,    use USING to name the source table(s) and list the columns to be shown after WHERE.

Ans:A ,A


An inventory management system should answer the questions
Options: what and why,    when and how much,    who and why,    where and when

Ans:B ,B


How many copies of the database schema are typically used in the redesign process?
Options: One,    Two,    Three,    Four

Ans:C ,C


  Which of the following is not an option of the spelling dialog box?
Options: Ignore B. Ignore all C. Edit D. Change

Ans:– C ,


How many JDBC driver types does Sun define?
Options: One,    Two,    Three,    Four

Ans:D ,D


The most common binary code in use today is the 8 bit ASCII code. What do the letters ASCII stand for?
Options: American Standard Code for International Interchange,    American Standard Code for Information Interchange,    American Standard Code for Intelligence Interchange,    American Scientific Code for Information Interchange

Ans:B,B


. Which of the following store command to retrieve data from database?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:4 – c ,4 – c


What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Options: Full media,    Graphics media,    Multimedia,    Hypertext

Ans:C ,C


Is the following statement a declaration or definition? extern int i;
Options: Declaration,    Definition,    Function,    Error

Ans:A ,A


Change the _____ to create a document in wide format
Options: a. Page Orientation b. Page margins c. Paper Style d. Paper Source

Ans:– A,– A


The DROP TABLE statement:
Options: deletes the table structure only.,    deletes the table structure along with the table data.,    works whether or not referential integrity constraints would be violated.,    is not an SQL statement.

Ans:B ,B


Specify the 2 library functions to dynamically allocate memory?
Options: malloc() and memalloc(),    alloc() and memalloc(),    malloc() and calloc(),    memalloc() and faralloc()

Ans:C ,C


Which one of the following phrases most accurately describes a purely capacitive circuit?
Options: Resistances provide the only opposition to current flow,    Capacitive reactance provides the only opposition to current flow,    The ac voltage leads the current by 90 degree,    Combinations of resistance and capacitive reactance provide any opposition to current flow

Ans:B ,B


In laser printer technology, what happens during the conditioning stage?
Options: The corona wire places a uniform positive charge on the paper,    A uniform negative charge is placed on the photosensitive drum,    A uniform negative charge is placed on the toner,    All of the above

Ans:B ,B


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B ,B


The feasibilities studied in preliminary investigation is (are):
Options: technical feasibility,    economic feasibility,    operational feasibility,    All of the above

Ans:D ,D


Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:B ,B


Where have the program and data to be located before the ALU and control unit of a computer can operate on it?
Options: Internal memory,    Secondary memory,    Microprocessor,    Magnetic tapes

Ans:A ,A


A _____ is a formalized computer information system that can integrate data from various sources to provide the information necessary for management decision making.
Options: prompt,    passwords,    MIS,    Tactical

Ans:C ,C


If you need to hide some paragraphs, how can you do it?
Options:  A) From Paragraph dialog box, B) From Font dialog box, C) From Options Dialog box, D) None of above, 

Ans:-B,-B


. This is the menu command used to apply a design template in PowerPoint.
Options: a. Tools -> Slide Design b. Format -> Slide Design c. Insert -> Slide Design d. Insert -> Slide Design

Ans:7 – B ,7 – B


. A digital computer did not score over an analog computer in terms of
Options: A) Speed B) Accuracy C) Reliability D) Cost

Ans:B,B


Which of the following is not true of immediate processing?
Options: It is often used in real-time applications,    It can occur with either sequential of direct-access files,    It can be used in an airline-reservation system,    Transactions are processed shortly after a real-world event occurs

Ans:B,B


Communication that involves computers, establishing a link through the telephone system is called
Options: Teleprocessing,    Microprocessing,    Telecommunications,    All of the above

Ans:C ,C


Which of the following could be a valid DOS  file  specification?
Options: a. NOSFILE.POST b. NOSFILE.P.OST c. NOSFILE.DOC d. NOST.FILEDOC

Ans:  4 b.        ,  4 b.       


What command is used to print a file?
Options: lp,    pg,    prn,    print

Ans:A ,A


Which of the following special symbol allowed in a variable name?
Options: * (asterisk),    | (pipeline),    - (hyphen),    _ (underscore)

Ans:D ,D


If safety stock is 6 and the EOQ is 50, average inventory level is
Options: 80,    86,    85,    90

Ans:E ,E


A common boundary between two systems is called
Options: Interdiction,    Interface,    Surface,    None of the above

Ans:B ,B


When referring to instruction words, a mnemonic is:
Options: a short abbreviation for the operand address,    a short abbreviation for the operation to be performed,    a short abbreviation for the data word stored at the operand address,    shorthand for machine language

Ans:B ,B


. Which command will you use in PowerPoint if you need to change the color of different objects without changing content?
Options: a.  Design Template b.  Color Scheme c.  Font Color d.  Object Color

Ans:2 – B ,2 – B


Which of the following produces the best quality graphics reproduction?
Options: A) Laser printer B) Ink jet printer C) Plotter D) Dot matrix printer

Ans:-C,-C


When did arch rivals IBM and Apple Computers Inc. decide to join hands?
Options: 1978,    1984,    1990,    1991

Ans:D ,D


. The Width of a processor’s data path is measured in bits. Which of the following are common data paths?
Options: A) 8 bits B) 12 bits C) 16 bits D) 32 bits

Ans:A,A


What is the purpose of the PSH flag in the TCP header?
Options: Typically used to indicate end of message B. Typically used to indicate beginning of message C. Typically used to push the message D. Typically used to indicate stop the message

Ans:– A ,


Suppose the peak value of a sinusoidal voltage is 50 V. What is the rms value?
Options: 37.4 V,    35.4 V,    38.74 V,    30.4 V

Ans:B ,B


A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
Options: tables,    relations,    tuple,    both (a) and (b)

Ans:D ,D

www.000webhost.com