. In order to perform a calculation in a spreadsheet, you need to use a:


Options: table B. formula C. field D. variable

Ans: – B ,

More MS-Excel Related questions:


Computers built before the First Generation of computers were:
Options: Mechanical B. Electro-mechanical    C. Electrical D. None of these

Ans:– B ,


When UPC is used, the price of the item is located
Options: on the item,    on the item and on the shelf,    in computer storage,    on the shelf and in computer storage

Ans:D ,D


How many runs did Sachin Tendulkar was scored in his ODI debut?
Options: 140,    0,    23,    1

Ans:B,B


Waveforms are graphs that show:
Options: frequency on the vertical axis and amplitude on the horizontal axis,    amplitude on the vertical axis and frequency on the horizontal axis,    amplitude on the vertical axis and the passage of time on the horizontal axis,    the passage of time on the vertical axis and amplitude on the horizontal axis

Ans:C ,C


How many bits can be stored in the 8K RAM?
Options: 8000,    8192,    4000,    4096

Ans:B ,B


. … are list of commands that appear on the screen
Options: a. GUIS b. Icons c. Menus d. Windows

Ans:6 – c ,6 – c


Labour standards are provided by
Options: IE time and motion study,    analysis of historical data,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


. What are the two types of Semaphore?
Options: a. Digital Semaphores and Binary Semaphores b. Analog Semaphores and Octal Semaphores c. Counting Semaphores and Binary Semaphores d. Critical Semaphores and System Semaphores

Ans:0 – c ,0 – c


Which of the following correctly represents a long double constant?
Options: 6.68,    6.68L,    6.68f,    6.68LF

Ans:B ,B


. Worksheet can be renamed by
Options: Adding ? symbol at the end of filename while saving workbook B. Click on Worksheet tab by Holding CTRL Key and type new name C. Double Click on the Worksheet tab and type new name D. Worksheet cannot renamed

Ans:– C ,


9.The following piece of hardware is used as input phase of a computer-based information system
Options: (A)Printer (B) Diskette (C) Monitor (D) Keyboard 12

Ans:119. (D),119. (D)


4.Integrated is
Options: (A)The amount of information with in data as opposed to the amount of redundancy or noise (B) One of the defining aspects of a data warehouse (C) Restriction that requires data in one column of a database table to the a subset of another-column. (D) None of these 5

Ans:54. (B),54. (B)


Which would you choose to create a bar diagram?
Options: Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Ans:– B ,


. Who used punched cards practically for the first time in the history of computers?
Options: A) Charles Babbage B) Dr. Herman Hollerith C) Howard Aikin D) Joseph Jacquard

Ans:5-B,5-B


balh valley in which district
Options: kinnaur , lahul, kullu, chamba, mandi

Ans:mandi,mandi


Environmental information is especially important to
Options: top-level managers,    middle-level managers,    low-level managers,    All of the above

Ans:A ,A


. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Options: a. Unfreeze panes command on the window menu b. Freeze panes command on the window menu c. Hold titles command on the edit menu d. Split command on the window menu

Ans:– b,– b


649. kis maulik adhikaar ko 44ven sanvidhaan sanshodhan dvaara hata diya gaya?
Options: NA

Ans: sampatti ka adhikaar, sampatti ka adhikaar


. Which of the following data type is used to store logical value in MS Access?
Options: a. True/False b. On/Off c. Yes/No d. All of Above

Ans:– c,– c


. It is used to explorer the contents of computer, drives as well as manage files
Options: a. b. My Document c. My Computer d. My Network Place

Ans:9 – b ,9 – b


A hand-held device which reads marks or characters on paper by detecting photo-sensitivity is known as
Options: Light pen,    Optical-wand,    Plotter,    All of the above

Ans:B ,B


Before any changes to database structure are attempted one should first:
Options: clearly understand the current structure and contents of the database only.,    test any changes on a test database only.,    create a complete backup of the operational database only.,    All of the above should be done.

Ans:D ,D


The files required to maintain general ledger records include
Options: inventory file,    detail postings file,    chart of accounts file,    all of the above

Ans:B ,B


Modern Indo-Aryan languages are based on an ancient language called
Options: Hindi,    Sanskrit,    Kannada,    Tamil

Ans:B,B


Which of the following operations can be performed on the file "NOTES.TXT" using the below code? FILE *fp; fp = fopen("NOTES.TXT", "r+");
Options: Reading,    Writing,    Appending,    Read and Write

