EXCEL PRACTICALS

1. Open MS Excel
Answer: Open Excel from the Start Menu or desktop icon.
Hindi: Excel Start Menu या desktop icon से खोलें।

2. Create a New Excel File

Answer: Go to File > New > Blank Workbook, then click Create.
Hindi: File > New > Blank Workbook > Create पर क्ललक करें ।

3. Create a New Excel File from a Template

Answer: Go to File > New > Select a Template, then click Create.
Hindi: File > New > Template चुनें > Create पर क्ललक करें ।

4. Open an Existing Excel File

Answer: Go to File > Open > Choose the file location, select your file, and click Open.
Hindi: File > Open > file location चुनें, फाइल चुनें, फफर Open पर क्ललक करें ।

5. How do you import data from a .txt file into Excel?

• Answer: Go to Data → Get External Data → From Text → Select the .txt file → Choose Delimited
(or Fixed Width, if appropriate) → Set delimiters (like Tab or Comma) → Click Finish.

• Hindi: Data → Get External Data → From Text → .txt फाइल चुनें → Delimited (या Fixed Width चुनें) →
Delimiters सेट करें → Finish पर क्ललक करें ।

6. How do you import data from a .csv file into Excel?

• Answer: Go to Data → Get External Data → From Text → Select the .csv file → Choose Delimited
→ Set Comma as the delimiter → Click Finish.

• Hindi: Data → Get External Data → From Text → .csv फाइल चुनें → Delimited चुनें → Comma को
delimiter सेट करें → Finish पर क्ललक करें ।

7. How do you search for a specific value in an Excel worksheet?

Use Ctrl + F to open the "Find" dialog, type the value, and press Enter to locate it.

ह द
िं ी: Ctrl + F दबाएं, मान टाइप करें , Enter दबाएं।

8. Navigate to Named Cells, Ranges, or Workbook Elements

Q. How can you navigate quickly to a named range in Excel?
A. Click on the Name Box (left of the formula bar), type the range name, and press Enter.

ह द
िं ी: Name Box पर क्ललक करें , नाम टाइप करें , Enter दबाएं।

Q. How do you switch to a different worksheet in the same workbook?

A. Click on the worksheet tab at the bottom, or use Ctrl + Page Up/Page Down to navigate between
sheets.

ह द
िं ी: शीट टै ब पर क्ललक करें या Ctrl + Page Up/Page Down दबाएं।
9. Insert and Remove Hyperlinks
Q. How can you insert a hyperlink in an Excel cell?
A. Right-click the cell, select Link, enter the URL or location, and click OK.

ह द
िं ी: सेल पर राइट-क्ललक करें , Link चुनें, URL डालें, OK दबाएं।

Q. How do you remove a hyperlink from a cell in Excel?

A. Right-click the cell with the hyperlink, choose Remove Hyperlink.

ह द
िं ी: हाइपरललंक वाले सेल पर राइट-क्ललक करें , Remove Hyperlink चन
ु ें।

10. How do you modify the page setup to set the orientation to landscape?
• Answer: Go to Page Layout > Orientation > Landscape.

• Hindi: Page Layout > Orientation > Landscape चुनें।

11. How do you adjust the row height in Excel?

• Answer: Right-click on the row number > Select Row Height > Enter desired height.

• Hindi: Row number पर राइट-क्ललक करें > Row Height चुनें > ऊँचाई डालें।

12. How do you set a custom column width in Excel?

• Answer: Right-click on the column letter > Select Column Width > Enter desired width.

• Hindi: Column letter पर राइट-क्ललक करें > Column Width चुनें > चौडाई डालें।

13. How can you add a header in an Excel worksheet?

• Answer: Go to Insert > Header & Footer > Type your header.

• Hindi: Insert > Header & Footer > हे डर टाइप करें ।

14. How do you insert a page number in the footer of an Excel sheet?
• Answer: Go to Insert > Header & Footer > Go to Footer > Select Page Number option.

• Hindi: Insert > Header & Footer > Footer में जाएं > Page Number चन
ु ें।

15. How can you change the paper size in page setup?
• Answer: Go to Page Layout > Size > Choose desired paper size.

• Hindi: Page Layout > Size > पेपर साइज चन

ु ें।

