What is a Home tab, Insert tab, Formula tab & Data tab?

                                          
What is a Home tab, Insert tab, Formula tab & Data tab


                                            Home tab

Insert Row, Column, Cell & Sheet:  Sometimes records need to be added between created data. If used, let's use Insert Row, Column, Cell & Sheet for that.

To do this, do the following steps:

I. Select the cell where you want to insert Insert Row, Column, Cell.

II. We will click on Home Tab.

III. Click on the down arrow button which is under the Cell Group. A drop down menu will open as you do so.

IV. In that drop down menu, select the following option:


  • Insert Cell 
  • Insert sheet row
  • Insert Sheet Column
  • Insert Sheet



Delete Row, Column, Cell & Sheet:

                                         To do this, do the following steps:

I. Select the cell from where Row, Column, wants to delete the cell.

II. We will click on Home Tab.

III. Click on the down arrow button which is under the Cell Group. A drop down menu will open as you do so.

IV. From that drop down menu, select the following option:


  • Delete Cell
  • Delete Row 
  • Delete Column 
  • Delete Sheet


Hide Row. Column And Work Sheet: - Row. Used to hide columns and worksheet.

                          To do this, do the following steps:

I. Select the Row, Column and Worksheet that you want to hide.

II. We will click on Home Tab.

III. Click on the Format down arrow button which is under the Cell Group. A drop down menu will open as you do so.

IV. Select the Hide & Unhide option from it. A sub-menu will open as you do so.

V. From that Sub - Menu, select the following option:


  • Hide row
  • Hide column
  • Hide Sheet


Unhide Row. column And Worksheet:

                                           To do this, do the following steps:

I. Select the Row, Column and Worksheet that you want to unhide. .

II. We will click on Home Tab.

III. Click on the Format down arrow button which is under the Cell Group. As soon as this happens, a drop. Down menu will open.

IV. From that, we will select Hide & Unhide option. A sub-menu will open as you do so.

V. From that sub-menu, select the following option:

  • Unhide row
  • Unhide Column
  • Unhide Sheet


Protect Sheet: - It is used to set the password in a work sheet.

 I. Click the right button on the work sheet on which you want to set the password. As soon as this happens, a drop. Down menu will open.

II. From that, we will select the Protect sheet option.

III. Then set the password in it and click OK button.

Renaming worksheet: - It is used to change the name of a work sheet.

                                  To do this, do the following steps:

I. Click the right button on the work sheet on which you want to set the password. An impression on doing so. Down menu will open.

II. From that, we will select the Rename option.

III. Then type in the new name and press Enter key.

Wrap Text: - When we write a large text sting in a cell and want to adjust it in a single cell without increasing the width of the column, we use Wrap Text to do so.

                              To do this, we want to do the following steps. 

I. Write the text string that Wrap Text you want to do.

II. We will click on Home Tab.

III. We will click on Wrap Text which is under Alignment Group.

Merge & Center: - Use it to create a cell by adding multiple cells.

                                                To do this, do the following steps:

I. Select all the cells that you want to merge.

II. We will click on Home Tab.

III. We will click on Merge & Center which is under Alignment Group. A drop down while doing so. The menu will open.

IV. In that drop down menu, select the following:


Change Number Format: - By this you can change the format of the number as per your requirement.

                                                     To do this, do the following steps:

I. Select the number whose format you want to change.

II. Click on Home Tab.

III. Click on the number down arrow button. After doing this, the list of number formats will open.

IV. From that, we will select the format according to your needs.


Conditional Formatting: - Hereby change the format of the data of the worksheet according to a condition.

                                                To do this, do the following steps:

I. We will select the cell range whose format you want to change.

II. Click on Home Tab.

III. Then click on Conditional formatting button. A drop down menu will open as you do so.

IV. From that, you will select the condition according to your requirement.

                                         (INSERT TAB)

Inserting Column Chart: - Use Chart to compare between Values.

                                                  To do this, do the following steps.

I. Select the data you want to convert into a column chart.

II. Click on the Insert Tab.

III. Click on the column chart down arrow button. After doing this, the list of charts will open.

IV. From that list, we will select the chart format according to your requirement.

Inserting a Pie Chart:

                                                    To do this, do the following steps

I. Select the data you want to convert into a column chart.

II. We will click on the Insert Tab.

III. Pie Chart will click on the down arrow button. After doing this, the list of charts will open.

IV. From that list, we will select the chart format according to your requirement.

                                       (Formula Tab)

 Working with Formula: - First to do manual formula in Excel
(=) sign type.
      
A
B
C
D
E
F
G
H
I
J
NAME
  ROLL
 MATH
   ENG
   HIN
   SSC
   SC
OBTAIN MARKS
%
  DIV
Raju
1001
65
56
84
56
35



Harish
1002
70
65
84
59
58




Ex: - Assuming that Raju's Obtain Marks are to come out, then for this, I will do the following steps:

I. We will click on Cell H2.

II. Then the = sign will type.

III. Now type = C2 + D2 + E2 + F2 + G2 and press enter key.

To exit the percentage.

I. Click in the cell 12 cell.

II. Type an equal sign (=) first.

III. Click on H2 Cell. Ex = H2 

IV. Press divisible sign and type number of subject. Ex = H2 / 5

V.  Finally press Enter Key

Function: Axles have pre-defined formulas by which different types of functions can be done. Is called function.

          There are many types of data on it.

Which is as follows.

1. Math or string

2. Date

3. Text

4. Financial

5. Logical

6. Statically

7. Lookup or reference

Using Function:

It is used in two ways.

