RP Memorial Public 2024-25

School
IT
PRACTIC
AL FILE

NAME: SHIVAM
ADMN.: 3922
CLASS: X A
SUBJECT: INFORMATION TECHNOLOGY
 Acknowledgement
I, Ansh , a student of class X A at RP Memorial
Public School, would like to express my sincere
gratitude to my IT teacher, Ms. Savitri, for their
invaluable guidance, support, and
encouragement throughout the completion of
this practical file. Their expertise and dedication
have greatly helped me in understanding the
concepts and completing the tasks successfully.
I would also like to thank my school, RP
Memorial Public School, for providing the
necessary resources and a conducive learning
environment. Lastly, I am grateful to my parents
and friends for their constant support and
encouragement.
 Thank you all.

Certification
This is to certify that Ansh , a student of class
X A at RP Memorial Public School, has
successfully completed the IT practical file
for the academic session [2024-25]. The
work presented in this file is original, and it
has been carried out under my guidance and
supervision.
I have reviewed the work thoroughly and
found it satisfactory. Ansh has demonstrated
a clear understanding of the subject matter
and has followed the prescribed guidelines
diligently.
 I wish him all the best for his future
endeavours.

Ms. Savitri
Teacher Sign.

Q.1 Write the steps of mail merge in MS word.

Ans. 1. Open MS Word: Start by opening Microsoft Word and creating a new blank document.

2. Go to the Mailings Tab: Click on the "Mailings" tab in the toolbar at the top of the screen.
3. Start Mail Merge: In the "Mailings" tab, click on the "Start Mail Merge" button. Choose the type
of document you want to create (e.g., Letters, Envelopes, Labels, etc.).

4. Select Recipients: Click on "Select Recipients" and choose one of the following options:

● Type a New List: Create a new list of recipients within Word.

● Use an Existing List: Use a previously saved list from Excel, Access, or another source.

● Choose from Outlook Contacts: Use your Outlook contact list.

5. Insert Merge Fields: Click on "Insert Merge Field" to add the placeholders for the data that will
change for each recipient, such as Name, Address, etc. Place these fields where you want the
information to appear in the document.
6. Write Your Document: Type your document, inserting the merge fields where personalized
information should appear. Ensure your document is formatted correctly with all necessary merge
fields.

7. Preview Your Results: Click on "Preview Results" to see how your document will look with the
data merged. You can use the arrows to navigate through different records to check for accuracy.

8. Finish & Merge: Once satisfied, click on "Finish & Merge" and choose one of the following
options:

● Edit Individual Documents: Creates a new document with all the merged data.

● Print Documents: Send the merged documents directly to your printer.

● Send Email Messages: Send the merged documents via email if applicable.
9. Save the Merged Document: Save your final merged document if needed, especially if you have
chosen to edit individual documents.

Q.2 What is “What If Analysis”?

Ans. What-If Analysis is a decision-making tool used in data analysis, particularly in spreadsheets
like Microsoft Excel, to predict the outcome of different scenarios by changing the input values. It
helps you understand how varying one or more variables impacts the overall result of a formula or
model. This analysis is especially useful in forecasting, budgeting, financial modeling, and other
areas where you need to evaluate potential changes and their effects.

Key Components of What-If Analysis:

1. Scenario Manager:

o Allows you to create and compare different sets of input values (scenarios) to see
how they affect the outcome. For example, you can create best-case, worst-case,
and most likely scenarios for a financial plan.

2. Goal Seek:

o Helps you find the necessary input value to achieve a specific goal or target result.
For instance, if you know the desired output, Goal Seek will calculate the input
needed to achieve that result.

3. Data Table:

o Allows you to analyse how changes in one or two variables affect the outcome.
You can create a one-variable data table or a two-variable data table to see the
impact of different combinations of values on your result.

Example of What-If Analysis:

Imagine you are creating a budget and want to see how changes in your income or expenses affect
your savings. Using What-If Analysis, you can adjust your income or expense values to see how
your savings balance will change without manually recalculating each time.

Uses of What-If Analysis:

● Financial Planning and Budgeting: Assess how changes in costs, revenues, or investments
impact profits.

● Project Management: Predict outcomes based on different resource allocations or

● Sales Forecasting: Examine how changes in pricing, sales volume, or market conditions
affect revenue.
 ● Personal Decision-Making: Plan personal finances by evaluating changes in income,
expenses, or savings goals.

What-If Analysis helps in making informed decisions by allowing you to explore various
possibilities and their potential outcomes.

Q.3 Write the steps to insert and modify images.

Steps to Insert an Image in MS Word

1. Open MS Word: Open your document in Microsoft Word.

2. Place the Cursor: Click where you want the image to appear in the document.

3. Go to the Insert Tab: Click on the "Insert" tab located on the ribbon at the top of the
screen.
 4. Click on Pictures:

o Insert Picture from Device: Click on "Pictures" and select "This Device" to insert an
image from your computer.

o Online Pictures: Choose "Online Pictures" to search and insert an image from the
web or a stock image.

5. Select the Image: Navigate to the folder containing the image, select the image file, and
click "Insert."

Steps to Change or Modify an Image in MS Word

1. Select the Existing Image: Click on the image in your document that you want to replace. This
will highlight the image and display the "Picture Format" tab at the top of the screen.

2. Go to the Picture Format Tab: Once the image is selected, click on the "Picture Format" tab in
the ribbon.

3. Click on Change Picture:

● In the "Adjust" group on the left side of the Picture Format tab, click on "Change Picture."

4. Choose the Source of the New Image:

● From a File: Select "From a File" to choose a replacement image from your computer.

● Online Pictures: Select "Online Pictures" to search for a new image from the web.

● From Icons: Choose "From Icons" to select an icon or graphic from the available options.

5. Select the New Image: Navigate to the location of the new image, select it, and click "Insert."