Skip to main content

How Functions are Used in Excel Fast and Easy Way 3

What is a Function in Microsoft Excel?

Microsoft Excel provides a large number of Functions for processing data in Excel Worksheets easily. Functions are predefined formulas in Excel. These functions are used in different types of calculations on numerical or other data  quickly.

How a Function is Used in Microsoft Excel?

There are three popular ways to use built-in functions in Microsoft Excel.

1. Type Functions Manually
2. Use Function Library Commands
3. Use Insert Function Dialogue Box

Other Microsoft Excel Topics on www.ComputerGap.com 

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 
Students Test Score Grades Result Sheet in Excel

Electricity Bill Calculator Formulas in Excel 
 
Microsoft Office Word Processing Practicals

1. Type Functions Manually

You can type a function manually in the required cell. First of all press Equal key from keyboard. Then start typing function name, for example, type SUM. A formula autocomplete list box will be displayed. Press TAB key when SUM is selected in the autocomplete formula list box. Type cell reference of first cell, suppose A1, type a colon ( : ). Type the cell reference of the last cell, suppose A4 as shown in the figure. Press Enter. You will see the result 100 in this cell.
How Functions are used in Microsoft Excel Quick and Easy Way 3
How Functions are used in Microsoft Excel Quick and Easy Way 3


A function is used by its name and providing some arguments to the function. The arguments are the necessary data values for calculation. Moreover, there is an EQUAL sign before every function name.
Notes on Microsoft Excel Functions How to type a function manually
Notes on Microsoft Excel Functions - SUM function

General Syntax of a Function in Microsoft Excel


=FunctionName(Argument1, Argument2,...)
Arguments can be numbers in mathematical functions or cell references etc. If the cell references are used the syntax becomes
=FunctionName(CellRef1:CellRef2)
where CellRef1 represents the cell reference of the first cell in the range and CellRef2 represents the cell reference of the last cell in the range. For example in the given figure,
=SUM(A1:A4)
Notes on Microsoft Excel Functions

2. Use Function Library Commands


Another way to insert a function in a cell is to use the icons in the Formulas each of which is a drop-down control.

How to use a function through FUNCTION LIBRARY COMMANDS in Excel
When you select a function from one of these lists, Excel displays its Function Arguments dialog box to help you enter arguments. The rest of the procedure is the same as in first method.
Notes on using Microsoft Excel Functions
Notes on using Microsoft Excel Functions


3. Use Insert Function Dialogue Box


Notes on using Microsoft Excel Functions - How to Use Insert Function Dialog Box in Microsoft Excel
Notes on using Microsoft Excel Functions - How to Use Insert Function Dialog Box in Microsoft Excel
Using the Insert Function dialog box ensures that you spell the function correctly and that it contains the proper number of arguments in the correct order. Select a suitable category of the function, for example, if you want to use SUM function then it will be found in Math & Trig category of functions. Search and select the function SUM and click on OK button. Now Function arguments dialog box will open, type suitable arguments.
Notes on using Microsoft Excel Functions - How to Use Insert Function Dialog Box in Microsoft Excel

To insert a function, select the function from the Insert Function dialog box, as shown in Figure

You access this dialog box by

  • Choosing Formulas, Function Library,Insert Function
  • Choosing Formulas,Function Library, AutoSum, and then clicking More Functions in the

drop-down list
Notes on using Microsoft Excel Functions - How to Use Insert Function Dialog Box in Microsoft Excel

       In Function Arguments dialog box, you can enter the cell reference of first cell and a colon ( : ) and the cell reference of the last cell to add all the numbers in the cells between these two cells including, as shown in the figure. After giving argument values click on Ok button and the result 100 will be shown in the required cell.
Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 
Students Test Score Grades Result Sheet in Excel

Electricity Bill Calculator Formulas in Excel 
 
Microsoft Office Word Processing Practicals

Comments

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. ...