16. How do you adjust all rows to fit the content automatically?
• Answer: Select all rows > Double-click on the row boundary, or choose Format > AutoFit Row
Height.

• Hindi: सभी रो का चयन करें > रो बॉडडर पर डबल-क्ललक करें या Format > AutoFit Row Height चुनें।

17. How can you add a date to the header in Excel?

• Answer: Go to Insert > Header & Footer > Choose header section > Click Date.

• Hindi: Insert > Header & Footer > हे डर में जाएं > Date चन
ु ें ।
18. Display and Modify Content in Different Views
• Q: How can you switch between different worksheet views (Normal, Page Layout, Page Break
Preview) in Excel?
• A (English): Go to the "View" tab, and select "Normal," "Page Layout," or "Page Break Preview" as
needed.

• A (Hindi): "View" टै ब पर जाएं, और "Normal," "Page Layout," या "Page Break Preview" चुनें।

19. Freeze Rows and Columns

• Q: How can you freeze the top row or the first column in Excel?
• A (English): Go to the "View" tab, select "Freeze Panes," and choose either "Freeze Top Row" or
"Freeze First Column."

• A (Hindi): "View" टै ब में "Freeze Panes" चुनें, फफर "Freeze Top Row" या "Freeze First Column" चुनें।

20. Change Window Views

• Q: How can you open multiple windows of the same workbook?
• A (English): Go to "View" tab and select "New Window." You can arrange windows by selecting
"Arrange All."

• A (Hindi): "View" टै ब में "New Window" चुनें। "Arrange All" से ववंडो व्यवक्थित करें ।

21. Modify Basic Workbook Properties

• Q: How can you modify workbook properties like title and author?
• A (English): Go to "File," select "Info," and then edit properties like "Title" and "Author."

• A (Hindi): "File" में "Info" चन

ु ें, फफर "Title" और "Author" जैसी प्रॉपटीज बदलें।

22. Display Formulas

• Q: How can you show all formulas in a worksheet?
• A (English): Go to the "Formulas" tab and select "Show Formulas."

• A (Hindi): "Formulas" टै ब में "Show Formulas" चुनें।

23. Set a Print Area

• Question: How do you set a specific range of cells as a print area in Excel?
• Answer:
1. Select the range of cells you want to print.
2. Go to the Page Layout tab.
3. Click on Print Area → Set Print Area.

• Hindi: एक ववलशष्ट क्षेत्र को वप्रंट एररया कैसे सेट करें ?

 o उत्तर: 1. वप्रंट के ललए सेल रें ज चन
ु ें। 2. Page Layout टै ब पर जाएं। 3. Print Area पर क्ललक करें → Set
Print Area।

24. Save Workbooks in Alternative File Formats

• Question: How can you save an Excel workbook in a different file format, such as PDF or CSV?
• Answer:
1. Click on File → Save As.
2. Choose the location to save your file.
3. Under Save as type, select the desired format (e.g., PDF, CSV).
4. Click Save.

• Hindi: वकडबक
ु को अलग फाइल फॉमेट (जैसे PDF, CSV) में कैसे सेव करें ?

o उत्तर: 1. File → Save As पर क्ललक करें । 2. फाइल सेव थिान चुनें। 3. Save as type में इक्छित फॉमेट
चुनें (जैसे PDF, CSV)। 4. Save पर क्ललक करें ।

25. Configure Print Settings

• Question: What steps can you follow to configure print settings, such as margins and orientation,
before printing an Excel sheet?
• Answer:
1. Go to File → Print.
2. Adjust settings like Margins, Orientation (Portrait or Landscape), and Scale to Fit.
3. Preview the changes, then click Print.

• Hindi: वप्रंट सेटटंग्स (जैसे माक्जडन, ओररएंटेशन) को कैसे कॉक्फफगर करें ?

o उत्तर: 1. File → Print पर जाएं। 2. Margins, Orientation (Portrait या Landscape), और Scale to

Fit सेटटंग्स समायोक्जत करें । 3. बदलाव पूवाडवलोकन करें , फफर Print पर क्ललक करें ।

26. Paste Data by Using Special Paste Options

Question: How do you paste only the values from one cell to another cell in Excel? Answer: Copy the cell,
then right-click on the destination cell, go to Paste Special > Values.

