Absolute Cell References
About the Lecture
The lecture Absolute Cell References by Sonic Performance is from the course Performing Calculations in Excel 2013. It contains the following chapters:
- Introduction
- Calculate the Commission
- Absolute and relative Cell References
- Summary
Included Quiz Questions
In a grading worksheet, if cell C8 contains the number of questions answered incorrectly, which formula would accurately return the percentage of questions answered correctly on a 100-question exam?
- (100-C8)/100
- 100-C8/100
- C8-100/100
- (C8-100)*0.01
Which button contains frequently used formulas for easy access?
- AutoSum
- Insert Formula
- Formula AutoComplete
- Function Library
Which is an example of an absolute reference?
- $A$7
- A7
- A$7
- $A7
Author of lecture Absolute Cell References
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
