Suggested Topics
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
Top Trending Quizzes
Office 2007 Ribbon Quiz
How Much Do You Know About Microsoft Office 2007?
Test Your Knowledge About Getting Started With Office XP! Trivia Quiz
Microsoft Office Quiz
MS Office Shortcuts Quiz
MS Office
Trivia Questions On Microsoft Office
Microsoft Office Test
MS Office / Computer Operator
The Ultimate MS Office Online Test!
Office 2007 Ribbon Quiz
How Much Do You Know About Microsoft Office 2007?
Test Your Knowledge About Getting Started With Office XP! Trivia Quiz
Microsoft Office Quiz
MS Office Shortcuts Quiz
MS Office
Trivia Questions On Microsoft Office
Microsoft Office Test
MS Office / Computer Operator
The Ultimate MS Office Online Test!
Online MCQ Quiz on Microsoft Excel  Set 2
No. of Questions: 10
Time: 10 Minutes
Full Mark: 100
Pass Mark: 70
This Quiz if for those user who wants...
Questions: 10  Attempts: 16022

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

Sample QuestionWhich language is used to create macros in Excel?
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

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

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

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

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

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

Sample QuestionTRUE OR FALSE: Number formats affect how numbers look onscreen and when printed.
Â Â Â Â Â Â Â Â Â Â MULTIPLE CHOICE QUESTIONSÂ AND TRUE/FALSEÂ Â Â Â Â Â Â Â Â Â Â Â Put your answers to the left of the numberaNS
Questions: 20  Attempts: 2371

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

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

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

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

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

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

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

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

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

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

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

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

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.
Microsoft Excel often called as MS Excel, is a spreadsheet application which is used for data processing and financial presentation. Do you really know all the functions and formulas of excel? Are you an expert? To become an...
Questions: 28  Attempts: 998

Sample QuestionThe Name Box shows you the contents of the active cell.
Choose one answer best for your knowledge.
(Pilih satu jawapan mengikut kefahaman awal anda)
Questions: 11  Attempts: 976

Sample QuestionData Validation will make your entering data process more accurate, more faster and uniform. (Data Validation menyebabkan kerja kemasukan data lebih tepat, lebih cepat dan seragam)
DIRECTIONS:The following questions will assess your `knowledge of internet usage and MS Excel basic functions. This quiz is intended to test your current knowledge, therefore, the goal is not to get as many questions right...
Questions: 5  Attempts: 908

Sample QuestionThe following questions will ask you to perform tasks on the computer you are using.If you are able to complete the task, complete it and choose "I have completed the task" from the choices below.If you are unable to complete the task, choose "I want to skip this question" from the choices below.TASK:Please perform the following steps in MS Excel: 1. Open a new spreadsheet and recreate the table shown above. 2. Add today's date at the top of the table. Change the date to another format using an option from the Format menu. 3. Sort the Widgets column from highest to lowest. 4. At the end of the table, create a new row for a widget total and label it accordingly. 5. Use the Sum function to total the number of widgets and place it in the appropriate column 6. Create a new row for a widget average and label it accordingly. 7. Use the Average function to calculate the widget average and place it in the appropriate column 8. Save the spreadsheet to the desktop as "yourNameTable" where yourName is your first name (ex. SharonTable)
This test can be used as a pretest assessment of student knowledge or as a postlesson test for student comprehension. If you need a refresher before beginning this quiz, go to:...
Questions: 7  Attempts: 907

Sample QuestionIn order to save a new document in Microsoft Excel you must select which one of the following tool bar options?
Choose one answer best for your knowledge.
(Pilih satu jawapan mengikut kefahaman awal anda)
Questions: 11  Attempts: 848

Sample QuestionData Validation will make entering data process more accurate, more faster and uniform. (Data Validation menyebabkan proses kemasukan data lebih tepat, lebih cepat dan seragam)
Provide review of basic excel facts. Identify parts of excel screen.
Questions: 4  Attempts: 793

Sample QuestionA document inside excel is called a
Find the best answer
Questions: 13  Attempts: 750

Sample QuestionDefault extension files for Excel 2007/2010 is
Microsoft Excel is a spreadsheet program used for calculations, making charts and recording data about all sorts of business processes. Most companies wish for their staff to have adequate knowledge on how to use this...
Questions: 15  Attempts: 745

Sample QuestionA fast way to add up this column of numbers is to click in the cell below the numbers and then:
15 question quiz to test basic knowledge of Excel 2003
Questions: 15  Attempts: 722

Sample QuestionWhich option allows you to delete a spreadsheet from a workbook