Use HLOOKUP and VLOOKUP Functions
Über den Vortrag
Der Vortrag „Use HLOOKUP and VLOOKUP Functions“ von Sonic Performance ist Bestandteil des Kurses „Creating Advanced Formulas in Excel 2013“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
- Introduction
- The Vlookup Function
- The Hlookup Function
- Summary
Quiz zum Vortrag
Range A1:A10 is currently named Employee. To change the range name to Associate, you can:
- Open the Name Manager dialog box, select the range name, and then select Edit.
- Select the range, and then type the new name in the Name box.
- Insert a new cell above the range, type the new range name in the new cell, and then select Create from Selection in the Defined Names group.
- Select the range and then, in the Define Names group, select Define Name.
Which category of functions performs what-if and conditional analysis on data?
- Logical
- Statistical
- Engineering
- Lookup and Reference
Dozent des Vortrages Use HLOOKUP and VLOOKUP Functions
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 |
