CSFC / SYBAF Sem3 Computer Application 2 Practical Exam Oct2024 PDF

CSFC / SYBAF /Sem3 / Computer Application 2 / PracticalExam / Regular / Oct2024/ 30 Marks / 1 hour Note : 1 mark for question number 1 and rest all 2 marks 1. Make the below given table in the excel file Sheet1 starting from A1 cell....

CSFC / SYBAF /Sem3 / Computer Application 2 / PracticalExam / Regular / Oct2024/ 30 Marks / 1 hour Note : 1 mark for question number 1 and rest all 2 marks 1. Make the below given table in the excel file Sheet1 starting from A1 cell. Name Math English History Science Alex 73 79 45 75 Alison 80 84 65 98 Cindy 31 78 70 46 Daryl 79 69 88 76 Nathan 57 92 72 29 Jerry 89 87 85 96 Pablo 79 25 20 84 Sally 94 55 79 68 Brenda 65 96 85 79 Sunny 22 56 35 78 2. Add Total column next to Science Subject and find total of all subjects 3. Add Percentage column next to total column and find individual percentage of students 4. Add Grade column next to average column and apply grade to individual students as per the below given range : Percentage Range Grade 100 – 80 A 60 – 79 B 40 – 59 C 0 – 39 F 5. Add Pass/Fail column after Grade column and apply pass or fail to individual students as per the below given rule a. If is the student has got above 40 in all the subjects and percentage is above 40 then Pass else Fail. 6. Add Max column after Pass/Fail column and find individually the maximum marks obtained by student. 7. Add Min column after Max column and find individually the minimum marks obtained by student. 8. Add Count above 50 column after Min column and count the number of subjects the student has got secured above 50 marks. 9. Apply color scale to percentage column. 10. Select the marks of all students and apply red color to students having marks below 40 and green color to rest of the students marks. 11. Apply color data bars to Count above 50 column 12. Insert a new row above the first row. 13. Add “Chetana College” text in cell A1. 14. Merge all the cells till the used columns and Center align. 15. Apply colors to heading and title of each column.  CSFC / SYBAF /Sem3 / Computer Application 2 / PracticalExam / Regular / Oct2024/ 30 Marks / 1 hour Note : 1 mark for question number 1 and rest all 2 marks 16. Make the below given table in the excel file Sheet1 starting from A1 cell. Emp_ID Name Product1 Product2 Product3 Product4 Emp01 Alex 73 79 45 75 Emp02 Alison 80 84 65 98 Emp03 Cindy 31 78 70 46 Emp04 Daryl 79 69 88 76 Emp05 Nathan 57 92 72 29 Emp06 Jerry 89 87 85 96 Emp07 Pablo 79 25 20 84 Emp08 Sally 94 55 79 68 Emp09 Brenda 65 96 85 79 Emp10 Sunny 22 56 35 78 17. Add Total column next to Product4 and find total of all subjects 18. Add Percentage column next to total column and find individual percentage of Employee. 19. Add Grade column next to average column and apply grade to individual employee as per the below given range : Percentage Range Grade 100 – 80 A 60 – 79 B 40 – 59 C 0 – 39 F 20. Add Good Sale/Bad Sale column after Grade column and apply pass or fail to individual employee as per the below given rule a. If is the employee has got above 50 in all the subjects and percentage is above 50 then Good Sale else Bad Sale. 21. Add Max column after Good Sale/Bad Sale column and find individually the maximum sale obtained by employee. 22. Add Min column after Max column and find individually the minimum sale obtained by employee. 23. Add Count above 50 column after Min column and count the number of products the employee is able to sale above 50. 24. Apply color scale to percentage column. 25. Select the marks of all employees and apply red color to employee having sale below 50 and green color to rest. 26. Apply color data bars to Count above 50 column 27. Insert a new row above the first row. 28. Add “Company Sales Report” text in cell A1. 29. Merge all the cells till the used columns and Center align. 30. Apply colors to heading and title of each column.