學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Absolute and Relative References In Microsoft Excel
內容大綱
The purpose of this note is to illustrate how to use cell references in Microsoft Excel. References are necessary when using functions and building models. This teaching note provides students with practice exercises and a supporting Excel workbook.
學習目標
Upon completion of this note and its associated activities, students will be able to:<ul><li>Understand the difference between absolute and relative referencing. </li><li>Know when it is appropriate to use each type of referencing. </li><li>Know the keyboard shortcuts to quickly implement each type of referencing.</lu><ul>