Translation: एक सेल से दस
ू रे सेल में केवल वैल्यू पेथट कैसे करें ?
उत्तर: सेल को कॉपी करें , फफर डेक्थटनेशन सेल पर राइट-क्ललक करें , Paste Special > Values चुनें।

27. Fill Cells by Using Auto Fill

Question: How do you quickly fill the days of the week (Monday, Tuesday, etc.) in a column? Answer: Type
"Monday" in the first cell, click and drag the fill handle (small square at cell corner) down the column.

Translation: कॉलम में जल्दी से सप्ताह के टदन कैसे भरें ?

उत्तर: पहले सेल में "Monday" टाइप करें , फफर फफल हैंडल को नीचे खींचें।
28. Insert and Delete Multiple Columns or Rows
Question: How can you insert multiple rows at once? Answer: Select the number of rows where you want
to insert new rows, right-click, and select Insert.

Translation: एक साि कई पंक्लतयाँ कैसे जोडें?

उत्तर: क्जतनी पंक्लतयाँ जोडनी हैं, उफहें चुनें, राइट-क्ललक करें , और Insert चुनें।

29. Insert and Delete Cells

Question: How do you insert a single cell and shift the remaining cells down? Answer: Right-click the cell
where you want to insert, select Insert > Shift cells down.

Translation: एक सेल डालकर बाकी सेल को नीचे कैसे लशफ्ट करें ?

उत्तर: क्जस सेल में जोडना है , उस पर राइट-क्ललक करें , Insert > Shift cells down चुनें।

30. Merge and Unmerge Cells

• Question: How can you merge cells A1 and B1 into one cell?
• Answer: Select cells A1 and B1, go to the Home tab, and click Merge & Center.

• ह द
िं ी में: A1 और B1 सेल को एक में मजड करने के ललए चुनें, होम टै ब पर जाएं, और Merge & Center क्ललक करें ।

31. Modify Cell Alignment, Orientation, and Indentation

• Question: How do you align text to the right in a cell?
• Answer: Select the cell, go to the Home tab, and click on the Right Align icon.

• ह द
िं ी में: टे लथट को दाएं संरेखखत करने के ललए सेल चन
ु ें, होम टै ब पर जाएं, और Right Align पर क्ललक करें ।

32. Format Cells Using Format Painter

• Question: How do you copy formatting from one cell to another?
• Answer: Select the cell, click Format Painter in the Home tab, and then click the cell where you
want to apply the format.

• ह द
िं ी में: फॉमेटटंग कॉपी करने के ललए सेल चुनें, होम टै ब में Format Painter पर क्ललक करें , और नई सेल पर क्ललक
करें ।

33. Wrap Text Within Cells

• Question: How do you wrap text in cell A1?
• Answer: Select cell A1, go to the Home tab, and click Wrap Text.

• ह द
िं ी में: सेल A1 में टे लथट रै प करने के ललए, उसे चुनें, होम टै ब में Wrap Text क्ललक करें ।

34. Apply Number Formats

• Question: How can you format a cell to display as currency?
• Answer: Select the cell, go to the Home tab, and choose Currency from the Number Format
dropdown.

• ह द
िं ी में: सेल को मुद्रा फॉमेट में बदलने के ललए, उसे चुनें, होम टै ब में Currency चुनें।
35. Concepts of Sorting, Filtering, and Validating Data

Question: How do you sort a data range by one column in ascending order?

• Answer: Select the data range, go to the Data tab, and click on Sort A to Z for ascending
order.
• Hindi: डेटा रें ज चन
ु ें, Data टै ब पर जाएं, फफर Sort A to Z क्ललक करें ।

Question: How can you sort data by multiple columns in Excel?

• Answer: Go to Data > Sort, add Sort Levels for each column, and set their order.
• Hindi: Data > Sort पर जाएं, हर कॉलम के ललए Sort Levels जोडें, और उनका क्रम सेट करें ।

Question: How do you filter data to show only rows where a certain column has values greater
than a specific number?

• Answer: Select the column, go to Data > Filter > Number Filters > Greater Than and enter
the number.
• Hindi: कॉलम चन
ु ें, Data > Filter > Number Filters > Greater Than और नंबर डालें।

Question: How do you filter data to show only rows containing specific text in a column?

