MS-Word and MS-Excel Tasks

MS-Word Tasks

• Create a document that displays the equation (a+b)² = a²+2ab+b² and chemical formulas H₂SO₄, H₂O, CO₂, MnO₂ and N₂ + H₂ = NH₃.
• Design a multi-column newspaper format.
• Format a paragraph by adding numbered lists (5) of topics; bullet-pointed lists (5) with hand symbols of college facilities; a footnote to a word within the paragraph; and center the heading title.
• Create a word document containing a timetable with table formatting features.
• Utilize the Mail Merge feature to send invitation letters to former students for an alumni meet.
• Create a letterhead of a company or institution with a watermark of the company's name.
• Develop a macro using personal data.
• Create a document with computer features and apply different themes.

MS-Excel Tasks

• Input student data (Student Name, Subject marks in first semester) to calculate total marks, average, and pass/fail result.
• Enter student data (including total marks and average) to find maximum and minimum marks and count students with an average above 70.
• Calculate total marks and average from student data. Highlight student marks above 90 within a subject and across all subjects using conditional formatting.
• Create a bar chart visualizing student data (Student Name, Total marks).
• Chart student sales data (Month, Sales) using a line chart.
• Sort student data by FirstName, then LastName (FirstName, LastName, Score).
• Filter student scores based on values >70 and between 50 and 70.
• Generate a pivot table to analyze total sales regionally with average sales per region.
• Calculate total employee salaries by department.
• Calculate the statistics mean, median, and mode given data for 10 students' exam scores.

MS-PowerPoint Tasks

• Create a 5-slide presentation showcasing college facilities.
• Create a 5-slide presentation about yoga benefits with slide transitions.
• Create a 5-slide presentation on global warming with varying layouts.
• Create a 5-slide presentation on the side effects of smartphone overuse using design templates.
• Create a 5-slide presentation on the effects of smoking using custom animations.

MS-DOS Tasks

• Create a multi-level directory structure (college name with subdirectories for courses, which further have subdirectories for years).
• Display the directory structure in a tree format.
• Create text files about courses within the directory structure.
• Copy text files into the college-name directory.
• Delete subdirectories.
• Demonstrate at least 5 DOS commands.

This quiz covers essential tasks in MS-Word and MS-Excel, including document formatting, creating equations and chemical formulas, using Mail Merge, and data analysis. Test your knowledge and skills in these popular Microsoft applications through practical scenarios and tasks.