Microsoft Excel Quizzes & Trivia

What do you get when you mix some accountants, lots of paperwork, the world's richest man and a computer? You get Microsoft Excel! The power of this program is unparalleled, but how much of that power can you harness? Do you know how to add up columns? Can you find the number of marked squares in a sheet? Can you have text and a sum in a square? If you said "Yes" to any of those, then these quizzes are for you!

Are you a nerd, or do you just know things? Prove yourself with them all, and see if you can excel and become the top of your class! With questions about equations, sums, numbers, squares and borders, you'll struggle to find boredom in them all. Print it out and spread the sheets on the floor as you attempt to solve these amazing quizzes! Or has your micro brain become soft?

Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it a try and ensure to read up on...

Questions: 20  |  Attempts: 61075   |  Last updated: Oct 21, 2019
  • Sample Question
    A fast way to add up this column of numbers is to click on the cell below the numbers and then:

Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on excel sheet? Let’s play this excel practice quiz and prove...

Questions: 10  |  Attempts: 36319   |  Last updated: Oct 31, 2019
  • Sample Question
    Labels are aligned at the ________ edge of the cell.

Online MCQ Quiz on Microsoft Excel - Set 1 No. of Questions:- 10 Time:- 10 Minutes Full Mark:- 100 Pass Mark:- 70 This Quiz if for those user who wants to test their knowledge in Microsoft Excel. for...

Questions: 10  |  Attempts: 18817   |  Last updated: Dec 2, 2015
  • Sample Question
    Comments put in cells are called …..

Online MCQ Quiz on Microsoft Excel - Set 2 No. of Questions:-...

Questions: 10  |  Attempts: 16022   |  Last updated: Jan 18, 2013
  • Sample Question
    An Excel Workbook is a collection of …….

Online MCQ Quiz on Microsoft Excel - Set 4 No. of Questions:- 10 Time:- 10 Minutes Full Mark:- 100 Pass Mark:- 70   This Quiz if for those user who wants to test their knowledge in Microsoft Excel. for...

Questions: 10  |  Attempts: 13815   |  Last updated: Aug 29, 2018
  • Sample Question
    Which language is used to create macros in Excel?




You May Also Like: Microsoft Excel Flashcards

Microsoft Excel Questions & Answers


Which is the correct sequence of events that will do this if a user wishes to remove a spreadsheet from a workbook?
This is the wrong answer! One cannot remove a spreadsheet from a workbook by saving it.. it has to be "Right click on the spreadsheet tab and select DELETE"
What will be your formula for obtaining the average of the following cells? A1=90 A2=85 A3=80 A4=75 A5=75
To average, you add the numeric values of all the items and then divide by the NUMBER OFITEMS added. Capitalization is not an issue...POSSIBLE ANSWERS TO THIS QUESTION=(A1+A2+A3+A4+A5)/5=AVERAGE(a1:a5)I got the question right, but my answer was marke
Which key do you press to group two or more nonadjacent worksheets?
This is incorrect. The correct answer is CTRL. The key word here is "nonadjacent".SHIFT will group all worksheets between the two that are selected. SHIFT will NOT select nonadjacent worksheets. Holding CTRL while selecting two or more nona
How do you change column width to fit the contents?
The answer to this is B. if you would read the directions carefully, letter A says that you have to do a single click then go to the left. Your main intention is to widen the column that you are using to fit the details that you will place. Why do y
More