• Answer: Go to Data > Filter > Text Filters > Contains, and enter the text.
• Hindi: Data > Filter > Text Filters > Contains पर जाएं और टे लथट डालें।

Question: How can you validate data to accept only numbers between 1 and 100?

• Answer: Select the cells, go to Data > Data Validation > Settings, select Whole Number,
and set Between 1 and 100.
• Hindi: सेल्स चुनें, Data > Data Validation > Settings पर जाएं, Whole Number चुनें, और 1 से
100 सेट करें ।

Question: How do you apply a list-based data validation in a cell?

• Answer: Select the cell, go to Data > Data Validation > Settings, select List, and enter
items separated by commas.
• Hindi: सेल चुनें, Data > Data Validation > Settings पर जाएं, List चुनें, और आइटम्स डालें।

Question: How do you remove all filters applied to a worksheet?

• Answer: Go to Data > Clear to remove all filters.

• Hindi: Data > Clear पर जाएं सभी फफल्टर हटाने के ललए।

Question: How can you prevent duplicate entries in a column using data validation?

• Answer: Select the column, go to Data > Data Validation > Custom, and enter the formula
=COUNTIF(A:A, A1)=1.
 • Hindi: कॉलम चुनें, Data > Data Validation > Custom पर जाएं, और =COUNTIF(A:A, A1)=1 फॉमल
ूड ा
डालें।

Question: How do you set up a filter to show dates only from the past week?

• Answer: Select the date column, go to Data > Filter > Date Filters > Last Week.
• Hindi: डेट कॉलम चन
ु ें, Data > Filter > Date Filters > Last Week पर जाएं।

Question: How can you sort a list by color in Excel?

• Answer: Select the data, go to Data > Sort, select the column, and choose Sort by Color.
• Hindi: डेटा चुनें, Data > Sort पर जाएं, कॉलम चुनें और Sort by Color चुनें।

36. Analyzing Data Using Charts, Data Tables, Pivot Tables, Goal Seek, and Scenarios

1. Create a Chart to Show Sales Trends

• Question: Create a line chart that shows monthly sales data for the past year.
• Answer: Select data, go to Insert → Line Chart.
• Hindi: डेटा चुनें, Insert → Line Chart पर जाएँ।

2. Use a Data Table to See the Effect of Changing Variables

• Question: Create a data table to show how profits change with different selling prices.
• Answer: Use What-If Analysis → Data Table, and set price as a variable.
• Hindi: What-If Analysis → Data Table का उपयोग करें और मूल्य को एक चर के रूप में सेट करें ।

3. Analyze Data with a Pivot Table

• Question: Create a pivot table to summarize total sales by region.

• Answer: Select data, go to Insert → Pivot Table, add "Region" in rows and "Sales" in
values.
• Hindi: डेटा चन
ु ें, Insert → Pivot Table, "Region" को rows में और "Sales" को values में जोडें।

4. Use Goal Seek to Reach a Target

• Question: Use Goal Seek to find the required sales to reach a target profit of $10,000.
• Answer: Go to Data → What-If Analysis → Goal Seek, set profit cell to $10,000.
• Hindi: Data → What-If Analysis → Goal Seek पर जाएँ, लाभ सेल को $10,000 पर सेट करें ।

5. Create Scenarios for Budget Forecasting

• Question: Use Scenarios to see the effect of different budget conditions on expenses.
 • Answer: Go to What-If Analysis → Scenario Manager, add scenarios for different
conditions.
• Hindi: What-If Analysis → Scenario Manager पर जाएँ और ववलभफन पररक्थिततयों के ललए
पररदृश्य जोडें।

37. Apply Cell Formats from the Format Cells Dialog Box
• Question: How do you apply custom formatting to a cell?
• Answer: Right-click the cell, select Format Cells, and choose your formatting options.

• ह द
िं ी में: कथटम फॉमेटटंग के ललए सेल पर राइट-क्ललक करें , Format Cells चन
ु ें और फॉमेटटंग ववकल्प चन
ु ें।

38. Apply Cell Styles

• Question: How do you apply a specific style to a cell?
• Answer: Select the cell, go to the Home tab, and choose a style from Cell Styles.

• ह द
िं ी में: एक सेल में थटाइल लागू करने के ललए सेल चुनें, होम टै ब में जाएं और Cell Styles से एक थटाइल चुनें।

