Are you an advanced Excel user? Find out by answering the following 10 Excel questions. They touch on various topics, from formulas, pivot tables, shortcuts, etc. Click “Quiz Start” to begin answering the questions.
To answer the questions just tick on the correct answer and click on the next button to load more questions. The timer is set to 10 minutes to complete the 10 questions. That means you have one minute to answer every question. You can play the trivia again and new questions will be automatically retrieved from our database. In case you find this quiz very challenging you can try the Excel Quiz for beginners. If you are preparing for an Interview, these questions will adequately equip you.
#1. Which of the following formulas cannot be used to join the first, second and last name like in the image below?
#2. Why is the following number in cell E1 appear different from the formula bar?
#3. Which of the following is NOT a function that pivot tables can perform?
#4. What is the name of the following Excel chart?
#5. Which of the following custom code changes the negative number format to brackets?
The correct code is #,##0.00;(#,##0.00)
#6. You can display the current date in excell by using a function. Which is it?
You can display the date today by using the formal =TODAY(). If you want to display the current time then you need to use the =now() function
#7. The image below shows columns with fruit names and prices. Which formula can you use to count the sum of mangoes in the list?
SUMIF calculates the total amount of one item if a certain condition is met in another range. It is different from COUNTIF which only counts items that match a certain criterion.
#8. Excel allows users to get rid of spaces inside data. Which of the following formula can get rid of spaces from the cell E8?
=TRIM() is the function used to remove spaces in Excel.
#9. What is the Windows shortcut to launch the VBA editor?
