Jiwan excel with Computer -8

                    Chapter-2

      Pivot Table S Chart in Excel

1. Multiple Choice questions

Tick (√) the correct answer:

 a. It performs calculations on the data in the worksheet.

   - **(ii) Formula** 

b. When the data of the worksheet changes in formula, this feature is called

   - **(iii) Recalculation**

 c. PivotTables are based on

   - **(iii) List**

d. This field enables you to filter the data that appears in your report.

   - **(iii) Report filter**

### 2. Fill in the blanks:

**a.** Each worksheet has more than **17 billion** cells in which you can enter data.  

**b.** **slicer** is the new feature that provides a rich visualization of Pivot Tables.  

**c.** **Category** is a discrete variable.  

**d.** The Pivot Table layout consists of four elements: **Rows**, **Columns**, **Values**, and **Filters**.  

**e**"We can display our table in a **Compact** or **Tabular** form while changing the layout of the Pivot Table."

**f.** Three popular chart types are **Bar, Line,** and **Pie**.  

**g.** A cell contains three types of data: **Numbers, Text, and Formulas**.

### 3. State True or False:

**a.** The number or value can be used in calculations. **True**  

**b.** Data is organized horizontally in columns and vertically in rows. **True**  

**c.** Excel opens the Pivot Table field list on the same worksheet. **True**  

**d.** The Row Label field shows as a row label down the left side of the Pivot Table. **True**  

**e.** The Field List button helps to change the layout of the Pivot Table. **True**  

**f.** Clicking on the 'refresh' button helps to see the edited source data. **True**

### 4. Answer the following questions:

**Very Short Answer Questions:**

**a.** Name the popular spreadsheet program.  

**Answer:** Microsoft Excel.

**b.** How does a spreadsheet help us?  

**Answer:** A spreadsheet helps us organize, calculate, analyze, and visualize data efficiently.

**c.** What is recalculation?  

**Answer:** Recalculation is the automatic update of the results in formulas when the data in the spreadsheet changes.

**d.** Which filter enables us to filter the data that appears in our report?  

**Answer:** The **Report Filter** in Pivot Tables.

**e.** Which is a powerful data analysis tool that enables one to visualize a Pivot Table?  

**Answer:** **Power Pivot** or **Pivot Chart**.

**f.** Define Quarter.  

**Answer:** A quarter refers to a three-month period in a calendar year (e.g., Q1: January-March).

**Long Answer Questions:**

**a.** How to create a Pivot Chart? Explain with a diagram.  

**Answer:** To create a Pivot Chart:

1. Select the data range.

2. Go to the Insert tab and click on PivotChart.

3. Choose the data fields for the chart from the Pivot Table Field List.

4. The chart will display visualizations of your data based on selected fields.

(Diagram required for detailed steps).

**b.** Define Pivot Table. How to create a Pivot Table?  

**Answer:** A Pivot Table is a data summarization tool in Excel that allows you to reorganize and analyze large datasets quickly.  

**Steps to create:**

1. Select the data range.

2. Go to Insert -> Pivot Table.

3. Choose where you want the Pivot Table to be placed.

4. Drag fields to the Rows, Columns, Values, and Filters sections.

**c.** Explain how to remove the Pivot Table from the worksheet.  

**Answer:** To remove a Pivot Table:

1. Select the entire Pivot Table range.

2. Press **Delete** to remove the table and all associated data.

**d.** Explain slicer and its use in Pivot Table.  

**Answer:** A slicer is a visual tool in Excel that allows you to filter data in Pivot Tables easily. It shows buttons for different categories and lets you filter the data by selecting the relevant buttons.

❤❤❤❤❤❤❤❤💯💯💯💯💯💯👌👌👌👌👌👌✌✌✌✌✌✌❤❤❤ Thanks for visit our website vishanu study.

Thank for 🙏💕🙏💕🙏💕🙏💕 support💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪💪