Introduction to computer science dessalegn Mequanint Yehuala Foreword

Manual for Laboratory Practices
93
Entering Data or Formula in a Worksheet
In Microsoft Excel there are 1048576*16384 cells.MS Excel cell can have Text, Numeric value or
formulas. MS Excel cell can have maximum of 32000 characters.
To enter data, just activate the cell and type text or number and press enter or Navigation key.
Figure 13 Entering Data in a Cell
To enter formula, go to formula bar, enter the formula and then press enter or navigation key.
See the screenshot below for a better understanding.
Figure 14 Entering Formula in a Cell
Similarly, for modifying the content of a cell just activate the cell, enter a new value and then
press enter or navigation key to see changes.

---

---

Introduction To Computer Science
94
Formatting in Microsoft Excel
Formatting a Cell
A Cell can hold different types of data like Numbers, Currency, Dates, etc..
Right click on the cell you want to edit:
Figure 15 Formatting a Cell
Cell Formats that can be applied on a cell:
•
General: 
This is the default cell format of Cell.
•
Number:
This displays cell as number with separator
•
Currency:
This displays cell as currency i.e with currency sign.
•
Accounting:
Similar to Currency used for accounting purpose.
•
Date:
Various date formats are available under this like 17-09-2013,
17th-Sep-2013, etc
•
Time:
Various Time formats are available under this like 1.30PM, 13.30, etc
•
Percentage: 
This displays cell as percentage with decimal places like 50.00%
•
Fraction: 
This displays cell as fraction like 1/4 ,1/2 etc
•
Scientific: 
This displays cell as exponential like 5.6E+01
•