Zoom International School: Name: Trishan Bouri Class: X Roll: 31 Sec: C Subject: Information Technology

ZOOM INTERNATIONAL
SCHOOL
Name: TRISHAN BOURI

Class: X
Roll: 31
SEC: C
Subject: Information Technology
Project on Mail Merge (Digital
Documentation) & Goal Seek
(Electronic Spreadsheet)
Index
SL Topic Page
No No
Digital Documentation (Advanced)
1 Implement mail merge
Electronic Spreadsheet (Advanced)
2 Use Goal Seek
Bibliography
Digital Documentation (Advanced)
1. Implement Mail Merge
Create a mail Merge Document: Letter
1.In a blank Microsoft Word document, click on the

Mailings tab, and in the Start Mail Merge group,
click Start Mail Merge .
2.Click Step-by-Step Mail Merge Wizard .
3.Select your document type. …
4.Select the starting document. …
5.Select recipients. …
6.Write the letter and add custom fields.
TO Make The Data Source And
Entering Data
•Select the Tools-Data Source menu.
•Click New Data Source.
•Enter a name for your Data Source. NOTE: I am
going to use TEST as the
Data Source name.
•Press Tab.
•Select dBase as the Data Source. …
•Press Tab.
•Enter a directory for the program to store the
data files in. …
Click Apply.
•
Merging The Data Source With Main
Document
•Choose File → New → Database.

•Select Connect to an existing database, with Text as
the format.
•Click Next .
•Specify the directory where the text files are. …
•When all the settings look correct, click Next .
•Unmark the option to open the database for
editing. …
•Click Finish .
2. Goal Seek
Using Goal Seek
Goal Seek is Excel's built-in What-If Analysis tool

that shows how one
value in a formula impacts another. More
precisely, it determines what
value you should enter in an input cell to get the
desired result in a
formula cell.
The best thing about Excel Goal Seek is that it
performs all calculations
behind the scenes, and you are only asked to
specify these three
parameters:
• Formula cell
• Target/desired value
• The cell to change in order to achieve the
target
The Goal Seek tool is especially useful for doing
sensitivity analysis in
financial modeling and is widely used by
management majors and
business owner. But there are many other uses
that may prove helpful
to you. For instance, Goal Seek can tell you how
much sales you have to
make in a certain period to reach $100,000 annual
net profit. Or, what
score you must achieve for your last exam to
receive an overall
passing score of 70%. Or, how many votes you
need to get in order to
win the election.
On the whole, whenever you want a formula to return

a specific result but are not sure what input value
within the formula to adjust to get that result, stop
guessing and use the Excel Goal Seek function!
Steps to use Goal seek:

1.Open a new, blank worksheet.
2.First, add some labels in the first column to make it
easier to read the worksheet.
a.In cell A1, type Loan Amount.
b.In cell A2, type Term in Months.
c.In cell A3, type Interest Rate.

d.In cell A4, type Payment.
3.Next, add the values that you know.
a.In cell B1, type 100000. This is the amount that you
want to borrow.
b.In cell B2, type 180. This is the number of months
that you want to pay off the loan.
4.Next, add the formula for which you have a goal.
For the example, use the PMT function:
a.In cell B4, type =PMT(B3/12,B2,B1). This formula
calculates the payment amount. In this example,
you want to pay $900 each month. You don't enter
that amount here, because you want to use Goal
Seek to determine the interest rate, and Goal Seek
requires that you start with a formula.

The formula refers to cells B1 and B2, which contain
values that you specified in preceding steps. The
formula also refers to cell B3, which is where you will
specify that Goal Seek put the interest rate. The
formula divides the value in B3 by 12 because you
specified a monthly payment, and the PMT function
assumes an annual interest rate.
Because there is no value in cell B3, Excel assumes a
0% interest rate and, using the values in the example,
returns a payment of $555.56. You can ignore that
value for now.

BIBLIOGRAPHY:
1.https://en.wikipedia.org/wiki/Wiki
2.https://www.torproject.org/
3.Information technology Class 10 Sumita
Arora
4.A Textbook of Information Technology for
Class 10

Zoom International School: Name: Trishan Bouri Class: X Roll: 31 Sec: C Subject: Information Technology

Uploaded by

Copyright:

Available Formats

Zoom International School: Name: Trishan Bouri Class: X Roll: 31 Sec: C Subject: Information Technology

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Zoom International School: Name: Trishan Bouri Class: X Roll: 31 Sec: C Subject: Information Technology

Uploaded by

Copyright:

Available Formats

ZOOM INTERNATIONAL

Name: TRISHAN BOURI

Create a mail Merge Document: Letter

1.In a blank Microsoft Word document, click on the

•Choose File → New → Database.

Using Goal Seek

Goal Seek is Excel's built-in What-If Analysis tool

On the whole, whenever you want a formula to return

Steps to use Goal seek:

2.First, add some labels in the first column to make it

easier to read the worksheet.

a.In cell A1, type Loan Amount.

b.In cell A2, type Term in Months.

c.In cell A3, type Interest Rate.

3.Next, add the values that you know.

b.In cell B2, type 180. This is the number of months

that you want to pay off the loan.

4.Next, add the formula for which you have a goal.

For the example, use the PMT function:

a.In cell B4, type =PMT(B3/12,B2,B1). This formula

calculates the payment amount. In this example,

you want to pay $900 each month. You don't enter

that amount here, because you want to use Goal

Seek to determine the interest rate, and Goal Seek

requires that you start with a formula.

values that you specified in preceding steps. The

formula also refers to cell B3, which is where you will

specify that Goal Seek put the interest rate. The

formula divides the value in B3 by 12 because you

specified a monthly payment, and the PMT function

assumes an annual interest rate.

Because there is no value in cell B3, Excel assumes a

0% interest rate and, using the values in the example,

returns a payment of $555.56. You can ignore that

value for now.

You might also like