Learn MS Office Software Training from the Best Tutors
Affordable fees 1-1 or Group class Flexible Timings Verified Tutors Search in
Asked by Poonam Last Modified
Answer 
Using dollar sign means either make column or row or both constant. When we copy formulae vertically down or horizontally right, it freezes reference of particular cell and do now allow that reference to move from it's position.
Type of cell references where $ sign is used:
1. Absolute Referece (Dollar sign against both row and column reference)
2. Mixed Reference with column constant (Dollar sign against column name only)
3. Mixed Reference with row constant (Dollar sign against row number only)
read less
Hi Poonam
$ sign in excel is used for Absolute reference. It is a notation used if you want the same cell to be referred across rows or columns for various formulae.
Usually it may be noted that the cell reference will sequentially change when we drag a formula. However with $ we can define the reference to same cell without changing.
read less
Hi Poonam,
Dollar sign or even Rupee sign or any currency is used when we have data with Money involved.
Like for cost value , sale value.
With help of currency we can make it global.
For example you received a data where cost is written only 120, now you cannot evaluate whether it is 120$ or 120Rupee. So that is the reason , to make it more specific we use Currency sign.
Hope it helps.
read less
View 6 more Answers
Related Questions
What is use of VBA? Can you explain it?
which is the best institute or college for Power bi and AWS course with job Support in Pune location?
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Recommended Articles
Why Should you Become an IT Consultant
Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...
Read full article >
Learn Microsoft Excel
Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...
Read full article >
Make a Career in Mobile Application Programming
Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...
Read full article >
Make a Career as a BPO Professional
Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...
Read full article >
Looking for MS Office Software Training ?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near youThe best tutors for MS Office Software Training Classes are on UrbanPro
The best Tutors for MS Office Software Training Classes are on UrbanPro
5
