To return the remainder after a number is divided by a divisor in EXCEL we use the function?


Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,

More MS-Excel Related questions:


What is the name given to the weapons which use computerised guidance system?
Options: Guided weapons,    Smart weapons,    Dumb weapons,    Starwars weapons

Ans:B ,B


Where did the 1st ODI match was played in India?
Options: New Delhi,    Ahmedabad,    Kolkata,    Mumbai

Ans:B,B


Made from a variety of materials, such as carbon, which inhibits the flow of current...?
Options: Choke,    Inductor,    Resistor,    Capacitor

Ans:C,C


Kalinga Award was instituted by
Options: UNESCO for exceptional contribution of efforts to popularise science,    Indian Military.,    Jnanpith, a cultural literacy society for encouraging creative writing in modern languages,    Indian Adult Education Association for outstanding contribution of adult literacy in India

Ans:A,A


Which encapsulations can be configured on a serial interface? Ethernet Token Ring HDLC Frame Relay PPP
Options: 1 and 4,    2 only,    3, 4 and 5,    All of the above

Ans:C ,C


When was vacuum tube invented?
Options: A) 1900 B) 1906 C) 1910 D) 1880

Ans:-B,-B


Giri Vata
Options:

Ans:Sirmour,Sirmour


To print out a and b given below, which of the following printf() statement will you use? #include<stdio.h> float a=3.14; double b=3.14;
Options: printf("%f %lf", a, b);,    printf("%Lf %f", a, b);,    printf("%Lf %Lf", a, b);,    printf("%f %Lf", a, b);

Ans:A ,A


Which one of the following is a statement of Kirchhoffs current law?
Options: The current through a resistance is proportional to the value of resistance and the IR drop across it,    The total current in a parallel circuit is less than the value of the smallest current,    The algebraic sum of currents in a loop is equal to zero,    The algebraic sum of currents entering and leaving a point is equal to zero

Ans:C ,C


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

Ans:C ,C


The three key elements for a graphics workstation include the host processor, display controller, and:
Options: mouse,    keyboard,    CRT,    digitizer

Ans:C ,C


Epoxy resins are used as
Options: detergents,    insecticides,    adhesives,    moth repellents

Ans:C,C


IBM released its first PC in 1981. Can you name the operating system which was most popular at that time?
Options: MS-DOS,    PC-DOS,    OS/360,    CP/M

Ans:D ,D


. Which of the following shortcuts can be used to insert a new line in the same cell?
Options: a. Enter b. Alt + Enter c. Ctrl + Enter d. Shift + Enter

Ans:– b,– b


What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C


Benefits from a computerised MIS include:
Options: higher returns on short-term investments,    less frequent and smaller short-term loans,    lower rates of interest,    All of the above

Ans:D ,D


Which one of the following is a search engine?
Options: Macromedia Flash,    Google,    Netscape,    Librarians’ Index to the Internet

Ans:B,B


On executing the below program what will be the contents of 'target.txt' file if the source file contains a line "To err is human"? #include<stdio.h> int main() { int i, fss; char ch, source[20] = "source.txt", target[20]="target.txt", t; FILE *fs, *ft; fs = fopen(source, "r"); ft = fopen(target, "w"); while(1) { ch=getc(fs); if(ch==EOF) break; else { fseek(fs, 4L, SEEK_CUR); fputc(ch, ft); } } return 0; }
Options: r n,    Trh,    err,    None of above

Ans:B ,B


Which of the following countries won the final of the triangular cricket series held in durban in februarry 1997?
Options: India,    New zealand,    South africa,    Zimbabwe

Ans:C,C


When was Apple Macintosh II microcomputer introduced in the market?
Options: 1964,    1970,    1983,    1986

Ans:C,C


The dronacharya award is given to ?
Options: NA

Ans:coachs ,coachs


What command do you use to add routes to a Linux router?
Options: addroute,    route,    netstat,    net

Ans:B ,B


In which year was UK's premier computing event called "The Which Computer" started?
Options: 1980,    1985,    1986,    1987

Ans:A ,A


. Which windows features can be accessed from the start menu?
Options: a. Help b. Windows Explorer c. Microsoft Network d. All of above

Ans:5 – d ,5 – d


Back-up procedure helps in
Options: restoring the operation whenever there is a disk failure,    restoring both application and system software whenever there is disk corruption.,    restoring the data files whenever there is a system crash,    All of the above

