. How do you rearrange the data in ascending or descending order?


Options: Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

Ans: – A ,






More MS-Excel Related questions:


What is route poisoning?
Options: It sends back the protocol received from a router as a poison pill, which stops the regular updates.,    It is information received from a router that can't be sent back to the originating router.,    It prevents regular update messages from reinstating a route that has just come up.,    It describes when a router sets the metric for a downed link to infinity.

Ans:D ,D


Routing tables of a router keeps track of
Options: MAC Address Assignments B. Port Assignments to network devices C. Distribute IP address to network devices D. Routes to use for forwarding data to its destination

Ans:– D ,


. Poor response time are usually caused by
Options: a. Process busy b. High I/I rates c. High paging rate d. Any of the above

Ans:9 – d ,9 – d


Sales figures in the market forecast file are updated by the
Options: sales forecasting procedures,    sales analysis procedures,    market research procedures,    all of the above

Ans:B ,B


Which of the following is intended to be used in all applications runs on mainframe computers.
Options: LOGO,    APL,    PL/1,    OCCAM

Ans:C,(Canswer


. If the cell B1 contains the formula = $A$1, which of the following statements is true
Options: There is a relative reference to cell A1 B. There is an absolute reference to cell A1 C. Further changes in value of A1 will not affect the value of B1 D. Further changes in value of B1 will affect the value of A1

Ans:– B ,


The merging of a free electron and a hole is called
Options: Covalent bonding,    Lifetime,    Recombination,    Thermal energy

Ans:C ,C


To use your keyboard instead of the mouse to select tools on the ribbon, you display the KeyTips by pressing the _____________key?
Options: a. Alt b. Ctrl c. Shift+Enter d. Alt+Enter

Ans:– A,– A


A  Animation Schemes can be applied to ________ in the presentation.
Options: a. All slides, B. Select slides, C. Current Slide, D. All of the above

Ans:D ,All of the above


Ergonomics refers to:
Options: the human aspect of the environment around the workstation as well as the workstation itself,    the cost relationship of the workstation versus productivity,    the level of involvement the operator has with the workstation,    the technology involved in the workstation itself

Ans:A ,A


Excel probably considers the cell entry January 1, 2000 to be a
Options: a. Label b. Value c. Formula d. Text string

Ans:#8211; b,#8211; b


Ctrl + Q
Options: a. Paragraph formatting (Line Space and Paragraph Space) b. Close Word Application without saving Document c. Print Whole Document without confirmation d. Does nothing

Ans:–  A,–  A


Data System management has long-term viability as a separate business function because
Options: It requires much technical knowledge,    It requires large investments,    Specialists in data systems cannot be integrated into a marketing or manufacturing organization,    An integrated database accessible to all requires independent management

Ans:D ,D


Which of the declaration is correct?
Options: int length;,    char int;,    int long;,    float double;

Ans:A ,A


. Which is not executable file?
Options: a. .com b. .exe c. .bat d. .txt

Ans:3 – d ,3 – d


The following are components of a database except ________ .
Options: user data,    metadata,    reports,    indexes

Ans:C ,C


Which of the following condition is used to transmit two packets over a medium at the same time?
Options: Contention,    Collision,    Synchronous,    Asynchronous

Ans:B ,B


Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options: Minimum cardinality,    Maximum cardinality,    ERD,    Greater Entity Count (GEC)

Ans:B ,B


A microprocessor unit, a memory unit, and an input/output unit form a:
Options: CPU,    compiler,    microcomputer,    ALU

Ans:C ,C


A greater proportion of time is spent in planning on the
Options: top management level,    middle management level,    lower management level,    All of the above

Ans:A ,A


. Which of the following statement is false?
Options: A) Mechanical analog computers have existed for thousands of years B) There are mechanical analog computers and electronic analog computers. C) All electronic computers are digital computers D) All of above are false

Ans:C,C


. What is meant by a dedicated computer?
Options: A) Which is used by one person only B) Which is assigned one and only one task C) Which uses one kind of software D) Which is meant for application software

Ans:B,B


Which one of the following statements is true?
Options: The secondary voltage for a step-down power transformer is greater than the primary voltage,    The secondary current for a step-down power transformer is greater than the primary voltage,    Parallel RLC circuit operated below its resonant frequency,    purely resistive circuit

Ans:B ,B


