Greenwood Public School

Adityapuram, Gwalior [M.P.]

Session 2023-24
Class IX

Work ON Word, Excel and Power Point

Submitted TO: Submitted BY:

Mr. GAjendra Singh ------------------------------
Section “ “
CERTIFICATE

This is to certify that Master/Miss ________________________________________

of Class IX has successfully completed the Project on Word, Excel and PowerPoint

as per the guidelines of CBSE. It is further Certified that this project is the

individual and bonafide work of the candidate.

Teacher’s Name: Mr. Gajendra Singh

External Sign: _______________________

ACKNOWLEDGEMENT

I would like to convey my heartfelt thanks to Mr. Gajendra Singh

who guided me through the project, also gave valuable suggestions and guidance

for completing the project. He / She helped me to understand the intricate issues

involved in making the project, besides effectively presenting it. These intricacies

would have been lost otherwise. My project has been successful only because of

his / her guidance.

Q.1 How to change date and time in computer.
The steps to change the date and time in Windows are simple. Follow the steps
given below

Step 1: On the Desktop, right-click on the ‘Date and time’ widget in the bottom
right corner.

Step 2: From the context menu, select ‘Adjust date and time.’

You will be taken to the ‘Date & time’ settings window.

Step 3: Toggle off the ‘Set time automatically’ option.

Step 4: Click the Change button next to ‘Set the date and time manually.’

Step 5: Now, change the date and time as per your preference. Finally, press
the Changed button.

And that’s about it. The date and time change on your PC as needed. If we
don’t want to do it through the Settings app, we can do it the traditional way.

Q.2 How to Insert a Built-In Watermark

A watermark is a faded background image that displays behind the text in a
document. You can use them to indicate a document’s state (confidential, draft,
etc.), add a subtle company logo, or even for a bit of artistic flair. Here’s how to
add and manipulate watermarks to the Word document.

How to Insert a Built-In Watermark

With the document open, switch over to the “Design” tab.

In the Page Background group on that tab, click the “Watermark” button.

On the drop-down menu, click any of the built-in watermarks to insert it into
the document.
Word places the watermark behind the text.

How to Insert a Custom Watermark

We can also create custom watermarks from text or images. To do this, select
the “Custom Watermark” from the “Watermark” drop-down menu.

Using Custom Text Watermarks

In the Printed Watermark window that opens, select the “Text Watermark”
option. Type the text we want to use into the “Text” box and then configure the
options for language, font, size, color, and orientation the way you want them.
Click “OK” when you’re done.

Word inserts the custom text watermark behind the text.

Using Custom Picture Watermarks

If we want to use a picture as a watermark, select the “Picture Watermark”

option and then click the “Select Picture” button.

We can use a picture file on own computer, search for an image on Bing, or
select an image from the One Drive storage.
Select an image from the results and then click the “Insert” button. We’re using
an image from our computer.

Word inserts the image behind the text in our document.

Q.3 Easy Steps to Make Automatic Mark sheet in Excel
First, get introduced to our dataset which has two sheets. Sheet1 contains the
personal details, numbers, and grading of each student.

And Sheet2 contains the mark sheet template. We inserted a bold outside
border to create a better look for the mark sheet.
Step 1: Insert Personal Details
The first part of our marksheet contains the personal details of a student. We’ll
insert the roll, class, and session manually and the other information will be
returned using the VLOOKUP function.
Steps:
• Firstly, insert a roll number in Cell E8. I inserted 1.
• Then insert the following formula in Cell E9 to get the corresponding student
name-
=VLOOKUP(E8,Sheet1!B2:L10,2)

• Next, hit the ENTER button for the output.

• After that, apply the same type of formula using the VLOOKUP function
again in Cell G8 and G9 to return the date of birth and father’s name. The
formula is quite similar to the previous one, just the column index number of
the array will be different according to the date of birth and father’s name.
Then we will get the personal details part of the mark sheet like the image
below.
Step 2: Insert Obtained Marks
Now we’ll extract the obtained marks in every subject for every student using
the VLOOKUP function again to make an automatic marksheet in Excel.
Steps:
• In Cell F12, type the following formula to get the obtained marks in English-
=VLOOKUP($E$8,Sheet1!$B$2:$L$10,6)

• Later, press the ENTER button for the output.

• Next, use the same type of VLOOKUP formula to get the numbers in the
other subjects. Just we’ll have to change the column index number according
to the subject name in the array of sheet 1.
Here are all of our obtained numbers for roll number 1.
• Insert the minimum passing number in the first box and select the desired
highlight color from the second dropdown box.

• Finally, just press OK.

Now see, the numbers are highlighted with our selected color.
Q.3 How to Make a PowerPoint Presentation

A presentation is made up of multiple slides, and now that we know how to

make one, you can delve deeper into PowerPoint's capabilities.

1. Open a blank presentation again or start from one you've already

created.
If we have already created a presentation, double-click the icon to open the
existing file. Otherwise, open Microsoft PowerPoint, click File in the top left
corner, and click New Presentation. From there, we can follow the prompts to
set up a new presentation.

2. Choose a theme or create your own.

Microsoft offers built-in themes and color variations to help us design our
slides with a cohesive look. To choose from these pre-built themes, choose
the File tab again, select New, choose one of the options, and click Create.
Otherwise, we can use PowerPoint elements, our design sense, and our brand's
color palette to make our own "theme."

3. Create a variety of slides for different purposes.

We don't want to present the same exact slide, only with different content on it.
This would bore the audience. Ensure that we create multiple variations,
accommodating some of the common uses for slides. At minimum, we'll need:

• A title slide

• An agenda or table of contents slide

• A slide that introduces the speaker

• Various content slides (create different layouts considering what kind of

multimedia you'll use)

4. Use the Duplicate Slides feature to save time.

There's no reason to create these designs over and over again. Now that we
have a few to draw from, we can simply duplicate them before inputting our
content. Here's how to do that:

• On the left pane, right-click the thumbnail of the slide we want to duplicate.

• Choose Duplicate Slide from the pop-up menu.

This will automatically add a copy of this slide to the presentation. From there,
we can customize it for your needs.

5. Add transitions to the slides (optional).

Done well, transitions can add a little bit of movement and showmanship to
our presentation. PowerPoint has several transitions built in for us to choose
from.

To access them, select the Transitions tab from the top ribbon. From there, we
can select a transition for it to preview on the screen. To customize it further,
click Effect Options and play with the features to find something that suits
liking. To remove a transition, select Transitions and click None.
6. Add animations to the slides (optional).

Like transitions, animations can add movement, reveal information, and help
us underscore the points we want to hit during our speech. To animate an
element, follow these steps:

• Select the element we want animated by clicking on it.

• Choose Animations from the top ribbon.

• We'll have the option to choose from several effects displayed in the ribbon.
• Clicking on one will give us a preview.
• To customize the animation, select Effect Options.
• To remove an animation, click None in the ribbon.
Some of the ways to customize animations include:
• On Click
• With Previous
• After Previous
• Duration
• Delay

These describe how we want the effect to behave, so play around with them
until we find an effect that suits your liking.

We'll also have the option to move animations around as we edit our slides by
clicking on the Animation Pane button, then reordering the animations in the
list that pops up.
7. Save the presentation.
Click File and Save, making sure to specify which folder or destination we
want our PowerPoint to be stored.
8. Run the presentation.

It's always good to do a trial run to ensure that the slides are set up properly
and the animations fire the way we expect them to.

To present the PowerPoint, go to the Slide Show tab and click Play from
Start. The slide will cover the whole screen, blocking out the desktop and
PowerPoint software.