Microsoft Office Excel

MS Excel:- MS Excel is a word processing program where we can write anything, typing, Design Calculate and save our documents

Microsoft Office Excel

1. What is Microsoft Office Excel?
MS Excel is a word processing program where we can write anything, typing, Design Calculate and save our documents

2. How to open Microsoft Office Excel?
Click start
click all programs
click Microsoft Office
click Microsoft Office Excel
or
Click start
click run
write excel in the tex tbox
click ok

3. How to use arrow left right up and down?
Write something any cell and use Arrow key to change cell note up Arrow key to up cell down arrow key to down cell right Arrow key to right cell left Arrow key to left cell

4. How to going fast and last column and row?
Go first column for ctrl+left Arrow go last column for ctrl+right Arrow go first Row for ctrl+up Arrow go last row for ctrl+down arrow.


5. How to pay automatically week day date or month name?
Write first week day date or month name select cell place the cursor below right corner site and see the small plus (+) sing click and drug

6. How to pay current date?
= today() press enter

7. How to pay back date from current date?
=today()-(number of day) press enter

8. How to pay future date from current date?
=today()+ (number of day) press enter

9. How to pay current date and time?
=now() press enter

10. How to create temple word?
Select word place the cursor below right corner site and there small (+) sing click and drog

11. How to add plus(+) any number?
=sum(first number cells column row:last number cells column row) Click enter
Note:- click and drug first cell to last cell of the number

12. How to save excel file?
Click file
Click save
Type your file name
Click save

13. How to change file name after save?
Click file
Click save
Change your file name
Click save

14. How to add column?
Select column
Click insert
Click column

15. How to add row?
Select row
Click insert
Click row

16. How to make column width?
Select column
Click format
Click column
Click with input column width

17. How to make row height?
Select row
Click format
Click row
Click height

18. How to input row height?
Select cell
Click insert
Click cell
Click ok

19. How to use organisation?
First select all data
Click format
Click cells
Click alignment
Click ok

20. How to protection a sheet?
Click tools
Click protection
Click protection sheet
Type password
Click ok
Type reenter password
Click ok

21. How to unprotection a sheet?
Click tools
Click production
Click unprotection sheet
Type password
Click ok

22. How to a file password?
Click file
Click save as
Click tools
Click general option
Type password
Click ok
Type reenter password
Click ok
Click save
Click save as

23. How to data sorting?
Select all data first
Click data
Select sort
Select any one field name in the sort by box then big to small for
Click ascending A to Z and small to big for
Click descending A to Z
Click ok

24. How to auto filter/advance filter?
Select all data first
Click data
Click autofilter (after see the autofilter arrow of all field name)
Click custom autofilter

25. How to topten of auto filter?
Select all data first
Click data
Click autofilter
Click any combobox of our conditional fields
Click topten
Click top
Click button adjust number of records will displayed
Click ok

26. How to plus minus multiply divide divided?
For plus =sum(A1:B1) press enter
For minus =(A1-B1) press enter
For multiply =(A1*B1) press enter
For devided =(A1/B1) press enter

Come to the internet on this page to learn the computer and brighten your future

More Coming Soon