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:


Which of following is Not one of Excel’s what-if function?
Options: a. Goal seek b. Solver c. Scenario manager d. Auto Outline

Ans:#8211; d,#8211; d


Which is the most widely used semiconductor?
Options: Copper,    Silicon,    Germanium,    All of the above

Ans:B ,B


The DBMS that is most difficult to use is ________ .
Options: Microsoft's SQL Server,    Microsoft's Access,    IBM's DB2,    Oracle Corporation's Oracle

Ans:D ,D


When mapping a multivalued attribute into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:B ,B


You record the algorithm in the _____ column of the IPO chart.
Options: Input,    Output,    Processing,    Purpose

Ans:C ,C


. In Word 2007 the Zoom is placed on
Options: a. View tab b. Home tab c. Status bar d. A & C both

Ans:– D,– D


. A search value can be an exact value or it can be
Options: a. Logical operator b. Relationship c. Wild card character d. Comparison operation

Ans:8 – c ,8 – c


Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics

Ans:C ,C


. Which of the following is a way to access secondary memory?

Options: A) Random access memory B) Action method C) Transfer method D) Density method

Ans:A,A


Point out the error in the program? #include<stdio.h> int main() { struct bits { float f:2; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 4,    2,    Error: cannot set bit field for float,    Error: Invalid member access in structure

Ans:C ,C


What command is used to count the number of files in the current directory by using pipes?
Options: ls | ws - c,    ls | wc - w,    ls | wc - l,    ls | wc

Ans:C ,C


If the values of a variable in one module is indirectly changed by another module, this situation is called
Options: A)internal change b.inter-module change c.side effect d.side-module update

Ans:C,Side effect


In Cisco's Unified Wireless Solution, what is the split-MAC architecture?
Options: The split-MAC architecture uses MAC addresses to create a forward/filter table and break up collision domains.,    The split-MAC architecture allows the splitting of 802.11 protocol packets between the AP and the controller to allow processing by both devices.,    The split-MAC architecture uses MAC addresses on the wireless network and IP addresses on the wired network.,    The split-MAC architecture uses MAC addresses to create a forward/filter table and break up broadcast domains.

Ans:B ,B


An appraisal, of a system's performance after it has been installed, is called system
Options: planning,    review,    maintenance,    batch Processing

Ans:B ,B


The attribution of human form or qualities to things such as machines or computers is called
Options: cybernetics,    cybernation,    artificial intelligence,    anthropomorphism

Ans:D ,D


CSMA (Carrier Sense Multiple Access) is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique for multiple-access transmission media.,    a very common bit-oriented data link protocol issued by ISO.,    network access standard for connecting stations to a circuit-switched network

Ans:B ,B


.   on which part of the chart are the values entered in a data sheet displayed?
Options: a. The title area b. The legend c. The y-axis d. The x-axis

Ans:8 – C ,8 – C


Ctrl + A
Options: Align Right B. Select All C. Change font D. Save document

Ans:– B ,


ODBC minimum SQL grammar contains which of the following?
Options: INSERT, UPDATE, DELETE only,    Stored Procedures only,    Literals for date, time and timestamp only,    CREATE VIEW, DROP VIEW only

Ans:A ,A


What is the subnetwork number of a host with an IP address of 172.16.66.0/21?
Options: 172.16.36.0,    172.16.48.0,    172.16.64.0,    172.16.0.0

Ans:C ,C


. Which of the following is a standard file format language for web documents?
Options: a. HTML b. XML c. XSD d. XSL

Ans:3 – a ,3 – a


The physical components of a computer system is
Options: Human ware,    Firm ware,    Hardware,    Software

Ans:C ,C


  To select more than one slide in the presentation A.  Just Click on slide B.  Ctrl + Click on slide C.  Alt + Click on slide D.  Shift + Click on slide
Options:

Ans:– B ,


How many bytes of memory will the following code reserve? #include<stdio.h> #include<stdlib.h> int main() { int *p; p = (int *)malloc(256 * 256); if(p == NULL) printf("Allocation failed"); return 0; }
Options: 65536,    Allocation failed,    Error,    No output

Ans:B ,B


. How do you display current date and time in MS Excel?
Options: a. date () b. Today () c. now () d. time ()

Ans:– c,– c


Data base preparation would be most difficult in a(n)
Options: college or university,    supermarket,    hospital,    bank

Ans:D ,D


What does protocol defines?
Options: Protocol defines what data is communicated. B. Protocol defines how data is communicated. C. Protocol defines when data is communicated. D. All of above

