Absolute Reference is when you anchor a particular cell(s) in your formula. When you copy an absolute reference to another location, Excel does not change the absolute cell reference. However, the reference will change when it is a Relative Cell Reference.
Data validation rules control what type of data an end user can enter into selected cells. Such valid data can be of a specific text length, particular dates, or whole numbers. You can also create your own drop down list of choices. This feature helps maintain the integrity of the data populating your database.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.