EXCEL PRACTICAL QUESTIONS - 4

EXCEL PRACTICAL QUESTIONS
PIVOT TABLE AND CHARTS

WORKSHOP - 1
Create the following data sheet in MS Excel.

1. Create a pivot with help of above data sheet to calculate total sales by Salesman A, Salesman B and Salesman C.

2. After insert above data items in the pivot table, show only Feb and March month's sales report by using filter buttons. 


WORKSHOP - 2
Create the following data sheet in MS Excel.

1. Create a pivot table for the above data sheet and place the data fields the following order.

A. Insert the "Dept." under the FILTERS.

B. Insert the "Emp. Name" under the ROWS.

C. Insert the "Basic Salary" under the VALUES.

2. Now filter the pivot table data by using "Dept." field that is placed under Filters.
Show all the employees under  HR and Purchase department.

PRACTICE QUESTION (SET - 1)

PRACTICE QUESTION (SET - 2)

PRACTICE QUESTION (SET - 3)

PRACTICE QUESTION (SET - 4)

PRACTICE QUESTION (SET - 5)

HOME