. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.


Options: The Settings tab under the menu Format -> Cells B. The Settings tab under the menu Data -> Validation C. The Settings tab under the menu Data -> Filter -> Advanced Filter D. the Settings tab under the menu Format -> Conditional Formatting

Ans:– B ,

More MS-Excel Related questions:


Managers who are potential users of the MIS
Options: select the optimum equipment configurations,    evaluate alternate equipment configurations,    describe information needs,    All of the above

Ans:E ,E


. A _____ is a collection of predefined design elements and color schemes.
Options: a. feature b. hyperlink c. palette d. theme

Ans:– D,– D


3.Comparing with secondary storage, primary storage is
Options: (A)slow and inexpensive (B) fast and inexpensive (C) fast and expensive (D) slow and expensive 12

Ans:123. (C),123. (C)


Ctrl + E
Options: Exit Application B. Select All C. Clear All D. Align Center

Ans:– D ,


. What does the expression [detail] ! [product] * 1.30 do?
Options: a. multiplies the contents of detail and product fields by 1.3 b. First divides detail by product and then multiplies by 1.3 c. multiplies the contents of detail in the product table by 1.3 d. multiplies the contents of product in the detail table by 1.3

Ans:– d,– d


If you wanted to deny all Telnet connections to only network 192.168.10.0, which command could you use?
Options: access-list 100 deny tcp 192.168.10.0 255.255.255.0 eq telnet ,    access-list 100 deny tcp 192.168.10.0 0.255.255.255 eq telnet,    access-list 100 deny tcp any 192.168.10.0 0.0.0.255 eq 23,    access-list 100 deny 192.168.10.0 0.0.0.255 any eq 23

Ans:C ,C


The total impedance of a parallel RLC circuit:
Options: always increases as the applied frequency increases,    is equal to the sum of the values of resistance, inductive reactance and capacitive reactance,    always decreases as the applied frequency increases,    is maximum at the resonant frequency

Ans:D ,D


Which of the following statement is false?
Options:  A) You can set different header footer for even and odd pages, B) You can set different page number formats for different sections, C) You can set different header footer for first page of a section, D) You can set different header and footer for last page of a section,

Ans:-D,-D


An application program interface (API) is which of the following?
Options: The same thing as ODBC.,    Middleware that does not provide access to a database.,    Middleware that provides access to a database.,    The same thing as JDBC.

Ans:C ,C


4.A data structure where elements can be added or removed at either end but not in the middle is referred as
Options: (A)Linked lists (B) Stacks (C) Queues (D) Deque 4

Ans:44. (D),44. (D)


. Which of the following are the two main components of the CPU?
Options: A) Control Unit and Registers B) Registers and Main Memory C) Control unit and ALU D) ALU and bus

Ans:C,C


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

Ans: bihaar, bihaar


Where can you change the vertical alignment?
Options: a. Formatting toolbar b. Paragraph dialog box c. Page Setup dialog box d. Standard toolbar

Ans:– C,– C


What will be the output of the program? #include<stdio.h> #include<stdlib.h> int main() { union test { int i; float f; char c; }; union test *t; t = (union test *)malloc(sizeof(union test)); t->f = 10.10f; printf("%f", t->f); return 0; }
Options: 10,    Garbage value,    10.100000,    Error

Ans:C ,C


Alaayan Duhangan is tributry river of which river and falls in which state
Options: mandi, lahaul, Kullu, shimla

Ans:C,Kullu


. Data can be import into Access Database from
Options: a. Word Files b. Excel Files c. PowerPoint Files d. HTML Files

Ans:– b,– b


The nuclear particles which are assumed to hold the nucleons together are
Options: electrons,    positrons,    neutrons,    mesons

Ans:D,D


The text of the document called Mahzar, by which Akbar assumed the role of supreme arbiter in the matters of religion is found in
Options: Nizamuddin's Tabaqat-I-Akbari,    Arif Quandahari's Tarikh-I-Alfi,    Abul Fazl's Akbarnama,    Badauni's Muntakahab-ut-Tawarikh

Ans:C,C


Flood guns bombard the phosphor surface of the tube in which one of the following types of CRT technology?
Options: Direct view storage tube,    Raster scan CRT,    Refresh-vector CRT,    Stroke CRT

Ans:A ,A


Which one of the following was associated with INA?
Options: NA

Ans:Bakshi Pratap Singh,Bakshi Pratap Singh


The transistor has a collector current of 2 mA. If the current gain is 135, what is the base current?
Options: 14.8 µA,    10.3 µA,    7.8 µA,    7.75 µA

Ans:A ,A


5.In Excel which is not an advantage of using computerized spreadsheets?
Options: (A)Flexibility of moving entries (B) Speed of calculation (C) Ability of generate tables (D) Cost of initial setup 9

Ans:95. (D),95. (D)


Which of the following locks the item from change but not from read?
Options: Implicit lock,    Explicit lock,    Exclusive lock,    Shared lock

Ans:D ,D


How would you allow device drivers and TSR's to be loaded into Upper Memory Blocks ?
Options: DOS=High,    devicehigh=,    loadhigh=,    DOS=UMB

Ans:D ,D


