Microsoft Excel Quizzes & Trivia
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 QuestionA 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 QuestionLabels 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 QuestionComments 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 QuestionAn 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 QuestionWhich language is used to create macros in Excel?
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?
More
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
Welcome to the ultimate Microsoft Excel Quiz! Whether it’s for school, college, work or personal use, Excel is an incredibly handy spreadsheet software that allows you to track and analyse data of all kinds. What do you...
Questions: 115  Attempts: 10123  Last updated: Jan 21, 2019

Sample QuestionThe number of rows in an Excel 2007 worksheet is:
Online MCQ Quiz on Microsoft Excel  Set 5
No. of Questions: 10
Time: 10 Minutes
Full Mark: 100
Pass Mark:...
Questions: 10  Attempts: 9186  Last updated: Jan 18, 2013

Sample QuestionThe first cell in EXCEL worksheet is labeled as
Online MCQ Quiz on Microsoft Excel  Set 3
No. of Questions: 10
Time: 10 Minutes
Full Mark: 100
Pass Mark:...
Questions: 10  Attempts: 8712  Last updated: Jan 18, 2013

Sample QuestionWhich Chart can be created in Excel?
Online MCQ Quiz on Microsoft Excel  Set 6
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: 8520  Last updated: Feb 27, 2013

Sample QuestionB7:B9 indicates:
During this quiz/test, each student will be able to:
Â§ Be introduced to Microsoft Excel
Â§ Be able to describe what a spreadsheet is
Â§ Describe a spreadsheet (cells, rows, and...
Questions: 24  Attempts: 7717  Last updated: Jul 30, 2011

Sample QuestionA ________________ consists of a grid made from columns and rows?
Microsoft Excel is a spreadsheet program for creating and editing spreadsheets that are saved with a .xls or .xlsx file extension. MS Excel is widely used for data processing and financial modelling. To become an expert one...
Questions: 10  Attempts: 4752  Last updated: Apr 8, 2019

Sample QuestionTRUE OR FALSE: Number formats affect how numbers look onscreen and when printed.
Microsoft Excel is a spreadsheet program used for calculations, making charts, and recording data about all sorts of business processes. Most companies wish their staff to have adequate knowledge on how to use this application....
Questions: 15  Attempts: 3682  Last updated: Feb 4, 2020

Sample QuestionA fast way to add up this column of numbers is to click in the cell below the numbers and then:
Â Â Â Â Â Â Â Â Â Â MULTIPLE CHOICE QUESTIONSÂ AND TRUE/FALSEÂ Â Â Â Â Â Â Â Â Â Â Â Put your answers to the left of the numberaNS
Questions: 20  Attempts: 2371  Last updated: Sep 7, 2017

Sample QuestionTutorial 1Excel is an electronic version of a(n)
The quiz will test the basic knowledge of MS Excel
which is very vital in our day to day job. Also, repeating the quiz
will enhance your knowledge.
Questions: 9  Attempts: 2044  Last updated: Jan 15, 2013

Sample QuestionWhat is shortcut key to open cell format window?
A short test for basic skills in Excel.
Questions: 5  Attempts: 1844  Last updated: Jun 15, 2017

Sample QuestionWhich Excel feature can summarize the data in a large table?
This test is designed to test your basic knowledge of Excel concepts. Please read each question carefully and select the BEST answer. Upon successful completion of the quiz, you will have the option of printing a...
Questions: 19  Attempts: 1643  Last updated: Dec 14, 2012

Sample QuestionWhat is an Excel Workbook?
The Microsoft Excel or MS Excel is a spreadsheet software developed by Microsoft. The core purpose of this application is to manage financial modeling, data processing using the graphing tools, pivot tables, and calculation. This...
Questions: 10  Attempts: 1510  Last updated: Jun 19, 2019

Sample QuestionWhy is Excel a useful program?
Use the data from the file "State Data Test" workbook to answer the following questions.ï¿½ When you are done raise your hand and I will come by to check your test.ï¿½ Good Luck!ï¿½ï¿½ï¿½
Questions: 11  Attempts: 1495  Last updated: Feb 19, 2014

Sample QuestionTrue or False? If the data is sorted Alphabetically by "CAPITAL" Bismark is the 7th Capital listed? *
A quick quiz to test proficiency in Excel 2003
Questions: 20  Attempts: 1472  Last updated: Jul 30, 2011

Sample QuestionWhich of the following allows you to delete a spreadsheet from a workbook?
Here is a basic knowledge exam based off of quiz's from my college course.
Questions: 77  Attempts: 1422  Last updated: Dec 26, 2012

Sample QuestionIn pie charts with legends, it's best to make the slice colors as similar as possible.
This quiz is about evaluating the skills of the quiz taker about using Microsoft Excel 2007.
Questions: 122  Attempts: 1338  Last updated: Jan 24, 2013

Sample QuestionYou can have results of any database table into Excel Worksheet, and by one click you can refresh the results?
Have you ever worked on spreadsheet application or MS Excel? Do you know all the functions and formulas? If yes, then take this quiz to test where do you stand and learn new formulas and functions used in excel. Microsoft Excel...
Questions: 10  Attempts: 1138  Last updated: Jun 7, 2019

Sample QuestionAll formulas in Excel begin with the following symbol
Microsoft Excel is a spreadsheet software which was developed by Microsoft.
To become an expert one needs to master the basic formulas and functions used in the excel spreadsheet. MS Excel is mostly used for data...
Questions: 20  Attempts: 1122  Last updated: Jun 23, 2019

Sample QuestionA function must always start with
This quiz covers beginning terms and knowledge of Excel as well as basic chart information. Let's start this quiz now!
Questions: 15  Attempts: 1090  Last updated: May 10, 2017

Sample QuestionWhich of the following definitions go with Block of Cells?
The purpose of this PreTest is to evaluate the current knowledge of Excel by the student.
Questions: 10  Attempts: 1004  Last updated: Jan 2, 2013

Sample QuestionData can be copied from one cell to another cell. To move information from one cell to another, you can: (1) Select the data from one cell; choose Edit (on pull down menu), Cut; select the new cell; and choose Edit, Paste; (2) Select the data from one cell; click on the Cut button; select the new cell; click on the Paste button; (3) Select the data from one cell and and drag using your mouse to the new cell.