Ans:D ,D


The first electronic digital computer contained?
Options: Electronic valves,    Vacuum tubes,    Transistors,    Semiconductor memory

Ans:B ,B


4.A workflow model represents
Options: (A)Sequence of activities (B) Role of users involved (C) Set of activities (D) None of these

Ans:4. (A),4. (A)


. Which mode sizes an image to fit the control while maintaining the proportions of the original image?
Options: a. Clip b. Fit c. Stretch d. Zoom

Ans:8 – d ,8 – d


The disadvantage of dynamic RAM over static RAM is
Options: higher power consumption,    variable speed,    need to refresh the capacitor charge every once in two milliseconds,    higher bit density

Ans:C ,C


A group of 2m - 1 routers are interconnected in a centralized binary tree, with router at each tree node. Router I communicate with router J by sending a message to the root of the tree. The root then sends the message back down to J. Then find the mean router-router path length.
Options: 2 (m - 2),    2 (2m - 1),    m - 1,    (2m - l)/mJ

Ans:A ,A


The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B


. What is the shortcut key to insert a new comment in a cell?
Options: F2 B. Alt + F2 C. Ctrl + F2 D. Shift + F2

Ans:– D ,


'Mandi House' is a
Options: the office of the P.M.,    the office of Director General of Doordarshan,    the office of NFDC,    the Doordarshan C.P.C

Ans:B,B


3.A control model, where one system is designed as the system controller and has responsibility for managing the execution of other sub-systems can be referred as
Options: (A)Centralized control model (B) Call-return control model (C) Object oriented model (D) None of these 9

Ans:93. (A),93. (A)


A memory bus is mainly used for communication between
Options: processor and memory,    processor and I/O devices,    I/O devices and memory,    input device and output device

Ans:A ,A


Which of the following is used for serial access storage only?
Options: RAM,    Magnetic tape,    Magnetic disk,    Core memory

Ans:B,B


In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:A ,A


The SQL keyword BETWEEN is used:
Options: for ranges.,    to limit the columns displayed.,    as a wildcard.,    None of the above is correct.

Ans:A ,A


Most important advantage of an IC is its
Options: Easy replacement in case of circuit failure,    Extremely high reliability,    Reduced cost,    Low power consumption

Ans:B,(Banswer


0.In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Options: (A)Unfreeze panes command on the window menu (B) Freeze panes command on the window menu (C) Hold titles command on the edit menu (D) Split command on the window menu 20

Ans:200. (B),200. (B)


An integrated circuit is
Options: a complicated circuit,    an integrating device,    much costlier than a single transistor,    fabricated on a tiny silicon chip

Ans:D,D


The two classifications of inputs are
Options: energies and maintenance,    maintenance and waste,    maintenance and signal,    products and waste

Ans:C ,C


A compiler for a high-level language that runs on one machine and produces code for a different machine is called
Options: optimizing compiler,    one pass compiler,    cross compiler,    multipass compiler

Ans:C ,C


.Which of the following data structure is not linear data structure?
Options: A)Arrays b.Linked lists c.Both of above d.None of above

Ans:D,D


Production of chlorofluorocarbons (CFC) gas which is proposed to be banned in India, is used in which of the following domestic products?
Options: Television,    Refrigerator,    Tube light,    Cooking gas

Ans:B,B


What is the purpose of fflush() function.
Options: flushes all streams and specified streams.,    flushes only specified stream.,    flushes input/output buffer.,    flushes file buffer.

Ans:A ,A


In 1985, the famous chess player David Levy beat a world champion chess program in four straight games by using orthodox moves that confused the program. What was the name of the chess program?
Options: Kaissa,    CRAY BLITZ,    Golf,    DIGDUG

Ans:B ,B


. Which command does not exist in DOS?
Options: a. Sum b. CLS c. CD d. Dir

Ans:3 – a ,3 – a


  MICR stands for A.  Magnetic Ink Character Reader B.  Magnetic Ink Code Reader C.  Magnetic Ink Case Reader D.  None of the above
Options: Keyboard B. System Bus C. Monitor D. Memory

Ans:– A ,


1.The Windows 2000, operating system supports
Options: (A)Multiple user processes with single thread per process. (B) Multiple processes with multiple thread per process. (C) Single process with single thread. (D) Single process with multiple threads. 2

Ans:21. (B),21. (B)

www.000webhost.com