4.In Excel to create a formula, you can use
Options: (A)Values but not cell references (B) Cell references but not values (C) Values or cell references although not both at the same time (D) Value and cell references 21

Ans:214. (D),214. (D)


272. maanav shareer kee sabase badee granthi ka naam kya hai?
Options: NA

Ans: yakrt, yakrt


Assuming 100% efficiency, what is the power being consumed at the secondary winding of the transformer described in question 91?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A


The plants of which of the following crops are highly sensitive to frost?
Options: Barely,    Cotton,    Maize,    None of the above

Ans:B,B


What is the highest address possible if 16 bits are used for each address?
Options: 65536,    12868,    16556,    643897

Ans:A,A


When was the first cricket Test match played?
Options: 1873,    1877,    1870,    1788

Ans:B,B


Two of the major processing languages are PROLOG and:
Options: LISP,    COBOL,    BASIC,    Pascal

Ans:A ,A


. Which was the world’s first microcomputer that used Intel 80386 microprocessor chip?
Options: A) IBM PS/2 B) HP-9830 C) DeskPro-386 D) IBM-360

Ans:5-C,5-C


Who is the author of the book 'Freedom Behind Bars'?
Options: Kiran Bedi,    Jawaharlal Nahru,    Sheikh Abdullah,    Nelson Mandela

Ans:A,A


D/A (digital to analog) conversion:
Options: results in a binary code as the final output,    has to be sampled at 1/2 the highest input frequency,    must be fed through a filter to reproduce the original signal accurately,    both (b) and (c)

Ans:C ,C


The processes at the most detailed level of the data flow diagrams are called
Options: transform descriptions,    functional primitives,    data flows,    interfaces

Ans:B ,B


The difference between a multiplexer and a statistical multiplexer is
Options: Statistical multiplexers need buffers while multiplexers do not need buffers,    Multiplexer use X.25 protocol, while statistical multiplexers use the Aloha protocol,    Multiplexers often waste the output link capacity while statistical multiplexers optimize its use,    Multiplexers use Time Division Multiplexing (TDM) while statistical multiplexers use Frequency Division Multiplexing (FDM)

Ans:A ,A


The Al researcher who co-authored both the Handbook of Artificial Intelligence and The Fifth Generation is:
Options: Bruce Lee,    Randy Davis,    Ed Feigenbaum,    Mark Fox

Ans:C ,C


While working with MS-DOS, which command is used to display the contents of a file and pause the display after each screenful of information?
Options: TYPE filename | MORE,    CAT filename | MORE,    CAT filename | pg,    MORE filename

Ans:A ,A


Robert Koch worked on
Options: tuberculosis,    cholera,    malaria,    diabetes

Ans:A,A


6.A binary numbers are represented by
Options: (A)Digits 0 and 1 (B) Digits 0,1,….,8 (C) Digits A,B, C,… (D) None of these 16

Ans:166. (A),166. (A)


3.Memo in window programming
Options: (A)does nothing except draw a rectangle, it is used to visually group controls together (B) displays text (C) for input of multiple lines of text (D) none of these | 133 1

Ans:13. (C),13. (C)


You are working with a class C network. You are required to configure it for five subnets, each of which will support 25 nodes. What subnet should you use?
Options: 255.255.255.0,    255.255.255.224,    255.255.255.240,    255.255.255.248

Ans:B ,B


Which of the following is not a practical data-processing approach?
Options: batch-sequential,    batch-direct,    immediate-sequential,    immediate-direct

Ans:C ,C


Moment of inertia is
Options: vector,    scalar,    phasor,    tensor

Ans:D,D


Which one of the following statements is true for the currents in a series RC circuit?
Options: The current always has the same amplitude and phase for every part of the circuit,    The total current is equal to the sum of the currents for the resistance and capacitance,    The total current is greater than the sum of the currents for the resistance and capacitance,    The total current is less than the sum of the currents for the resistance and capacitance

Ans:A ,A


What will be the output of the program? #include<stdio.h> int main() { char huge *near *ptr1; char huge *far *ptr2; char huge *huge *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(ptr2), sizeof(ptr3)); return 0; }
Options: 4, 4, 8,    2, 4, 4,    4, 4, 2,    2, 4, 8

Ans:B ,B


. Which of the following is used only for data entry and storage, and never for processing?
Options: A) Mouse B) Dumb terminal C) Micro computer D) Dedicated data entry system

Ans:B,B


What will be the output of the program? #include<stdio.h> int fun(int **ptr); int main() { int i=10; const int *ptr = &i; fun(&ptr); return 0; } int fun(int **ptr) { int j = 223; int *temp = &j; printf("Before changing ptr = %5x\n", *ptr); const *ptr = temp; printf("After changing ptr = %5x\n", *ptr); return 0; }
Options: Address of i Address of j,    10 223,    Error: cannot convert parameter 1 from 'const int **' to 'int **',    Garbage value

Ans:C ,C


Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What’s the difference between the two?
Options:  A) Both are same. They are only two different ways of capitalize text., B) It is faster to convert from Change Case than from Font dialog box, C) Change Case makes conversion permanent but All Caps on Font can always be reverted, D) All Caps on Font dialog box makes the change permanent where Change Case can be always reverted, 

Ans:-C,-C


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)

www.000webhost.com