Insert Tab (āĻāĻ¨āĻāĻžā§°ā§āĻ āĻā§āĻŦ) Use & Steps
Insert Tab (āĻāĻ¨āĻāĻžā§°ā§āĻ āĻā§āĻŦ)
Use: Used to insert tables, pictures, charts, shapes, and other objects into a worksheet. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Worksheet-āĻ¤ Table, Picture, Chart, Shape āĻā§°ā§ āĻ āĻ¨ā§āĻ¯āĻžāĻ¨ā§āĻ¯ āĻŦāĻ¸ā§āĻ¤ā§ āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§ āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻā§°āĻž āĻšāĻ¯āĻŧāĨ¤
Tables Group (āĻā§āĻŦā§āĻ˛)
1. Table : Use: Convert a data range into a table for easy sorting and filtering. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Data Range-āĻ Table-āĻ˛ā§ ā§°ā§āĻĒāĻžāĻ¨ā§āĻ¤ā§° āĻā§°āĻŋ āĻ¸āĻšāĻā§ Sort āĻā§°ā§ Filter āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select the data. // Click Insert → Table. // Check My table has headers (if applicable). // Click OK.
2. PivotTable : Use: Summarize and analyze large amounts of data. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻŦā§āĻšā§ Data-ā§° āĻ¸āĻžā§°āĻžāĻāĻļ āĻā§°ā§ āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select the data. // Click Insert → PivotTable. // Choose the location. // Click OK. // Drag fields to Rows, Columns, Values, and Filters.
Illustrations Group (āĻāĻ˛āĻžāĻˇā§āĻā§ā§°ā§āĻāĻ¨)
3. Pictures : Use: Insert a picture from your computer. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžā§°ā§° āĻĒā§°āĻž āĻāĻŦāĻŋ āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Pictures. // Select the image. // Click Insert.
4. Online Pictures : Use: Insert pictures from online sources. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Online-ā§° āĻĒā§°āĻž āĻāĻŦāĻŋ āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Online Pictures. // Search for an image. // Select the image. // Click Insert.
5. Shapes : Use: Insert shapes like lines, arrows, circles, and rectangles.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Line, Arrow, Circle, Rectangle āĻāĻĻāĻŋ Shape āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Shapes. // Choose a shape. // Click and drag on the worksheet.
6. Icons : Use: Insert built-in icons. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Built-in Icons āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Icons. // Select an icon. // Click Insert.
7. SmartArt : Use: Create diagrams and process charts. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Diagram āĻā§°ā§ Process Chart āĻ¤ā§āĻ¯āĻŧāĻžā§° āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → SmartArt. // Choose a SmartArt layout. // Click OK. // Enter your text.
8. Screenshot (Windows) : Use: Insert a screenshot of an open window.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻā§āĻ˛āĻž Window-ā§° Screenshot āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Screenshot. // Select the required window.
Charts Group (āĻāĻžā§°ā§āĻ)
9. Column Chart : Use: Compare values using vertical bars. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Vertical Bar āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻā§°āĻŋ Data āĻ¤ā§āĻ˛āĻ¨āĻž āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
10. Line Chart : Use: Show trends over time. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¸āĻŽāĻ¯āĻŧ āĻ āĻ¨ā§āĻ¸ā§°āĻŋ Trend āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
11. Pie Chart : Use: Show parts of a whole. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻŽā§āĻ ā§° āĻ āĻāĻļ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
12. Bar Chart : Use: Compare values using horizontal bars. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Horizontal Bar āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻā§°āĻŋ āĻ¤ā§āĻ˛āĻ¨āĻž āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
13. Area Chart : Use: Display trends with filled areas. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Area Fill-āĻ¸āĻš Trend āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
14. Scatter Chart : Use: Show relationships between two sets of values. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻĻā§āĻāĻž Data Set-ā§° āĻ¸āĻŽā§āĻĒā§°ā§āĻ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Common Steps for Charts: Select the data. // Click Insert. // Choose the required chart. // The chart is created automatically.
Sparklines Group (āĻ¸ā§āĻĒāĻžā§°ā§āĻāĻ˛āĻžāĻāĻ¨) : Line , Column , Win/Loss
Use: Display mini charts inside a cell. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Cell-ā§° āĻāĻŋāĻ¤ā§°āĻ¤ āĻ¸ā§°ā§ Chart āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Steps: Select the destination cell. // Click Insert → Sparklines. // Select the data range. // Click OK.
Filters Group(āĻĢāĻŋāĻ˛ā§āĻāĻžā§°) : Slicer : Use: Filter Tables and PivotTables visually. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Table āĻā§°ā§ PivotTable āĻ¸āĻšāĻā§ Filter āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Timeline : Use: Filter data by date. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¤āĻžā§°āĻŋāĻ āĻ āĻ¨ā§āĻ¸ā§°āĻŋ Data Filter āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Links Group (āĻ˛āĻŋāĻāĻ)
Hyperlink Use: Insert a link to a webpage, file, email, or another worksheet. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Website, File, Email āĻŦāĻž āĻ āĻ¨ā§āĻ¯ Worksheet-āĻ˛ā§ Link āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Use: Select a cell or text. // Click Insert → Hyperlink. // Enter the link. // Click OK.
Text Group (āĻā§āĻā§āĻ¸āĻ)
Text Box : Use: Insert a text box. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Text Box āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Header & Footer : Use: Add headers and footers for printing. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Print-ā§° āĻŦāĻžāĻŦā§ Header āĻā§°ā§ Footer āĻ¯ā§āĻ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
WordArt : Use: Insert decorative text. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¸āĻā§āĻāĻŋāĻ¤ (Decorative) āĻ˛āĻŋāĻāĻž āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Signature Line : Use: Add a digital signature line. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Digital Signature Line āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Object : Use: Insert an object from another application. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ āĻ¨ā§āĻ¯ Application-ā§° Object āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Symbols Group (āĻāĻŋāĻšā§āĻ¨)
Equation : Use: Insert mathematical equations. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻāĻžāĻŖāĻŋāĻ¤āĻŋāĻ āĻ¸āĻŽā§āĻā§°āĻŖ āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Symbol : Use: Insert special symbols. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻŦāĻŋāĻļā§āĻˇ āĻāĻŋāĻšā§āĻ¨ (©, âš, ±, π, â āĻāĻĻāĻŋ) āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Insert → Symbol. // Select the required symbol. // Click Insert. // Click Close.