Monday to Friday
9am to 5pm
email@example.com // firstname.lastname@example.org
03-80630414 // 012-2737190
3rd Floor, 27 Jalan Puteri 4/6, Bandar Puteri, 47100 Puchong, Selangor
Excel Basics Quiz
Don't know where your level of Excel knowledge is?
Try out our Basic level quiz and find out today!
1 / 10
2 / 10
The intersection of a column and a row in MS Excel worksheet is known as _______
3 / 10
Formulas in Excel start with ________
4 / 10
Which keyboard shortcut is used to paste only the values (without formatting) in Excel?
5 / 10
Which Excel feature allows you to combine data from multiple cells into a single cell?
6 / 10
Which of the following functions is used to find the highest value in a range of cells?
7 / 10
In Microsoft Excel spreadsheets, COLUMNS are labelled as _______
8 / 10
9 / 10
In Microsoft Excel spreadsheets, rows are labelled as _______
10 / 10
Which keyboard shortcut is used to insert a new row in Excel?
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.
Excel Intermediate Quiz
Already mastered the basics?
Put your skills to the test in our intermediate level quiz.
What does the Consolidate feature in Excel allow you to do?
What is the purpose of conditional formatting in Excel?
How can you add data labels to a chart in Excel? /
What is the purpose of using the "Sparklines" feature in Excel?
What does the function IFERROR do in Excel? /
Which Excel feature allows you to visually represent data using different types of graphical representations? /
What is the purpose of using data validation in Excel?
Which Excel feature allows you to ensure that data entered into a cell meets specific criteria or conditions?
Which Excel feature allows you to combine data from multiple cells into a single cell? /
Excel Advanced Quiz
This is the final quiz in our level test set
Test your expertise with our advanced level quiz.
What are the benefits of using a pivot table?
If you want to fix a cell reference, you will use –
In a PivotTable, what does the "Values" area represent?
How do you create a pivot table?
What is a pivot table?
How can you update the source data range for an existing PivotTable?
What is the difference between VLOOKUP and HLOOKUP?
What does the "What-If Analysis" feature in Excel allow you to do?
The Not Equal operator in Excel is –
Which Excel function can perform both vertical and horizontal lookups, allowing you to search for a value in both rows and columns simultaneously?
View all posts
Copyright © CAD TRAINING CENTRE | All Rights ReservedDesign & Developed by Themeshopy