LearnHub

Microsoft Excel shortcuts:-

1.) Open the file menu——- ALT+ F
2.) Save the File——————— CTRL+S
3.) Close the Microsoft excel—————————————————-ALT+F4
4.) Printing shortcut———————————————————————-CTRL+P
5.) open the new workbook——————————————————CTRL+O
6,) Open the Edit menu—————————————————————ALT+E
7.) undo shortcut————————————————————————- CTRL+Z
8.) Redo Shortcut—————————————————————————CTRL+Y
9.) Copy shortcut to up cell to down cell contonuosuly without selection———————CTRL+D
10.) Paste shortcut————————————————————————-CTRL+V
10.)

Microsoft Excel shortcuts:-
1.)For open the file – ctrl+O
2.) For Save the file – Ctrl+S
3.)For close the Ms-Excel:-Alt+F4
4.) For cut shortcut :-ctrl+X
5.)For copy Shortcut:- Ctrl+c
6.) For open the new Blank sheet:-Ctrl+N
7.)Go to Next sheet:-Ctrl Page down
8.)Come Back on previous sheet :-CtrlPageup
9.)Go to end of Sheet :-Ctrl+End
10.)Come on Begining of sheet :-Ctrl+Home

what is the function of wrap text in Excel

with the help of copy command we can copy a cell from one side to another

with the help of fill series we can full all number at one time

what is function of sub totals in excel

What are the different ways in which you can rename a worksheet

A formula is an equation that is used to perform calculation on data in a worksheet.

A cell reference is a cell address used in formula .it identifies a cell or a range of cell in a formula

legents are used to identify a set of data on a chart

What is the Function of Formula bar

How we can insert hyperlink in Excel

1.for selecting non- adjacent rows or columns,first select the column or row,hold down the ctrl key and then select the other rows and columns. 2.for selecting adjacent rows or columns,first select the column or row ,hold down the shift key and then select the other rows and columns

short cut keys in excel:
hide the selected row (ctrl+9)
hide the selected coloum(ctrl+zero)
autoshape menu(ctrl+u)
show or hide standard toolbar(ctrl+7)

We can insert the hyperlink as below:-
Select the column who insert the hyperlink then click the insert in menu barand choose the hyperlink option
Then insert hyperlink box will be open ,Select the Place in document option and click the sheet 1 or sheet 2 and click ok