39. Clear Cell Formatting

• Question: How do you clear all formatting from a cell?
• Answer: Select the cell, go to the Home tab, click on Clear and choose Clear Formats.

• ह द
िं ी में: सेल से सभी फॉमेटटंग हटाने के ललए, सेल चुनें, होम टै ब में जाएं, Clear पर क्ललक करें , और Clear Formats
चुनें।

40.Define a Named Range

Q: How do you create a named range for a set of cells in Excel?
A: Select the range → Go to the Formulas tab → Click Define Name → Enter the name → Click OK.

Hindi: रें ज चुनें → फामूल

ड ा टै ब पर जाएं → Define Name पर क्ललक करें → नाम डालें → OK पर क्ललक करें ।

41.Name a Table
Q: How do you name a table in Excel?
A: Select the table → Go to Table Design tab → Enter a name in the Table Name box → Press Enter.

ु ें → टे बल डडजाइन टै ब पर जाएं → Table Name बॉलस में नाम डालें → Enter दबाएं।
Hindi: टे बल चन

42. Summarize Data Visually

Q: How do you visually summarize data using charts?
A: Select data → Go to Insert tab → Choose a chart type (e.g., column, pie) → Adjust as needed.

Hindi: डेटा चुनें → इफसटड टै ब पर जाएं → चाटड प्रकार चुनें (जैसे, कॉलम, पाई) → आवश्यकता अनुसार समायोक्जत करें ।

43. Insert Sparklines

Q: How do you insert sparklines in Excel?
A: Select cells → Go to Insert tab → Click Sparklines (Line, Column, or Win/Loss) → Choose data range →
Click OK.

Hindi: सेल चुनें → इफसटड टै ब पर जाएं → Sparklines चुनें (लाइन, कॉलम, या ववन/लॉस) → डेटा रें ज चुनें → OK पर क्ललक
करें ।

44. Apply Built-in Conditional Formatting

Q: How do you apply conditional formatting to cells?
A: Select cells → Go to Home tab → Click Conditional Formatting → Choose a rule (like Data Bars or Color
Scales).

Hindi: सेल चुनें → होम टै ब पर जाएं → Conditional Formatting पर क्ललक करें → तनयम चुनें (जैसे, डेटा बासड या कलर
थकेल्स)।

45. Remove Conditional Formatting

Q: How do you remove conditional formatting in Excel?
A: Select cells with formatting → Go to Home tab → Click Conditional Formatting → Choose Clear Rules.

Hindi: फॉमेटटंग वाले सेल चुनें → होम टै ब पर जाएं → Conditional Formatting पर क्ललक करें → Clear Rules चुनें।

46. Create Excel Tables from Cell Ranges

Q1: How do you create a table from a cell range in Excel?

A1 (Hindi): फकसी सेल रें ज को टे बल में बदलने के ललए, रें ज को लसलेलट करें , Insert टै ब पर जाएं, और Table चुनें। "My table
has headers" ववकल्प को टटक करें और OK पर क्ललक करें ।

Apply Table Styles

Q2: How can you apply a style to a table in Excel?

A2 (Hindi): टे बल पर क्ललक करें , Table Design टै ब में जाएं, और Table Styles से पसंदीदा थटाइल को चन
ु ें।

Convert Tables to Cell Ranges

Q3: How do you convert an Excel table back to a normal cell range?

A3 (Hindi): टे बल पर क्ललक करें , Table Design टै ब में जाएं, और Convert to Range चुनें।

47. Add or Remove Table Rows and Columns

Q: How can you add a new row to an existing Excel table?
• Answer (English): Click on the last cell of the table, press Tab, or right-click a cell, select Insert, and
choose Table Rows Above/Below.
 • Answer (Hindi): टे बल में नया रो जोडने के ललए, आखखरी सेल पर क्ललक करें और Tab दबाएं या Insert में जाकर
Table Rows Above/Below चुनें।

Q: How can you delete a column from an Excel table?

• Answer (English): Right-click the header of the column you want to delete, then select Delete >
Table Columns.

• Answer (Hindi): उस कॉलम हेडर पर राइट-क्ललक करें क्जसे हटाना है , फफर Delete > Table Columns चुनें।

48. Configure Table Style Options

