Scribd
Upload
7 views24 pages

Project

The document outlines a series of tasks to be completed using Microsoft Office applications, including creating spreadsheets, word documents, and PowerPoint presentations. Key tasks include calculating salaries, writing a leave request, formatting tables, and applying conditional formatting in Excel. Additionally, it involves creating a PowerPoint presentation with specific slides and applying design themes.

Uploaded by

chhokergeet
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
7 views24 pages

Project

The document outlines a series of tasks to be completed using Microsoft Office applications, including creating spreadsheets, word documents, and PowerPoint presentations. Key tasks include calculating salaries, writing a leave request, formatting tables, and applying conditional formatting in Excel. Additionally, it involves creating a PowerPoint presentation with specific slides and applying design themes.

Uploaded by

chhokergeet
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

1. Create a sheet with 8 employees (Name, Department, Basic Salary, Bonus).

And
Calculate Total Salary - Basic + Bonus.
2. Type a paragraph of t lines about yourself in word.
3. Create a formal letter requesting for college leave for 3 days in word.
4. Create a Table with 4 columns and 5 rows to store employee details and apply a table
style in word.
5. Insert a Header with your name and a Footer with page number (Center Aligned) in word.
[Link] a 3 Level Number List (like Chapter → Section→Subsection).
[Link] an Excel Sheet of 10 students with columns: Name, Roll Number, Marks1, Marks2,
Marks3, Total, Percentage and Calculate Total Percentage.
[Link] Conditional Formatting to highlight marks less than 35 in red.
9. Sort the Student list by Percentage (Highest to Lowest).
10. Insert today's date using s function and format it in DD-MM-YYYY.
[Link] IF function to display "Pass" or "Fail" based on Percentage >=40.
[Link] a PowerPoint file with 5 slides.

Slide 1: Title Slide


Slide 2: About You
Slide 3: Skills
Slide 4: Project
Slide 5: Thank You
[Link] a Design Theme of your Choice to all slides.
[Link] a picture in Slide 2.
[Link] bullets points in the 3 Slide.
[Link] Filter to show only student who scored more than 60%.
[Link] and replace all words "Student" to "Candidate".
18. Insert a Page Border with a blue color and 3 pt width.
[Link] a Pivot Table showing average marks of each subject.
[Link] a Bar Chart showing student's Total Marks.

You might also like