Ans:D ,D


4.For real time system following is not true
Options: (A)Correct functioning of the system depends on the result produced by the system (B) Correct functioning of the system depends on the time at which the results are produced (C) The time of processing affects the system output (D) The time of processing does not affects the system out-put 10

Ans:104. (D),104. (D)


Dibru-Saikhowa National Park
Options: Karnataka,Kerala,Tripura,Assam

Ans:Assam,


Which of the following is an integrated collection of data with minimum redundancy, so that different applications can use the required data.
Options: records,    file,    DBMS,    schema

Ans:C ,C


The binary number 1100 0101 has _____ bytes
Options: 1,    2,    4,    8

Ans:A ,A


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


What is required to enable the PC to emulate a graphics terminal?
Options: Software,    A laser printer,    A color monitor,    A graphics board

Ans:A ,A


Who is credited with the idea of using punch cards to control patterns in a weaving machine?
Options: Pascal,    Hollerith,    Babbage,    jacquard

Ans:D ,D


4.In Microsoft PowerPoint how do you add degrees of transparency to shapes such as arrows, so that the slide background shows though?
Options: (A)Use #D style 4 button on the drawing toolbar (B) Use the Set Transparent Color button on the Picture toolbar (C) Use the Transparency slider in the Format AutoShapes dialog box (D) All of above 11

Ans:114. (C),114. (C)


After searching the current directory where does command.com search next?
Options: C:\DOS\UTILITIES,    Config.sys,    Autoexec.bat,    The Path Statement

Ans:D ,D


183. bhaarat ka nepoliyan kise kaha jaata hai ?
Options: NA

Ans: samudragupt, samudragupt


Which company created the most used networking software in the 1980's
Options: Microsoft,    Sun,    IBM,    Novell

Ans:D,D


The new committee system constitutes an improvement over the earlier committee system in so far as
Options: it assures representation to all the political parties in proportion to their strength in the Parliament,    it enables the Parliament to examine the grants of all the ministries and departments in detail,    it enables the Parliament to accept the demands of various ministries without scrutiny,    None of the above

Ans:B,B


When did John Napier develop logarithm?
Options: 1416 B. 1614 C. 1641 D. 1804

Ans:– B ,


Which of the following is a programming language?
Options:  Lotus B.  Pascal C.  MS-Excel D.  Netscape

Ans:– B ,


What will be the output of the program? #include<stdio.h> int main() { float *p; printf("%d\n", sizeof(p)); return 0; }
Options: 2 in 16bit compiler, 4 in 32bit compiler,    4 in 16bit compiler, 2 in 32bit compiler,    4 in 16bit compiler, 4 in 32bit compiler,    2 in 16bit compiler, 2 in 32bit compiler

Ans:A ,A


Your IDE hard drive is not spinning up when you turn on the PC. What is the most likely problem.
Options: bad data cable,    incorrect jumper setting on drive,    loose molex connector,    virus

Ans:C ,C


Microsoft Visio is a
Options: (A) A WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 19..

Ans:18. (C),18. (C)


In Excel, the Fill Color button on the Formatting toolbar is used for what?
Options: To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.

Ans:– D ,


The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:D ,D


Carbon, diamond and graphite are together called
Options: allotropes,    isomers,    isomorphs,    isotopes

Ans:A,A


0. In Excel _______ may not contain in Formula
Options: Text Constant B. Number Constant C. Circular Reference D. All of them

Ans: – C ,


2.To copy formatting from one area in a worksheet and apply it to another area you would use
Options: (A)The Edit>Copy Format and Edit>Paste Format commands form the menu. (B) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. (C) There is no way to copy and apply formatting in Excel – You have to do it manually (D) The Format Painter button on the standard toolbar 22

Ans:222. (D),222. (D)


The longest ship canal in the world is the
Options: St. Laurence Seaway (USA and Canada),    Suez canal, Egypt,    Kiel canal, Germany,    Panama canal, Central America

Ans:A,A


If you want to keep track of different editions of a document which features will you use?
Options:  A) Editions, B) Versions, C) Track Change, D) All of above, 

Ans:-B,-B


What is the first step in diagnosing a completely dead computer at the client site that was working the day before.
Options: Test the power supply,    replace the CMOS battery,    check the AC outlet,    reseat the hard drive controller cable

Ans:C ,C

www.000webhost.com