Skip to main content

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS 




Operators are used in formulas to execute operations on the values taken by formulas. 

Excel use 4 types of operators :

1.Arithmetic Operators


2.Text Concatenation Operators 


3.Comparison Operators 


4.Reference Operators 


Arithmetic Operators

This operation will explained through example

Example 


Text Concatenation Operators 


This operation will explained through example

Example 


Comparison Operators 

To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow:




Reference Operators 

Reference operators enable you to combine absolute and relative references and named ranges. Reference operators are valuable for joining cells or referring to a common area shared shared between different  ranges. 

COLON


COMMA


SPACE                    









Labels:
Location: West End Mall, Janakpuri West, Janakpuri District Center, Janakpuri, Delhi, 110058, India

Comments

Post a Comment

Popular posts from this blog

COMPUTER ABBREVIATIONS & SOME INVENTORS

ABBREVIATIONS EBEESCORP www.ebeescorp.com Inventors Of Computer Hardware  (1) Key board — Herman Hollerith, first keypunch device in 1930 (2) Transistor — John Bardeen, Walter Brattain & Wiliam Shockley (1947 - 1948) (3) RAM —        An Wang and Jay Forrester (1951) (4) Trackball — Tom Cranston and Fred Longstaff (1952) (5) Hard Disk — IBM , The IBM Model 350 Disk File (1956 ) (6) Integrated Circuit — Jack Kilby & Robert Noyce (1958) (7) Computer Mouse — Douglas Engelbart (1964) (8) Laser printer — Gary Stark weather at XEROX in (1969) (9) Floppy Disk — Alan Shugart & IBM( 1970) (10) Microprocessor — Faggin, Hoff&Mazor – Intel 4004 COMPUTER TRAINING CENTER 9717717164
Post a Comment
Read more

CHARACTERISTICS OF A COMPUTER & CENTRAL PROCESSING UNIT (C.P.U)

Hello, Readers This Blog will help you understand the Characteristics of Computer & About C.P.U (Central Processing Unit ). Characteristic means Computer capabilities i.e Characteristics of Computer  1.Speed 2.Accuracy 3.Consistency 4. Data Storing Capability 5.Flexibility  A. Speed : A Computer is a very fast device .It can perform , in a few Second ,the amount of work that a human being can do in an entire year working round the clock .The speed of the computer is usually 2 to 4 GHz . A powerful computer is capable of performing  about 10 to 40 million arithmetic calculations in a second. or We can say that Computer speed is measured in   megahertz (MHz) or gigahertz (GHz). One Megahertz equals to one million ticks per second,one Gigahertz equals one billion ticks per second . B. Accuracy : The accuracy of a Computer is consistently high an the degree o accuracy of a particular task is 100% accurate.In  a every computer each and e...
Post a Comment
Read more