Which function is not available in the Consolidate dialog box?


Options: Pmt B. Average C. Max D. Sum

Ans:– A ,

More MS-Excel Related questions:


. What is the correct way to refer the cell A10 on sheet3 from sheet1?
Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Ans: – A ,


6.Foreign key is
Options: (A)Modular design of a software application that facilitates the integration of new modules (B) Showing a universal law or rule to be invalid by providing a counter example (C) A set of attributes in a database table that refers to data in another table (D) None of these 4

Ans:46. (C),46. (C)


Which of the following special shell variables is used to process number of the last background job?
Options: $!,    $#,    $0,    $*

Ans:A ,A


Mohiniattam dance from developed originally in which state?
Options: Tamil Nadu,    Orissa,    Kerala,    Karnataka

Ans:C,C


What script is run for setting bash global defaults for all users?
Options: /etc/.profile,    /etc/.bashrc,    /etc/.log,    /etc/profile

Ans:D ,D


The current gain of a transistor is defined as the ratio of the collector current to the
Options: base current,    emitter current,    supply current,    collector current

Ans:A ,A


1.A term used for diskette is
Options: (A)disk cartridge (B) disk pack (C) floppy disk (D) none of these 12

Ans:121. (C),121. (C)


Vikramaditya, a king of Ujjain, started the Vikrama samvat in 58 BC in commemoration of his victory over
Options: Indo-Greeks,    Sakas,    Parthinas,    Kushanas

Ans:B,B


who was last rular of kutlehar riyasat
Options: brij mohan pal, ajeet pal ,purn pal, kishan pal

Ans:brij mohan pal,brij mohan pal


. To select an entire column in MS-EXCEL, press?
Options: a. CTRL + C b. CTRL + Arrow key c. CTRL + S d. None of the above

Ans:– d,– d


Who was named as the ICC Emerging Player of the Year 2004?
Options: Piyush Chawla,    Gautam Gambhir,    Irfan Pathan,    Suresh Raina

Ans:C,C


. In help menu of Excel, which of the following tabs are found?
Options: a. Contents tab b. Answer Wizard tab c. Index tab d. all of the above.

Ans:– d,– d


A packet switching network that was sponsored by the Commission of the EEC and became operational in 1979 is
Options: LAN,    Broadband network,    Star network,    Euronet

Ans:D ,D


396. madhubanee chitrakala shailee jo janata kee sthiti hai?
Options: NA

Ans: bihaar, bihaar


. To save an existing document with a different file name, click _____.
Options: a. the Save button on the Standard toolbar b. Save on the File menu c. the Save As button on the Standard toolbar d. Save As on the File menu

Ans: – D , – D


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

Ans:D ,D


What is the name of the temporary data storage area between a peripheral device and the CPU which compensates for the difference between their speeds?
Options: Backing storage,    Buffer,    Main storage,    Temporary storage

Ans:B,B


The complexity of Bubble sort algorithm is
Options: A)O(n) b.O(log n) c.O(n2) d.O(n log n)

Ans:C, O(n2)


0.Banker’s algorithm for resource allocation deals with
Options: (A)deadlock prevention (B) deadlock avoidance (C) deadlock recovery (D) mutual exclusion 22

Ans:220. (B),220. (B)


. The first digital computer built with IC chips was known as
Options: A) IBM 7090 B) Apple ? 1 C) IBM System / 360 D) VAX-10

Ans:C,C


9.The word size of a microprocessor refers to:
Options: (A)the number of machine operations performed/ second (B) the amount of information that can be stored / cycle (C) the amount of information that can be stored in bytes (D) none of these 6

Ans:59. (B),59. (B)


2.Multithreading allows
Options: (A)To run threads concurrently (B) To run threads independently (C) A is true, B is false (D) A and B both true. 4

Ans:42. (D),42. (D)


Point out the error in the program. #include<stdio.h> int main() { const int x; x=128; printf("%d\n", x); return 0; }
Options: Error: unknown data type const int,    Error: const variable have been initialised when declared.,    Error: stack overflow in x,    No error

Ans:B ,B


4.A pictorial representation that uses predefined symbols to describe either the logic of a computer program or the data flow and processing steps of a system is referred as
Options: (A)Flowchart (B) Algorithm (C) Program (D) None of these 2

Ans:24. (A),24. (A)


Trailer labels contain
Options: file identification,    retention period,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


