Creating a Loan Calculator-3

3 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.17
You save:  د.إ146.91
List Price:  A$181.84
You save:  A$51.96
List Price:  ৳11,872.99
You save:  ৳3,392.52
List Price:  CA$178.23
You save:  CA$50.92
CHF 88.88
List Price:  CHF 124.44
You save:  CHF 35.55
List Price:  kr859.15
You save:  kr245.49
List Price:  €115.48
You save:  €32.99
List Price:  £102.74
You save:  £29.35
List Price:  HK$1,085.24
You save:  HK$310.09
List Price:  ₹10,246.07
You save:  ₹2,927.65
List Price:  RM566.95
You save:  RM162
List Price:  ₦53,266.19
You save:  ₦15,220
List Price:  kr1,195.02
You save:  kr341.45
List Price:  NZ$196.73
You save:  NZ$56.21
List Price:  ₱6,728.52
You save:  ₱1,922.57
List Price:  ₨22,475.39
You save:  ₨6,422
List Price:  S$186.08
You save:  S$53.17
List Price:  ฿4,196.90
You save:  ฿1,199.20
List Price:  ₺1,045.53
You save:  ₺298.74
List Price:  B$747.52
You save:  B$213.59
List Price:  R2,097.59
You save:  R599.35
List Price:  Лв225.73
You save:  Лв64.50
List Price:  ₩154,282.92
You save:  ₩44,083.98
List Price:  ₪454.74
You save:  ₪129.93
Already have an account? Log In


Objective. By the end of this activity, you should be able to explain how to apply conditional formatting, copy and rename sheets, color sheet tabs, pad sheets, insert links. Let's now learn using conditional formatting. To do so, select the required cells. Then click on conditional formatting. Click on icon sets, and then select icon set option.

Let's now learn the renaming and coloring worksheet. To do so, click on format. Then click on rename sheet. Enter the suitable name and then press Enter key on the keyboard. Click on format Then, click on That color and then select a suitable color. Let's now learn copying and pasting worksheet.

To do so, click on format. Then click on move or copy. The move or copied window is displayed on your screen. Click mu two and click on create a copy. Now click on OK. Now change the data as per your requirement. Similarly, you can copy and paste other sheet in Sochi.

The new sheet has been inserted. You can add the required data as displayed. Let's now learn inserting hyperlinks. To do so click the cell then click on Insert tab click on hyperlink the Insert Hyperlink window is displayed on your screen. Click on place in this document then click on car loan. Then click on OK. To navigate click on FC bank car loan summary you have completed the activity.

You are now able to apply conditional formatting, copy and rename sheets, color sheet tabs at sheets, insert links quick summary. We have reached the end of the case study. In the process, we have learned to enter and Format Data. Use the merge and center feature. Apply cell shading, adjust columns column and row height. Create borders insert Crews use shapes, use symbols, use formulas, insert pictures, create charts, apply conditional formatting, copy and rename sheets, color sheet tabs.

Sign Up


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.