. To drag a selected range of data to another worksheet in the same workbook, use the
Options: a. Tab key b. Alt key c. Shift key d. Ctrl key

Ans:– d,– d


In DOS, what key would you press to step through the Config.sys and Autoexec.bat?
Options: F1,    F3,    F5,    F8

Ans:D ,D


Pressing F8 key for three times selects
Options:  A) A word, B) A sentence, C) A paragraph, D) Entire document,

Ans:B,B


Compared to analog signals, digital signals
Options: allow faster transmission,    are more accurate,    both (a) and (b),    All of the above

Ans:C ,C


Which number system is usually followed in a typical 32-bit computer?
Options:  Binary B.  Decimal C.  Hexadecimal D.  Octal

Ans:– A ,


. In databases, Locking level is also called as
Options: a. Granularity b. S lock c. X lock d. Dead lock

Ans:– a,– a


. 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


0. What is the use of “All Caps” feature in MS-Word?
Options: It changes all selected text into Capital Letter B. It adds captions for selected Image C. It shows all the image captions D. None of the above

Ans: – A ,


When a parallel RLC circuit is operating at its resonant frequency:
Options: capacitive reactance is greater than the inductive reactance,    inductive reactance is greater than the capacitive reactance,    inductive reactance is equal to the capacitive reactance,    the difference between inductive and capacitive reactance is equal to the resistance

Ans:C ,C


. __________ is the clear leader for personal databases.
Options: a. Microsoft Access b. Microsoft FoxPro c. Borland dBase d. MySQL

Ans:5 – a ,5 – a


A language based on graphics for use in education is
Options: PROLOG,    LOGO,    COBOL,    BASIC

Ans:B ,B


LISP was developed by
Options: John Mc Carthy,    Blaise Pascal,    Dr. Hollerith,    John Napier

Ans:A ,A


The Second Generation Computer was based on ________.
Options: Vacuum Tube B. Silicon Chips C. Transistor D. Bio Chips

Ans:– C ,


A greater proportion of time spent in directing on the
Options: top management level,    middle management level,    lower management level,    All of the above

Ans:C ,C


A computer program consists of
Options: System flowchart,    Program flowchart,    Algorithms written in computer's language,    Discrete logical steps.

Ans:C ,C


Top-down programming is
Options: a group of related fields,    a map of the programmer's view of the data,    an approach in which the top module is first tested then program modules are added from the highest level to the lowest level,    a series or group of components that perform one or more operations of a more complex system

Ans:C ,C


The data model that is produced from reverse engineering is:
Options: a conceptual model.,    an internal model.,    a logical model.,    None of the above is correct.

Ans:D ,D


. Which of the following best describes the contents of a mail merge main document?
Options: a. Information that is unique for every form letter created b. Information that is same for every form letter created c. Styles and fonts for the data source d. None of above

Ans: – B , – B


Modems use transmission.
Options: synchronous,    asynchronous,    timed interval,    ata

Ans:B ,B


During the boot process, a system first counts memory from where?
Options: Expansion memory board,    Video adapter,    System board,    Cache

Ans:C ,C


The database administration function includes
Options: application programming,    computer operations management,    database access planning,    All of the above

Ans:C ,C


To verify that the note text is positioned correctly on the page, switch to _____ view or display the document in print preview.
Options: a. normal b. print layout c. page layout d. page edit

Ans:– B,– B


. When you see a cell with a red triangle in the top right corner, what does this signify?
Options: a. There is an error in the cell b. There is a comment associated with the cell c. The font color for text in the cell is red d. A formula cannot be entered into the cell

Ans:– b,– b


The IC was invented at Texas instruments in year 1958 by
Options: Jaik Kilby,    Clive Sinclair,    John Napier,    Steve Wozniak

Ans:A ,A


In an Entity-Relationship Diagram Rectangles represents
Options: Entity sets B. Attributes C. Database D. Tables

Ans:– A ,


48. Which option is not available in Insert Table Autofit behavior?
Options: a. Fixed Column Width b. AutoFit to Contents c. Autofit to Window d. Autofit to Column

Ans:– D ,– D


Who developed a mechanical device in the 17th century that could add, subtract, multiply, divide and find square roots?
Options: Napier,    Babbage,    Pascal,    Leibnitz

Ans:D ,D

www.000webhost.com