98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Excel Advanced
microsoft excel courses - Excel Advanced
Resolved · Low Priority · Version Standard
Wed 19 Sep 2007, 14:23Delegate Artur said...
Artur has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced
How and for what $ is used in formulas ?
Mon 1 Oct 2007, 14:58Trainer Amanda said...
RE: Excel Advanced
Hi Artur
Thank you for your question.
The $ sign is used in a formula to create an absolute reference or a mixed reference.
An absolute reference is a reference in a formula that does not change when the formula is moved or copied to another location in your spreadsheet. Example: $E$4.
A mixed reference is a reference in a formula that does not change either the column letter or the row number when the formula is moved or copied to another location in your spreadsheet. Example: $E4 (column E does not change); E$4 (row 4 does not change).
I hope this helps.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Customize the toolbar in Excel 2010You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please. |
