Question

Q. The following is not true for a Pivot table -

1- It helps in drilling down details from the summary data where required
2- It helps in presenting data graphically
3- It helps in summarizing, extracting and analysing numeric data
4- None

PLS ANSWER FAST AND THE ANSWER WHICH WOULD BE CORRECT I WILL MARK AS BRAINLIEST​

Answer 1

Answer:

1 true 2 false 3 false 4 true

Answer 2

Answer:

Option(2) is not true for a pivot table:

2- It helps in presenting data graphically

Explanation:

Pivot Table

Pivot tables are created in the Microsoft Excel application. They are used to analyze the data as well as drill down details from the summary data.

It also shows patterns and hidden trends in your data.

Creating a pivot table

• For creating a pivot table, first, select the cells
• Then click on the Insert tab and click on the pivot table option.
• A dialogue box appears. Enter details in it.
• Click ok. Your pivot table is ready.

Uses of Pivot table

• Pivot tables are used for summarizing huge data.
• Most types of charts can be converted into pivot tables.
• They find useful trends and patterns in data that helps in creating the strategy for an organization.

#SPJ3