Monday to Friday
9am to 5pm
email
info@cadtraining.com.my // info@caddesignschool.com
phone
03-80630414 // 012-2737190
location
3rd Floor, 27 Jalan Puteri 4/6, Bandar Puteri, 47100 Puchong, Selangor
fkadkfkdajfkdf
Excel Advanced Quiz
This is the final quiz in our level test set
Test your expertise with our advanced level quiz.
1 / 10
In a PivotTable, what does the "Values" area represent?
2 / 10
What is a pivot table?
3 / 10
How do you create a pivot table?
4 / 10
What does the "What-If Analysis" feature in Excel allow you to do?
5 / 10
How can you update the source data range for an existing PivotTable?
6 / 10
Which Excel function can perform both vertical and horizontal lookups, allowing you to search for a value in both rows and columns simultaneously?
7 / 10
If you want to fix a cell reference, you will use –
8 / 10
The Not Equal operator in Excel is –
9 / 10
What are the benefits of using a pivot table?
10 / 10
What is the difference between VLOOKUP and HLOOKUP?
Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.
Thank you
Restart quiz
View all posts