Q: How can you apply a new style to an Excel table?
• Answer (English): Select the table, go to Table Design > Table Styles and choose a style you like.

• Answer (Hindi): टे बल को चुनें, फफर Table Design > Table Styles में जाएं और पसंदीदा थटाइल चुनें।

Q: How do you remove banded rows from an Excel table style?

• Answer (English): Select the table, go to Table Design, and uncheck Banded Rows under Table
Style Options.

• Answer (Hindi): टे बल को चुनें, Table Design में जाएं और Table Style Options में Banded Rows को अनचेक
करें ।

49. Insert and Configure Total Rows

Q: How do you add a total row to an Excel table?
• Answer (English): Click on the table, go to Table Design > Total Row to add it.

• Answer (Hindi): टे बल पर क्ललक करें , Table Design > Total Row में जाएं और जोडें।

Q: How can you configure the total row to show the sum of a column?
• Answer (English): In the total row, click the cell under the desired column, select Sum from the
dropdown.

• Answer (Hindi): टोटल रो में इक्छित कॉलम के नीचे क्ललक करें और ड्रॉपडाउन से Sum चुनें।

50. Relative Reference

Question:
In cell B2, enter the formula =A2+10. Drag this formula down to cell B5. What happens?
Answer in Hindi:
जब आप =A2+10 को B2 में डालते हैं और उसे B5 तक खींचते हैं, तो हर सेल का A कॉलम में क्थित नंबर में 10 जोडा जाएगा।

Absolute Reference
Question:
In cell B2, enter the formula =$A$2+10. Drag this formula down to cell B5. What happens?
Answer in Hindi:
$A$2 को $ के साि इथतेमाल करने से A2 का reference fixed रहता है । सभी सेल में A2 का ही मान ललया जाएगा, कोई
बदलाव नहीं होगा।

Mixed Reference
Question:
In cell B2, enter the formula =A$2+10. Drag this formula down to cell B5. What happens?
Answer in Hindi:
A$2 में कॉलम A बदलता नहीं है , लेफकन रो (row) 2 fixed रहती है । जब आप नीचे खींचेंगे तो A2 का ही मान ललया जाएगा।

Reference Named Range in a Formula

Question:
You have a named range called Sales that refers to cells A1
. In cell B1, enter the formula =SUM(Sales). What does this formula do?
Answer in Hindi:
=SUM(Sales) नालमत range Sales (जो A1

तक है ) का योग करता है ।

Reference Named Table in a Formula

Question:
You have a table named Employees with columns Name and Salary. In cell C1, enter the formula
=SUM(Employees[Salary]). What does this formula do?
Answer in Hindi:
=SUM(Employees[Salary]) नालमत टे बल Employees के Salary कॉलम का योग करता है ।

Using Mixed Reference with Named Range

Question:
You have a named range called Cost in cells A2
. In cell B2, enter the formula =A$2*10. Drag this formula down to B6. What happens?
Answer in Hindi:
A$2 को जब आप नीचे खींचते हैं तो हर सेल में A2 का मान ललया जाएगा, और उस मान को 10 से गुणा फकया जाएगा।

Using Absolute Reference with Named Table

Question:
In a table named SalesData, you want to calculate the total price for each item in column Price by
multiplying with a fixed TaxRate in cell F1. Enter the formula in column G as =SalesData[@Price]*$F$1.
What happens?
Answer in Hindi:
SalesData[@Price]*$F$1 हर प्रोडलट की Price को fixed TaxRate (F1) से गुणा करे गा। F1 का मान हर सेल में एक जैसा
रहे गा।

Using Relative Reference with Named Table

Question:
You have a table named Products. In column B, you want to add the tax to each product price in column A.
Enter the formula =[@Price]*1.15 in cell B2. What happens when you drag the formula down?
Answer in Hindi:
=[@Price]*1.15 प्रोडलट की Price को 1.15 से गण
ु ा करे गा, और यह हर प्रोडलट के ललए अलग-अलग फकया जाएगा।

51. Create Charts

1. Q: How do you create a chart in Excel?
o A: Select data → Insert → Choose chart type (e.g., Column, Line, etc.).

Hindi: डेटा चुनें → इंसटड → चाटड चुनें।

Create Chart Sheets