Ans:– D ,


What do you mean by one to many relationship between Student and Class table?
Options: a. One student can have many classes b. One class may have many student c. Many classes may have many students d. Many students may have many classes

Ans:ndash; a,ndash; a


. Which option allows you to Bold all the negative values within the selected cell range:
Options: a. Zero Formatting b. Conditional Formatting c. Compare Formatting d. Negative Formatting

Ans:– b,– b


What is the AutoComplete feature of Excel?
Options: It automatically completes abbreviated words B. It completes text entries that match an existing entry in the same column C. It completes text and numeric entries that match an existing entry in the same column D. It completes text entries that match an existing entry in the same worksheet

Ans:– B ,


What is the use of Notes in slides?
Options: It will be displays at the time of Slide Presentation B. This is just Note about the slide       C. This is just for printing purpose only D. Notes cannot be inserted in Slides

Ans:– B ,


. When you insert an Excel file into a Word document, the data are
Options: a. Hyperlinked b. Placed in a word table c. Linked d. Embedded

Ans:– b,– b


. To add a Header/Footer in Handout
Options: a. View -> Page Setup b. View -> Header/Footer c. View -> Handout Master d. None of Above

Ans:4 – C ,4 – C


For some relations, changing the data can have undesirable consequences called:
Options: referential integrity constraints.,    modification anomalies.,    normal forms.,    transitive dependencies.

Ans:B ,B


What are the decimal and hexadecimal equivalents for the binary number 10110111?
Options: 69/0x2102,    183/B7,    173/A6,    83/0xC5

Ans:B ,B


. How can a user open the Expression Builder dialog box?
Options: a. By clicking the drop-down arrow on the Control Source property b. By clicking the drop-down arrow of the Input Mask property in the Data tab c. By clicking the Build button of the Input Mask in the Data tab d. By clicking the Build button of the Control Source property in the Data tab

Ans:2 – d ,2 – d


. The Table _______________ Wizard analyzes a database and recommends changes for normalization.
Options: a. Analyzer b. Documenter c. Cleanup d. Normalization

Ans:8 – a ,8 – a


A primary key is which of the following?
Options: Any attribute,    An attribute that uniquely identifies each row,    An attribute that uniquely identifies each column,    A derived attribute

Ans:B ,B


In OSI network architecture, the routing is performed by
Options: session layer,    transport layer,    data link layer,    network layer

Ans:D ,D


How many extended partitions can exist on one drive?
Options: 16,    4,    2,    1

Ans:D ,D


Bit map terminal
Options: support displays containing multiple windows,    requires considerable amount of video RAM,    requires tremendous amount of copying and hence low performance,    All of the above

Ans:D ,D


. Find out who is not the inventor of transistors among following names
Options: A) John Burdeen B) William Shockley C) Walter Brattain D) Lee de Forest

Ans:5-D,5-D


What is the smallest number of polarities required for current flow?
Options: One - a negative terminal,    Two - a negative terminal and a positive terminal,    Three - negative, positive and neutral terminals,    Four - two negative and two positive

Ans:B ,B


. Ctrl + G
Options: a. Open Paragraph Dialog box activating Goto Tab b. Open Page Setup Dialog box activating Goto Tab c. Open Find and Replace Dialog box with activating Goto Tab d. Open Goto Dialog box

Ans:–  C,–  C


. The maximum size of a write file is limited to only
Options: a. Name of the file b. Extension of the file c. The amount of memory in your computer d. All of above

Ans: c, c


Which one of. the following phrases most accurately describes the nature of a pulsating dc voltage?
Options: The voltage remains at one polarity and at a steady level,    The voltage remains at one polarity but changes value periodically,    The voltage causes current to flow in two directions at the same time,    The voltage reverses polarity periodically

Ans:B ,B


Which of the following is not considered as a tool at the system design phase?
Options: piechart,    data-flow diagram,    decision table,    systems flowchart

Ans:A ,A


. Which of the following is not an action query?
Options: a. add b. delete c. make-table d. update

Ans:– a,– a


An internetworking protocol that provides virtual circuit service across multiple X.25 protocol, is
Options: X.75,    X.25,    X.400,    X.21

Ans:A ,A


. Which of the following is correct acronym of VGA?
Options: A) Video Graphics Array B) Visual Graphics Array C) Volatile Graphics Array D) Video Graphics Adapter

Ans:A,A

www.000webhost.com