A4 page

Q.No.10. Consider the case given below. H D shift M 5 quantity 5 4 sale 987 1088 716 M E E product RAM Hard Disk RAM RAM LED Hard Disk RAM Hard Disk LED 6 2 7 1 salesman days 2 ali mon khan tues 4 ali mon khan mon 6 shan tues jan fri alt fri khan mon 10 ali tues 11 shan mon shan tues fri E 1034 808 892 E 6 Stock item Quantity LED RAM 180 Hard Disk 150 200 9 M M 2 648 1085 782 M 3 1 LED RAM LED E M E 5 895 708 571 Jan 6 Use appropriate excel function to calculate the values for the following cases 1. Total sale of Ali? 2. How many LED's are sold on Tuesday? 3. Total sale of RAM in morning shift? 4. How many Hard Disks left in stock