By typing Direct - In this, type the function after the sign of = and insert an argument in it and you can get the result by entering or clicking at the end.

By menu -

On clicking Formula Tab - -> Insert function, the Function dialog box appears. In which Function

Select and click on the ok button. And then give her the organization in it and OK Button. Let's click.

Math or String Function: - These functions were used for Mathematical and String database. goes . Using them we can do our work easily. Some of its functions are as follows.

1. Sum (): - Numbers are added by this function. In this, the value, cell address or cell range can be given.
Example:

2 . Sart(): Square Root of any number is extracted with the help of this function. Its invocation gives the number or cell address or the number whose square root is to be extracted.

Example: - = Sqrt (64)
Result: - 8

3. 0dd (): - With this function even number can be converted to odd number.
Example = Odd (80)
Result = 81

4. Even(): - Function can be converted to even number even. Example = Even (79)
Result = 80

5. Mod(): - The remainder of any number is extracted with the help of this function. Two invitations were given in it.
Example = Mod (26, 5)
Result = 1

6. Power (): - The power of any number can be calculated from this function. In this, two instruments are given, the first number is the second power.
Example: = Power (5, 2)
Result = 25

7. Abs(): - It extracts Absalut value from it. That is, if a sign is placed then it is removed. This molecule takes a number.
= Abs (- 125)
Result = 125

8. Fact (): - With the help of this function, Factorial Number of any number can be extracted.
It takes a number in the argument.
Just like Factorial of 5 is 1 * 2 * 3 * 4 * 5 = 120
Example: = Fact (5)
Result = 120

9. Int (): - From this function one can extract the integer value of any number. It takes a number in the argument.
= Int (123. 34)
Result = 123

Text function: This function is used for text. Therefore these are the following

1. Upper (): - This function converts lower case letter to upper case. Syntax: = UPPER (TEXT)
Example: = Upper ("microcomputer ')
Result: - MICROCOMPUTER

2 . Lower (): - This function converts the upper case letter to lower case letter.
Syntax: = Lower (Text)
Example: = Lower ("MICRO COMPUTER ')
Result: - microcomputer

3. Proper (): - This sets the Function Text to Proper case.
Syntax: Proper (TEXT)
Example: = Proper ("MICROCOMPUTER ')
Result: - Micro Computer

4. Len (): - It counts the characters of Function Text.
Syntax: = Len (TEXT)
Example: = Len ("MICRO ')
Result: - 5

5. Left (): - This function extracts the letters of the word from the left side. Text and how many characters to remove in it. Its number has to be given.
Syntax: = Left (TEXT. Number)
Example: = Left ("MICRO" 2)
Result: - MI

6.Right (): - This function extracts the letters of the word from the right side. In this, the number of text and how many letters to extract is to be given.
Syntax: = Right (TEXT, Number)
Example: = Right ("MICRO", 2)
Result: - RO

7. Trim (): - This function eliminates the space behind the text. Syntax: = Trim (TEXT)
Example: = Trim ("MICRO")
Result: - MICRO

8. Mid): - This function extracts the letters of the word from the middle. In it, the text as Y ment and the letters from where. Exits and gives the number of how many characters it extracts.
Syntax: = Mid (TEXT, START NUMBER, ENDNUMBER) Example: = Mid ("MICROCOMPUTER" 6, 7)
Result: - COMPUTER

DATE OR time FUNCTION:
These function is used for date and time.
1. NoW (): - It gives the current date and time of Function Computer. = Now)
Output = 10/20/2016 19: 16

2 . Day (): - It extracts the day from Function Date.
Syntax: = Day (date)
Example = Day (10/20/2016)
Output = 20

3. Month (): It extracts the month from Function Date.
Syntax: = Month (date)
Example = Month (10/20/2016)
Output = 10

4. Year (): It extracts the year from Function Date.
Syntax: = Year (date)
Example = Year (10/20/2016)
Output = 2016

5. Date (): - This function converts the given numbers into dates.
Syntax: - Date (year, month, day)
Example: = Date (2016, 22, 10)
Output% D22 / 10/216

Time Function:

1. Time (): - This function is given Hour. Minute. Second changes in time
Syntax: - = Time (hourminute, second)
Example: = Time (4: 30: 10)
Output: - 4: 30AM

2 . Second (): - This function returns the second output from the given time. Syntax: = Second (Time)
Example: - = Second (4: 30: 10)
Output: - 10

3. Minute (): - This function returns the minute output from the given time. Syntax: = Minute (Time)
Example: = Minute (4: 30)
Output: 30

4. Hour (): - This function returns the hour output from the given time. Syntax: = Hour (Time)
Example: = Hour (4: 30)
Output: 4

                                         Data tab

Sorting Data: - Use Sorting Data to decorate data in ascending and descending order.
To do this, do the following steps:

1. Click on the column on which you want to do Sorting Data.

II. We will click on the Data Tab.

III. Click A or Z  button under sort & filter group.

Filter Excel Data: - Filter is an important feature of Excel by which you can easily search Excel's data according to the condition. To do this, do the following steps:

1. We will click on the Data Tab.

II. We will click on the Y button. After doing this, an arrow of _ Name - Triangle will be added to the field name.

Filter For Number Greater Than or Less Than:

I. Click on the arrow in the column from which you want to filter. After doing this, the list of filters will open.

II. From that, we will select the Number Filter option. A sub-menu will open as you do so.

III. From that sub-menu, we will select the Custom Filter option. When doing so, a Dialogue box of a Custom Filter will open. In it you will set the crateria as per your requirement and click on OK button.

Post a Comment

0 Comments