Skip to main content

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Introduction


Using Formulas and Functions in Microsoft Excel is really a tough job for new students. This is a series of tutorials to make the use of Formulas and Functions in worksheets, easy with various real life example worksheets.
مائیکروسافٹ ایکسل میں فارمولوں اور فنکشنزکا استعمال نئے طلبا کے لیے ہمیشہ سے ایک مسئلہ رہا ہے۔ میری کوشش ہے کہ فارمولا اور فنکشن کا ٹاپک پریکٹیکلی اور پکچرز کے ساتھ تفصیل سے بیان کروں۔

Let,s start.


What is Microsoft Excel?


Microsoft Excel is a popular application software used to manage data in the form of rows and columns and using Excel formulas and built-in Excel functions to perform various calculations on these data. Microsoft Excel is a part of Microsoft Office. We can make different types of worksheets in Excel, for example:
  1. Employee Pay Sheet
  2. Student Test Score Result Sheet with Grades Calculation
  3. Simple Electricity Bill Calculation Formula

What is an Excel Formula?


Excel Formula is a proper combination of operators (like +, -, /, *) and operands. A formula is used to perform different types of calculations and gives result. For example a formula to add numbers in cells A1 and A2 will be typed as =A1+A2.
Note: +, -, / and * are called arithmetic operators in Excel to calculate addition, subtraction, division and multiplication respectively.
Note: A1 and A2 are the Cell References of two cells in worksheet. A1 represents the cell in Row number 1 of Column A Whereas A2 represents the cell in Row number 2 of Column A.
Using Microsoft Excel Formulas and Functions Fast and Easy Way ComputerGap.com Understanding Cell References in Excel -
Using Microsoft Excel Formulas and Functions Fast and Easy Way ComputerGap.com

 What is a Cell Reference?


A Cell Reference is a special Reference Number made by combining Column name and Row Number. Actually a Cell Reference is used to access contents of a cell within a formula. For example, "A1" is an example of Cell Reference. "A" is taken from column name and "1" is taken from Row number. Therefore the intersection cell of column A and Row number 1 is called "A1". Look at the above picture to understand the concept of Cell Reference and how it is made.

How To Use a Cell Reference in a Formula?

Start Microsoft Excel with a new blank workbook. Type 100 in cell A1 and 200 in Cell B1. Now you want to add the two numbers typed in the cell A1 and B1 respectively.

How to enter Excel Formula for Adding two numbers by cell references
How to enter Excel Formula for Adding two numbers by cell references
You must enter a formula using Cell References of both these cells. Every formula in Excel can be started with an equal sign  =. Now type "=" then type cell reference A1. Type + operator ( by pressing Shift and equal to key together ). Now type cell reference B1. Press Enter key. The result of addition will be displayed in cell C1 which is 300.
Result of addition formula using cell references
Result of addition formula using cell references -Using Microsoft Excel Formulas and Functions Fast and Easy Way ComputerGap.com


Comments

Unknown said…
HOW TO BILLING IN SHEET ON EXCEL.PLZ SHOW ME AND DETAIL FORMULA

Popular posts from this blog

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...