2. Q: How do you create a chart sheet?
o A: Select chart → Right-click → Move chart → New sheet.

Hindi: चाटड चुनें → राइट क्ललक → मूव चाटड → फयू शीट।

Add Data Series to Charts

3. Q: How do you add a new data series to an existing chart?
o A: Right-click on the chart → Select "Select Data" → Add series.

Hindi: चाटड पर राइट क्ललक → "Select Data" चुनें → सीरीज जोडें।

Switch Between Rows and Columns in Source Data

4. Q: How do you switch between rows and columns in chart data?
o A: Right-click chart → Select "Select Data" → Click "Switch Row/Column."

Hindi: चाटड पर राइट क्ललक → "Select Data" चुनें → "Switch Row/Column" क्ललक करें ।

Add and Modify Chart Elements

5. Q: How do you add or modify chart elements like titles and labels?
o A: Click on the chart → Chart Elements button → Add or modify titles/labels.
Hindi: चाटड पर क्ललक करें → चाटड एललमेंट्स बटन → टाइटल/लेबल जोडें या बदलें।

Add Trend Lines to Chart

6. Q: How do you add a trend line to a chart?
o A: Right-click on the chart → Add Trendline → Choose trend type (Linear, Exponential,
etc.).

Hindi: चाटड पर राइट क्ललक → ट्रें डलाइन जोडें → ट्रें ड टाइप चन

ु ें।

Apply Chart Layouts

7. Q: How do you apply chart layouts?
o A: Select chart → Design tab → Choose a layout style.

Hindi: चाटड चुनें → डडजाइन टै ब → लेआउट थटाइल चुनें।

Apply Chart Styles

8. Q: How do you apply chart styles?
o A: Select chart → Design tab → Choose chart style.

Hindi: चाटड चुनें → डडजाइन टै ब → चाटड थटाइल चुनें।

Add Alternative Text to Charts for Accessibility

9. Q: How do you add alternative text to a chart for accessibility?
o A: Right-click chart → Format Chart Area → Alt Text → Enter description.

Hindi: चाटड पर राइट क्ललक → फॉमेट चाटड एररया → अल्ट टे लथट → वववरण दजड करें ।

52. Create Pivot Tables from Cell Ranges

Question:
Create a Pivot Table using the following data:

Product Sales Region Date

A 100 East Jan

B 150 West Jan

A 200 East Feb

C 300 North Feb

Steps:
1. Select the data range (A1
).
2. Go to Insert > PivotTable.
3. In the Create PivotTable window, click OK.
Answer in Hindi:

1. डेटा को चुनें।

2. इन्सर्ट > पिवर् र्े बल पर क्ललक करें ।

3. वपवट टे बल संवाद बॉलस में OK पर क्ललक करें ।

2. Manipulate Fields (Columns) to Get Desired Analysis

Question:
Use the pivot table to show the total sales by product.
Steps:
1. Drag the Product field to the Rows area.
2. Drag the Sales field to the Values area.
Answer in Hindi:

1. प्रोडक्र् को रोस में डालें।

2. सेल्स को वैल्यूज में डालें।

3. Use Filters for Pivot Tables

Question:
Add a filter for the Region to display sales only from the "East" region.
Steps:
1. Drag the Region field to the Filters area.
2. Select "East" from the filter dropdown.
Answer in Hindi:

1. रीजन को फिल्र्र में डालें।

2. "East" चुनें।

4. Represent Data as Count, Sum, Average & % of Row/Column

Question:
In the pivot table, show the total sales (Sum), the average sales, and the count of sales.
Steps:
1. Drag Sales to the Values area.
2. Right-click the Sales field in the Values area and select Value Field Settings.
 3. Choose Sum, Average, and Count.
Answer in Hindi:

1. सेल्स को वैल्यूज में डालें।

2. Value Field Settings पर क्ललक करें ।

3. Sum, Average, और Count चुनें।

5. Group Data in Columns & Rows for Aggregate Reports

Question:
Group the data by Month in rows and Product in columns to see the sales performance.
Steps:
1. Drag Date to Rows and Product to Columns.
2. Group the Date field by Month (right-click > Group).
Answer in Hindi:

1. डेर् को रोस में और प्रोडक्र् को कॉलम्स में डालें।

2. डेर् को मिंथ द्वारा ग्रुप करें ।