Learn the difference between Relative and Absolute references used in formulas, and how to determine when an Absolute reference is needed. Author Jen McBee discusses both types of references, and shows you a great tip for viewing the precedence and depen
- [Instructor] When performing calculations…there may be times when you do not want…a cell reference to change when you copy a formula…from one cell to another.…In Excel there are two types of references.…A relative references such as A1…and an absolute reference.…And your absolute references can be $A$1 where…both the column and the row remain constant.…$A number one where just the column remains constant.…And A$1 where just the row remains constant.…
In this video, we'll review both…relative and absolute references…focusing most on the absolute reference.…You can bet that using absolute references…in formulas will be covered on the Excel 2010 MOS exam.…I have the 06_03 exercise file open.…So, let's tackle this topic.…First, I'd like to demonstrate how to create…a relative reference.…It's something that you do all the time.…In cell F4 I'm going to start my calculation.…It's a simple equals the units sold times the cost.…
Excel is just looking to the left to gather the information…for units sold and the cost.…And if I copy this formula down a few rows…
Explore the MOS certification program, its cost, and its format and walk through each Excel certification objective in detail. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.
- Preparing for the exam
- Saving Excel files in different formats
- Printing workbooks and worksheets
- Inserting headers, footers, and document properties
- Inserting, copying, and moving data
- Formatting cells and worksheets
- Creating, deleting, copying, and moving worksheets
- Splitting and arranging windows
- Creating basic and conditional logic formulas
- Creating named ranges to use in formulas
- Applying conditional formatting
- Creating charts
- Inserting and modifying SmartArt
- Filtering and sorting data
- Taking a full-length practice exam
Skill Level Intermediate
Windows 10 Anniversary Update Essential Trainingwith Nick Brazzi7h 55m Appropriate for all
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 55s
2. Manage the Worksheet Environment
3. Create Cell Data
4. Format Cells and Worksheets
5. Manage Worksheets and Workbooks
6. Apply Formulas and Functions
7. Present Data Visually
8. Share Worksheet Data with Others
9. Analyze and Organize Data
10. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.