TabletWise.com
 

Creating a Loan Calculator-2

8 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
A$129.88
List Price:  A$181.84
You save:  A$51.96
৳8,480.46
List Price:  ৳11,872.99
You save:  ৳3,392.52
CA$127.31
List Price:  CA$178.23
You save:  CA$50.92
CHF 88.88
List Price:  CHF 124.44
You save:  CHF 35.55
kr613.66
List Price:  kr859.15
You save:  kr245.49
€82.48
List Price:  €115.48
You save:  €32.99
£73.38
List Price:  £102.74
You save:  £29.35
HK$775.14
List Price:  HK$1,085.24
You save:  HK$310.09
₹7,318.41
List Price:  ₹10,246.07
You save:  ₹2,927.65
RM404.95
List Price:  RM566.95
You save:  RM162
₦38,046.19
List Price:  ₦53,266.19
You save:  ₦15,220
kr853.56
List Price:  kr1,195.02
You save:  kr341.45
NZ$140.52
List Price:  NZ$196.73
You save:  NZ$56.21
₱4,805.95
List Price:  ₱6,728.52
You save:  ₱1,922.57
₨16,053.39
List Price:  ₨22,475.39
You save:  ₨6,422
S$132.91
List Price:  S$186.08
You save:  S$53.17
฿2,997.70
List Price:  ฿4,196.90
You save:  ฿1,199.20
₺746.78
List Price:  ₺1,045.53
You save:  ₺298.74
B$533.92
List Price:  B$747.52
You save:  B$213.59
R1,498.23
List Price:  R2,097.59
You save:  R599.35
Лв161.23
List Price:  Лв225.73
You save:  Лв64.50
₩110,198.94
List Price:  ₩154,282.92
You save:  ₩44,083.98
₪324.81
List Price:  ₪454.74
You save:  ₪129.93
Already have an account? Log In

Transcript

Objective. By the end of this activity, you should be able to explain how to insert rows. Remove gridlines insert pictures, enter and Format Data, use shapes, insert symbols, use formulas, create charts. Let's now learn inserting rows. To do so select the row, then click on Insert. Then click on Insert sheet rows.

Notice the change now you can format the rows as required. Let's now learn removing grid lines. To do so, click the View tab. Click on grid lines. Let's now learn inserting pictures. To do so click the Insert tab.

Then click on pictures. The insert picture window is displayed on your screen, browse the folder, then click on suitable picture and then click on thing so just selected picture has been inserted Now drag to position the image suitably. Now click the cell Now drag it to suitable position. Similarly, you can insert other images. Let's now learn entering other data. You can repeat the same process for entering data as we did earlier.

Then click on shapes and then select a suitable shape Now track two brothers. Let's now learn enhancing sheep. To do so click on Save. Then click on more colors. The colors window is displayed on your screen, select suitable color and then click on OK. Now click on shape outline and then click on no outline. Nope is the change.

Similarly, you can insert other shapes. Now we will learn inserting symbols. To do so click on cell then click on number format. The format cells window is displayed on your screen. Click on currency then click on decimal places. Next, click on symbol drop down Scroll to view the appropriate symbol and then select English United States and then click on OK. Notice the change.

We will now learn to use formula for the same, select the cell. Then enter the formula in the formula bar and then select the interest rate. You will need to convert the annual rate to a monthly rate by dividing the value in cell 21 by 12. So type by 12 and select lone tenure cell. After selecting the cell, insert a comma. Now at last select the cell containing loan amount And then press Enter key on the keyboard.

Now let's type new formula in the cell E 24. You can see a formula suggestion list as you start typing. Select c u m IP empty from the formula suggestion list. Click into cell containing interest rate. as we did earlier, we need to convert the annual rate to a monthly rate. So, type pipeline and then select the cell containing loan tenure.

Then type multiplied by 12 and select cell having the loan amount value like one and then select the cell containing loan tenure. Type the remaining formula and press ENTER key on the keyboard Now let's insert the total payment. To do so, click AutoSum from editing group and click sum. Select the required cells. Then press ENTER key on the keyboard. You can see the total payment amount has been calculated as desired.

Scroll down to see the other cell containing formula. Notice the change let's now learn inserting pie chart. To do so, click the cell then press ctrl key and then select the cell. Repeat the same process. Now you can insert tab click on Insert file and then select suitable file. Now skim the pie chart as per the requirement and then drag to position the pie chart suitably.

Now we will learn to change the pie chart style. To do so, click Add chart element. Then click on legend. Then click on suitable option. Notice the change let's now learn formatting a pie chart. To do so, click the shape fill.

Then click on more colors. The colors window is displayed on your screen. Select suitable color, then click on OK. Now click the text then click on text and then click on suitable color. The required name. Now press Escape key on the keyboard. Click on Home tab.

Then click on bold. enhance the other text as per requirement. Then click on Design tab. Then click Add chart element. Click the data labels. Then select center.

Click the Format tab, click on shape and then select double color. Now you can track the shape as required. Somebody who have completed the activity. You are now able to insert rows. Remove grid lines, insert pictures, enter and Format Data. Use shapes, insert symbols, use formulas, create charts.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to TabletWise learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.