This post-test assesses intermediate skills in Excel 2007 and 2010, focusing on core functions like file handling, shortcuts, formula usage, and text manipulation. It is designed to enhance proficiency in using Excel effectively in various professional settings.
Docx
Pptx
Exls
Xlsx
Rate this question:
Ctrl + F2
Alt + F2
Shift + F2
Ctrl + Alt + F2
Rate this question:
$
&
%
#
Rate this question:
=CONSOLIDATE()
=CONCATENATE()
=TRIM()
=MID()
Rate this question:
365
364.7
364
364.6
Rate this question:
SUM(), LEFT(), DSUM()
FV(), CONCATENATE(), NOW()
FV(), NPV(), PV()
DAY(), Now(), Today()
Rate this question:
=DATE(NOW)
=DAY(NOW)
=NOW()
=(DATE)
Rate this question:
Name of cell reference
Name of worksheet
Absolute reference
One of function in math and trig
Rate this question:
IV, 65536
XFD, 1048576
Unlimited
ZZZ, 999999
Rate this question:
Not good
Good
Not valid
No result appear
Rate this question:
Formula Tab --> within Function Library group
Formula Tab --> within Defined Named group
Insert Tab --> within Function Library Group
Insert Tab --> within Defined Named group
Rate this question:
=SUMIF(D4:D10,">600")
=ROUNDUP(C2/C3,1)
=IF(AVERAGE(B3:B6)>25,SUM(B3:B6),0)
=LEFTS(D4)
Rate this question:
Quiz Review Timeline (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Charts In MS Excel
Explore the utility of charts in MS Excel through this engaging quiz. Learn to identify different chart types, understand core components, and assess the effectiveness of...
Questions:
7 |
Attempts:
1775 |
Last updated:
Sep 22, 2024
|
Excel Basics Quiz (Level1)
This quiz depicts some of the many different question of Excel Basics
Questions:
10 |
Attempts:
538 |
Last updated:
May 13, 2023
|
The Ultimate Microsoft Excel Trivia Knowledge! Quiz
This is what is known by many as the ultimate excel trivia. A lot of people have a hard time understanding how this feature works when compared to the other Microsoft...
Questions:
20 |
Attempts:
656 |
Last updated:
Mar 21, 2023
|
Microsoft Excel Trivia Quiz Questions!
Test your skills with our Microsoft Excel Trivia Quiz! This quiz covers essential functions such as keyboard shortcuts for copy, cut, and more, understanding interface elements,...
Questions:
40 |
Attempts:
1244 |
Last updated:
Apr 28, 2024
|
Advanced Excel Online Test
Take your Excel skills to the next level with our Advanced Excel Online Test. Designed for seasoned users, this quiz will challenge your proficiency in complex functions,...
Questions:
10 |
Attempts:
12937 |
Last updated:
May 15, 2024
|
Financial And Excel Modelling Quiz
Financial modeling entails building up an abstract representation, aslo known as a model of a real world financial situation. It is a mathematical build representation which has...
Questions:
10 |
Attempts:
817 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.