Scribd
Upload
53 views1 page

Excel Practical Skill Test - 10-10-2024

The document provides instructions for an Excel practical skills test involving the creation of sales data, formatting, and applying formulas. It requires the use of conditional formatting and the preparation of a summary sheet using pivot tables or data filters. Participants must save their completed work as 'Excel_Test_YourName.xlsx' before submission.

Uploaded by

anshs9333
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
53 views1 page

Excel Practical Skill Test - 10-10-2024

The document provides instructions for an Excel practical skills test involving the creation of sales data, formatting, and applying formulas. It requires the use of conditional formatting and the preparation of a summary sheet using pivot tables or data filters. Participants must save their completed work as 'Excel_Test_YourName.xlsx' before submission.

Uploaded by

anshs9333
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Excel Prac cal Skills Test

Pivot Tables, Data Filtering, and Formulas


Instructions:
 Perform the tasks directly in Excel.
 Save your completed work as Excel_Test_YourName.xlsx.
----------------------------------------------------------------------------------------------------------------
1. Create the sales data given below in Excel sheet.
a. Font Type : - Times New Roman
b. Font Size : - 18

Date Region Product Category Salesperson Sales


(₹)
01-01-2023 North Laptop Electronics John Doe 1200
02-01-2023 East Phone Electronics Jane Smith 850
03-01-2023 South Tablet Electronics Mike Johnson 750
05-01-2023 West Printer Office John Doe 400
06-01-2023 North Laptop Electronics Sarah Lee 1350
10-01-2023 East Phone Electronics Jane Smith 900
11-01-2023 South Headphones Electronics Mike Johnson 300
13-01-2023 West Monitor Electronics Sarah Lee 1100
15-01-2023 North Laptop Electronics John Doe 1400
17-01-2023 East Printer Office Jane Smith 550
18-01-2023 South Monitor Electronics Mike Johnson 1050
20-01-2023 West Phone Electronics Sarah Lee 800
22-01-2023 North Tablet Electronics John Doe 600
25-01-2023 East Headphones Electronics Jane Smith 250
27-01-2023 South Laptop Electronics Mike Johnson 1300
30-01-2023 West Tablet Electronics Sarah Lee 700
2. Use Format Table option to Format it.

3. Apply Formula in Data


a. Total sales value. (Use Sum Formula)
b. The minimum sales value. (Use Max Formula)
c. The maximum sales value. (Use Min Formula)

4. Use Conditional Formatting in above data


a. Highlight the sales in excess ₹1000 – Light Yellow fill Dark Yellow Text
b. Highlight the sale in below ₹500 – Light Red Fill Dark red Text.

5. Prepare a Summary Sheet: - (Use Pivot table / Data Filter & Copy Paste Technique)
a) Region wise Sales
b) Representative wise Sales
c) Category Wise Sales
d) Product Wise Sales

We appreciate the time and effort you've put into completing this test. Your dedication to
learning and improving your Excel skills is commendable. Please ensure that all your work is
saved correctly before submission.

Good luck!

You might also like