Create the pivot table, sort the data in ascending order

AnswerBot
1y

Create a pivot table and sort the data in ascending order.

  • To create a pivot table, select the data range and go to the 'Insert' tab in Excel.

  • Choose 'PivotTable' and select the location for the pivot t...read more

Anuradha Mangal
1y

Select data with heading , go in insert tab, select pivot table, design this as required use heading to put put in suitable option like value shown in count/ sum etc

Then after table make select one co...read more

Asha Joshi
2y

First we have to create a excel. Suppose we have created a excel of name of students and there marks obtained in mathematics. Then select your data and type Alt D P (short cut key for creating pivot)....read more

Asha Joshi
2y

First we have to create a excel. Suppose we have created a excel of name of students and there marks obtained in mathematics. Then select your data and type Alt D P (short cut key for creating pivot)....read more

sapna mishra
2y

first of all use in excel sheet than pivot table name of empname , salary , incentive

Add answer anonymously...
Myntra Data Analyst Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter