Friday, December 11, 2015

The Home function of Microsoft Excel.

In this tutorial we learn about the Home function of Microsoft Excel.

Clipboard Group :- In this group we can see some command like Cut, Copy and Paste.When we using this command use remove text one area sheet to another Microsoft Excel Spreadsheet. When we use the cut option it removes the selected text after the using command we can insert the clipboard text into the new location.
Using this command we can also copy this formula text one are sheet to another Microsoft Excel Spreadsheet.

Font Group:-When we see font group, we can control the font properties of our text.  In this group we can see the drop down list to the change font type and font changes. We also see more commands just like Bold, Italic, Text underline. If we need more setting to improve wer font setting press ctrl + D and change setting as we wish.
 Original image






We can see explanation about font group in below image.



Alignment group:- Using the group, we can control the position and lawet the text in our worksheet.

Top Alignment-It aligns text to top left.
Middle Alignment- It centered the text between the top and bottom of the cell.
Bottom Alignment-it align text bottom of the left.





Align Text Left:- Using this function, we can do align text to left. Shortcut key
Align Centre:- Using this function, we can do align text to centre.
Align Text Right:- Using this function, we can do align text to right.

Decrease Indent:-  When we enter any text into the cell and after we want to indent the text on left side, each time we  click the button each time, the selected text will nudge to the left.
Use shortcut key to decrease Indent ctrl+alt+shift+tab

Increase Indent:- When we enter any text into the cell and after we want to indent the text on right side, each time we click the button each time, the selected text will nudge to the right.
Use shortcut key to Increase Indent ctrl+alt+tab
Orientation:- In this option when we rotate the cell content use orientation option and the select rotation as given in option. Angle counterclockwise, Angle clockwise, Vertical text, Rotate text up and Rotate text down.

Wrap Text:-  Wrap text is the feature that wrap the text within a cell. We can also used to described word wrap or any text that goes to the next line without pressing the enter or return key. Below image shows that how to use Wrap text?



Merge and center :- It combines two or more cells in a spreadsheet or a table into one cell, and then centres the contents of the new cell.

How to use merge and centre?
1.      First select the range of the cell, which we want to merge.
2.      Click the Home tab, and go to alignment group
3.       And press merge and centre option and we see the selected range of the cell make a new cell.
Below sheet shows how to use merge and center?


Number Format:- Now we are going to Number group in Home tab and when we see the group we see drop down list. First of all we discuss about dropdown list. When we click on drop down list in number format group then we see various option like Number, Currency, Accounting etc.
Below image shows that the Number Format drop down list.





































Number:-  we see drop down list we see top of the list is Number, the number of decimal places, whether or not the thousands separator is used, and the format to be used for negative numbers.

Currency :- If we enter a financial value complete with the dollar sign and two decimal places, Excel assigns a Currency number format to the cell along with the entry.

Accounting:- The Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of number in a column.

Long date:- Long date option convert a number into date. Such as 10-11-15 shows as  10-November-2015.

Time:- Time option convert a number into Time Format.

Percentage:- If we enter a value representing a percentage as a whole number followed by the percent sign without any decimal places, Excel assigns to the cell the Percentage number format that follows this pattern along with the entry.

Short date:- Short date option convert a number into date. Such as 10-November-2015 shows as 10-11-15.

Fraction:- Fraction option convert a number into fraction. Such as when we enter 12/15  shows as 4/5.

Increase Decimal:- In this option we already entered number in cell or worksheet, we can increase the  number of places that are displayed after the decimal point by using the Increase Decimal buttons.

 Decrease Decimal:- In this option we already entered number in cell or worksheet, we can decrease the number of places that are displayed after the decimal point by using the decrease Decimal buttons.

Use the keyboard shortcut Ctrl+1 to open the Format Cells dialog box.

Styles Group:- In this group we can see some command like Conditional formatting, Format as table and cells style.

we will learn about Style Group next tutorial.











 




8 comments:

  1. wait for next tutorial in next tutorial i will explain in conditional formatting

    ReplyDelete
    Replies
    1. please explain in easy form because my english is weak so put images more to learn your next tutorial

      Delete
  2. how make profit and loss projection in microsoft excel

    Microsoft Excel tutorial

    Visit this channel Microsoft tips

    ReplyDelete
  3. I read your post.gained some knowledge. Thanks for sharing. ckeckout here

    ReplyDelete
    Replies
    1. Thanks to leave your Feedback, it encourage me to do Hard work.
      Regarding
      Mad About Computer

      Delete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.