The network address of 172.16.0.0/19 provides how many subnets and hosts?
Options: 7 subnets, 30 hosts each,    8 subnets, 8,190 hosts each,    8 subnets, 2,046 hosts each,    7 subnets, 2,046 hosts each

Ans:B ,B


B. C. Roy Award is given in the field of
Options: Music,    Journalism,    Medicine,    Environment

Ans:C,C


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

Ans:A ,A


Which of the following is not a key component of the evaluation process in building a DSS?
Options: criteria for evaluation,    means of measuring system-development time spent on the project,    means of monitoring the progress of the DSS,    formal review process

Ans:B ,B


The Turnaround is
Options: the elapsed time between the receipt of the input and the availability of the output,    a group of related fields,    the key information of programming,    a program statement that violates one or more rules of the language in which it is written

Ans:A ,A


The common practice is to maintain
Options: one generation of data files,    two generations of data files,    three generations of data files,    batch processing

Ans:B ,B


1925 ee (dekkan kveen)
Options: NA

Ans: 875. bhaarat mein kul relamaarg kee lambaee kitanee hai?, 875. bhaarat mein kul relamaarg kee lambaee kitanee hai?


7.ANSI (American National Standards Institute) is
Options: (A)It supports system modeling during the analysis and design stages of the software process (B) Organization responsible for approving U.S. standards (C) Stimuli that occurs irregularly (D) Formalized set of software calls and routines that can be referenced by an application program in order to access supporting system or network services 3

Ans:37. (B),37. (B)


A capacitor is measured in which of the following units?
Options: Volts,    Ohms,    Farads,    Resistance

Ans:C ,C


CD-ROM is a
Options: A) Semiconductor memory B) Memory register C) Magnetic memory D) None of above

Ans:-D,-D


Microsoft Office Suite spreadsheet program is
Options: (A) Microsoft Excel (B) Microsoft Word (C) Microsoft Powerpoint (D) None of these 9..

Ans:8. (A),8. (A)


writer of political histry of bilaspur
Options: akshar singh, anand chand, narotam singh, rahul sankrityan

Ans:narotam singh,narotam singh


What is the benefit of the Networking?
Options: File Sharing B. Easier access to Resources C. Easier Backups D. All of the Above

Ans:– D ,


. What is the symbol for dividing? A ./ B. % C. & D. #
Options: A ./ B. % C. & D. #

Ans:– A ,/


The south temperature zone is a region lying between
Options: the Tropic of Capricorn and the Antarctic circle,    the Antarctic circle and the South pole,    the Tropic of Cancer and the tropic of Capricorn,    the Tropic of Capricorn and the equator

Ans:A,A


Thomas Cup is associated with
Options: badminton,    billiards,    lawn tennis,    table tennis

Ans:A,A


What command is used to remove the directory?
Options: rdir,    remove,    rd,    rmdir

Ans:D ,D


Stepping motors:
Options: can run at varying speeds,    can be built to index different amounts by changing the pole configuration,    can run both clockwise and counterclockwise,    do not require commutators

Ans:E ,E


A supertype/subtype hierarchy has which of the following features?
Options: Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.,    Attributes are assigned at the highest logical level.,    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.,    Attributes are assigned at the lowest logical level.

Ans:B ,B


56. After typing header text, how can you quickly enter footer text?
Options: a. Press PageDown key and type the text for footer b. Click on Switch between Heeder & Footer then type the text c. Both of above d. None of above

Ans:– C ,– C


Which of the following is a type of DBMS software?
Options: database manipulation language,    query language,    utilities,    report writer

Ans:A ,A


A retailing business involves which of the following functions?
Options: engineering,    maintenance,    plant operations,    All of the above

Ans:B ,B


Point out the error in the program. #include<stdio.h> #include<stdlib.h> union employee { char name[15]; int age; float salary; }; const union employee e1; int main() { strcpy(e1.name, "K"); printf("%s", e1.name); e1.age=85; printf("%d", e1.age); printf("%f", e1.salary); return 0; }
Options: Error: RValue required,    Error: cannot modify const object,    Error: LValue required in strcpy,    No error

Ans:B ,B


0.Text Editor that is the part of Windows operating system
Options: (A)Wordpad (B) Notepad (C) Adobe Photoshop (D) Jasc Paint Shop 1

Ans:10. (B),10. (B)


  The arrangement of elements such as Title and subtitle text, pictures, tables etc. is called :
Options: Layout B. Presentation C. Design D. Scheme

Ans:– A ,

www.000webhost.com