Absolute Cell References
Über den Vortrag
Der Vortrag „Absolute Cell References“ von Sonic Performance ist Bestandteil des Kurses „Performing Calculations in Excel 2013“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
- Introduction
- Calculate the Commission
- Absolute and relative Cell References
- Summary
Quiz zum Vortrag
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
Dozent des Vortrages Absolute Cell References
Sonic Performance
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
