This advanced post-test for MS Office Excel 2007\/2010 assesses proficiency in complex functions such as LOOKUP, What If Analysis, and data consolidation. It evaluates the ability to apply Excel tools effectively, enhancing data analysis and presentation skills.
False
True
Rate this question:
Vector Lookup, V Lookup and W Lookup
Vector Lookup, H Lookup and Horizontal Lookup
Vector Lookup, H Lookup and V Lookup
HectorLookup, VLookup and Vector Lookup
Rate this question:
Views
Scenario Manager
Solver
Bookmarks
Rate this question:
Ctrl H
Ctrl K
Alt H
Alt K
Rate this question:
Data Table
Scenario Manager
Goal Seek
Pivot Tables
Rate this question:
True
False
Rate this question:
Array for Data Table
Pivot Table
Vector Lookup
Data Validation
Rate this question:
Icon Range Manager
Icon Range Name
Icon Name Designer
Icon Name Manager
Rate this question:
=LOOKUP(B13,D3:D11,E3:E11)
=VLOOKUP(B13,D3:D11,E11)
=VECTORLOOKUP(B13,D3:D11,E11)
=VHLOOKUP(B13,D3:D11,E11)
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.