Scribd
Upload
6 views1 page

Exam Question 8

The document outlines purchase details for various automotive products, including quantities, prices, and discounts. It specifies tasks such as data validation for purchase dates and locations, calculations for tax and prices, highlighting specific products, and creating a pivot table for summarized reports. Additionally, it includes instructions to look up specific product information and save the file with a designated name on the desktop.

Uploaded by

abhishek2001kl4858
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
6 views1 page

Exam Question 8

The document outlines purchase details for various automotive products, including quantities, prices, and discounts. It specifies tasks such as data validation for purchase dates and locations, calculations for tax and prices, highlighting specific products, and creating a pivot table for summarized reports. Additionally, it includes instructions to look up specific product information and save the file with a designated name on the desktop.

Uploaded by

abhishek2001kl4858
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

AUTOMOTIVE WAREHOUSE - PURCHASE DETAILS

PURCHASED MRP
PRICE DISCOUNT PRICE
PRODUCT DATE OF FROM TAX (PRICE
PRODUCT NAME QUANTITY PER AMOUNT AFTER
ID PURCHASE (LOCATION / (18%) AFTER
PIECE (20%) DISCOUNT
COMPANY) TAX)
TYT-501 NUT 2000 10
TYT-502 BOLT 2500 5
SPANNER 180 60
SCREW 850 3
HAMMER 100 70
BRAEK PAD 85 200
CUTTING PLYAER 110 350
ENGINE OIL 120 350
SCREW DRIVER 150 50
CLUTCH LIVER 60 250
NUT 1500 5
HAMMER 50 75
ENGINE OIL 40 300
SCREW 500 3
NUT 700 6

Count the no. of products that shows QUANTITY below 100


Average of TAX paid
Total TAX PAID for 'NUT'
Lowest Discount received
Highest Discount received
DO THE FOLLOWING:
1. SET DATA VALIDATION RULE FOR DATE OF PURCHASE AND PURCHSE FROM LOCATION / COMPANY

2. CALCULATE TAX, MRP & PRICE AFTER DISCOUNT


3. Highlight the cells that contains the product 'NUT'. Also, highlight the QUANTITY that shows below 100.

4. Prepare a PIVOT TABLE that shows the SUMMARIZED PURCHASE REPORT including PRODUCT NAME, DATE OF PURCHASE,
QUANTITY, TAX PAID. Also, prepare a COMPARISON CHART including PRICE AFTER TAX & PRICE AFTER DISCOUNT.
5. Lookup the LOCATION PURCHASED FROM, TAX paid and the PRICE AFTER DISCOUNT for the product 'BREAK PAD'.

6. Save the file on Desktop with your name as the file name.

You might also like