Embedded Files
Objective:
Objective:
Students will identify when to use absolute or relative cell references.
Students will identify when to use absolute or relative cell references.
Activities:
Activities:
Watch:
Watch:
- Relative and Absolute References
Read:
Read:
- Excel Unit B: Understand Relative and Absolute References
Do:
Do:
- Complete assessment and submit to instructor.
Assessment:
Assessment:
You will write a brief description of the difference between relative and absolute references and will provide an examples of when each formula and its variations could be used.
You will write a brief description of the difference between relative and absolute references and will provide an examples of when each formula and its variations could be used.
Materials and Resources:
Materials and Resources:
Textbook: Beskeen, D. W., Cram, C. M., Duffy, J. A., Friedrichsen, L. L., & Reding, E. E. (2014). Microsoft Office 2013: Illustrated. Excel Unit B: Understand Relative and Absolute References. Pages 34 & 35
Textbook: Beskeen, D. W., Cram, C. M., Duffy, J. A., Friedrichsen, L. L., & Reding, E. E. (2014). Microsoft Office 2013: Illustrated. Excel Unit B: Understand Relative and Absolute References. Pages 34 & 35
Video: Excel 2013: Relative and Absolute Cell References. (n.d.). Retrieved March 03, 2017, from http://www.gcflearnfree.org/excel2013/relative-and-absolute-cell-references/1/
Video: Excel 2013: Relative and Absolute Cell References. (n.d.). Retrieved March 03, 2017, from http://www.gcflearnfree.org/excel2013/relative-and-absolute-cell-references/1/
Assessment: Lopez, L. C. (2017, March 30). Module 4: Assessment. Retrieved April 02, 2017, from https://docs.google.com/forms/d/e/1FAIpQLSdryY6uYqKVpHMlaleJ4czfJXfLyQhbq_x2yhd5-2rlzdYvIQ/viewform?c=0&w=1
Assessment: Lopez, L. C. (2017, March 30). Module 4: Assessment. Retrieved April 02, 2017, from https://docs.google.com/forms/d/e/1FAIpQLSdryY6uYqKVpHMlaleJ4czfJXfLyQhbq_x2yhd5-2rlzdYvIQ/viewform?c=0&w=1
Google Sites
Report abuse