Excel 2010 Tutorialspoint

Entering values in excel sheet is a childs play and this chapter shows how to enter values in an excel sheet.

Excel 2010 tutorialspoint. Now you should have your blank sheet as shown below ready to start typing your text. Pavan lalwani tutorials point india priva. Step 2 now youll see the insert dialog with select worksheet option as selected from the general tab. Microsoft excel is a spreadsheet tool capable of performing calculations analyzing data and integrating information from different programs.

Microsoft excel is a computer application program written by microsoft. Data validation in excel 2010. Creating formulas in excel 2010 formulas are the bread and butter of worksheet. Ms excel tutorial provides basic and advanced concepts of excel.

Click the ok button. Entering values in excel 2010. Without formula worksheet will be just simple tabular representation of data. Step 1 right click the sheet name and select insert option.

At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Ms excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example you may want to limit data entry in a particular cell to whole numbers between 0 and 10. A formula consists of special cod.

It mainly comprises tabs groups of commands and worksheet. Share your videos with friends family and the world. Ms excel introductionwatch more videos at. You can use a short cut to create a blank sheet anytime.

If the user makes an invalid entry you.