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.
MS Word & Excel Quiz # 2
This quiz tests knowledge on MS Word & Excel, focusing on macros, shortcut keys, AutoFormat, and AutoCorrect features.
Questions:
25 |
Attempts:
624 |
Last updated:
Mar 15, 2023
|
Test On Information Technology! Quiz
Information technology is generally all about the use of computers to carry out different tasks. How conversant are you will Microsoft Office tools and how they are used? If you...
Questions:
20 |
Attempts:
1871 |
Last updated:
Mar 21, 2023
|
Office 365: Word, Excel And PowerPoint Assessment
This assessment evaluates proficiency in Microsoft Office tools: Word, Excel, and PowerPoint. It tests knowledge of fonts, editing techniques, tab functionalities, and...
Questions:
10 |
Attempts:
380 |
Last updated:
Mar 21, 2023
|
BUSIM1 SEMESTER EXAM - FALL
Take an exam to see how well you know some Word basics.
Content in this quiz was excerpted from Training on Microsoft Office Online.
Questions:
20 |
Attempts:
953 |
Last updated:
Mar 22, 2023
|
Microsoft Office Suite Quiz
Do you consider yourself a Microsoft Office expert? Or are you just starting to explore the power of these essential productivity tools? Take our Microsoft Office Skills Quiz...
Questions:
10 |
Attempts:
149 |
Last updated:
Dec 09, 2024
|
Microsoft Office Tools And Techniques Concepts Questions! Trivia Quiz
This is a Microsoft Office Tools and Techniques Concepts Trivia Questions Quiz. This application is the go-to app when it comes to the different organizations, so much emphasis is...
Questions:
30 |
Attempts:
321 |
Last updated:
Mar 16, 2023
|
Wait!
Here's an interesting quiz for you.