Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How to Create Formulas in MS Excel 2010

In order to create a formula in MS Excel 2010, you are simply required to the type in the formula bar. It should be noted that formula always begins with ‘=’ sign. While writing formulas manually, it can be typed either in the cell address or it can be pointed to them in the worksheet.

Most of the users find Pointing method to supply the cell addresses for formula lot easier and efficient in the worksheet. You can even make use of the built-in functions by simply clicking the cell or dragging through the cell range where formula is to be used. This snapshot will give a better idea about inserting formulas in the worksheet.

MS Excel tutorial

Once you hit the enter key after inserting the formula, Excel will calculate the result and it will be displayed inside the cell. In case there is any error in the formula then Excel will able not be able to calculate the result at all. Instead an Alert dialog box will be displayed on the screen suggesting smart ways to fix the problem.

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow