MS EXCEL DATA ENTRY PROJECT 1

Excel data entry by himanshu singh


Q .1 How to Merge cells  

Ans: select the  range then press Alt + H+M+C

Q .2 How to edit data  from a cell

Ans: Press F2 from your keyboard to edit a data 

Q .3 How to increase & decrease column width & height

Ans: go home then formate option then select (row height /column hight) then enter your measurements  

Q .4 How to increase & decrease row width & height

Ans: go home then formate option then select (row height/width) then enter your measurements  

Q .5 How  to use (bold),italic) underline,text border,text highlight,change font colour ,superscript & subscript function

Ans: 

Ans: 1  First of all select cells (press shift button from keyboard and use drag right with Right arrow key then after the selection)






SCREEN SELECTION WILL LOOK LIKE THIS

Go --> to---->home menu-- and click on ---> merge & center option 








Project 1: Record  students data