Scribd
Upload
16 views7 pages

Student Grades and Sales Data Summary

The document contains student grades, including total scores and averages for ten students, with a breakdown of grades A and B. It also lists vehicle maintenance costs, sales data by last name and country across different quarters, and product information with IDs and brands. Additionally, it provides employee details including their full names and IDs.

Uploaded by

bushrakousar521
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views7 pages

Student Grades and Sales Data Summary

The document contains student grades, including total scores and averages for ten students, with a breakdown of grades A and B. It also lists vehicle maintenance costs, sales data by last name and country across different quarters, and product information with IDs and brands. Additionally, it provides employee details including their full names and IDs.

Uploaded by

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

Student Name Urdu English Math Physics Chemistry Total Average

1 Aimen 20 10 14 18 15 77 15.4
2 Ayesha 21 12 14 12 18 77 15.4
3 Maryam 33 15 7 14 17 86 17.2
4 Alina 15 14 8 16 20 73 14.6
5 Falak 14 17 10 13 18 72 14.4
6 Amreen 16 8 20 17 15 76 15.2
7 Nimra 18 19 3 10 14 64 12.8
8 Neha 19 20 7 14 18 78 15.6
9 Andleeb 22 13 8 12 19 74 14.8
10 Warisha 26 12 10 11 27 86 17.2

3. Students with grade A and B A B


6 4

4. Aimen and Nimra Name Number Average


Aimen 77 15.4
Nimra 64 12.8

[Link] Number of Students 10


Grade
A
A
A
B
B
A
B
A
B
A
Items Date Cost
BRAKES 01-01-2016 800
TYRES 12-05-2016 2000
BRAKES 18-05-2016 500
SERVICE 20-05-2016 800
SERVICE 10-02-2016 1000
WINDOW 08-05-2016 1000
TYRES 10-05-2016 1200
TYRES 25-05-2016 1500
CLUTCH 10-07-2016 1800
TYRES 10-01-2016 2000
CLUTCH 15-06-2016 1500
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3 Country
Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2 Count of Sales
Jones $1,390.00 USA Qtr 3 Last Name
Brown $4,865.00 USA Qtr 4 Brown
Williams $12,438.00 UK Qtr 1 Johnson
Johnson $9,339.00 UK Qtr 2 Jones
Smith $18,919.00 USA Qtr 3 Smith
Jones $9,213.00 USA Qtr 4 Williams
Jones $7,433.00 UK Qtr 1 Total Result
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
- all -

Quarter
Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total Result
1 1 2
1 1 2
1 1 1 3
1 2 3
1 1 1 1 4
3 3 4 4 14
ID Brand Product ID BRAND PRODUCT
101 DEL Computer 101 DEL Computer
102 Logitech Keyboard 103 Logitech Mouse
103 Logitech Mouse 104 HP Printer
104 HP Printer 101 DEL Computer
102 Logitech Keyboard
103 Logitech Mouse
101 DEL Computer
104 HP Printer
101 DEL Computer
102 Logitech Keyboard

Use the formula HLOOKUP to find the values from Table A Below to Table B

ID 101 102 103 104


Brand Dell Logitech Logitech HP
Product Computer Keyboard Mouse Printer

ID BRAND PRODUCT

104 HP Printer
103 Logitech Mouse
104 HP Printer
101 Dell Computer
102 Logitech Keyboard
103 Logitech Mouse
101 Dell Computer
104 HP Printer
101 Dell Computer
102 Logitech Keyboard
EMP ID First Name Last Name Full Name
D21 Vishal Mohan Vishal Mohan
D22 John Mathew John Mathew
D23 Jamemah Powel Jamemah Powel
D24 Arundhati Swaminathan Arundhati Swaminathan
D25 Peter Potter Peter Potter
D26 Roger Williams Roger Williams

You might also like