400+ multiple choice questions from Microsoft Excel.
Welcome to Online MS Excel MCQ Quiz sessions. I’ve collected and composed more than 400 multiple choice questions from Microsoft Excel for you to practice and test yourself. I believe the posts in this series are helpful to drill and prepare your exam.
I’ve paid an utmost care to compose and present these questions making sure they are free from errors and mistakes. However, if you encounter any glitches in any of these MS Excel MCQ questions, please copy the question and paste it in the comment section below. Because the questions are presented randomly from the bank, simply the numbers will not help me to identify it among the 400 MCQ questions in the bank.
Enjoy MS Excel MCQ quiz set 1!
Microsoft Excel MCQ Quiz – Set 01
Related to Excel Test Multiple Choice, Multiple Choice Test Template Excel, Free Multiple Choice Test
Some Interesting Tasks with MS Excel
Completed the first set of MS Excel MCQ Quiz? Before we move on to second quiz page, let’s learn a few interesting tasks that you can do with Excel. Let’s have some fun!
#1. Colorful Sheet Tabs
Excel file is composed of worksheets and there is a tab at the bottom so that you can switch among the different tabs in your workbook. Do you know you can color those sheet tabs!
Coloring sheet tabs will help you to visually organize the sheets, like same color for sheets of same category; or you can do priority coloring, like green for sheets that are not yet complete, yellow for sheets that are complete but some editing and auditing is required and red color for the sheets that are finalized!
Isn’t it interesting?
How to color sheets?
It’s very easy. Right click on sheet tab and choose your preferred color form the ‘Tab color’ menu!
This MS Excel MCQ Quiz is presented in mcqsets.com
#2. Delete all formatting with one click!
Excel worksheet contain many formats. You can apply different font, size, color, border, pattern, column width, row height and many others. However, the good thing about them is that, it’s really easy to remove all the formatting. It all requires is one click!
But where to click to remove all the formatting of selected range?
Click on ‘Clear All’ menu which you can find in Home tab >> Editing group.
#3. Get the sum with one click!
Microsoft Excel has Autosum button. You can find it at Home >> Editing group. Select the cells you need to sum then click on Autosum button.
It is also interesting to know how Autosum button behaves depending upon your selection. If you place the cell pointer at the end of your column, it will add the numbers on that column. If the cell pointer is at the end of a row, it will add up the numbers in that row. If you select a row of numbers, it will place the sum on the next cell of that row. Similarly, if you select a column of numbers, it presents the sum of those numbers on next cell in that column.
Now find what Autosum will do if you select a rectangular area of numbers, such as B5:#15? Find out and comment below.
MCQ Sets presented the online mcq quiz from Microsoft Excel
Interesting Facts about Microsoft Excel
#1. Zoom range is from 10 percent to 400 percent
#2. Each worksheet holds 1,048,576 rows
#3. Each worksheet holds 16, 384 columns
#4. You can have up to 255 data series in one chart
#5. You can undo the last 100 actions
#6. You can select 2,147,483,648 cells that are not touching
#7. You can have up to 255 arguments in a function
#8. You can nest 64 levels of functions per formula
#9. There are 1,024 global fonts available to use, 512 per worksheet
#10. You can highlight 32,767 cells per worksheet
You can find MS Excel MCQ Quiz at mcqsets.com
Surya Prakash Acharya says
Dear Sr, Namaskar!
17. To center worksheet titles across a range of cell, you must
Select the cells containing the title text and use the fill handle to center the text across a range of cells
Widen the columns
Select the cells containing the title text and use the fill handle to center the text across a range of cells
Widen the column
in this question we can not display any correct answer,
Which is correct answer….. ?
plz helps for us who loves MCQ Sets n also flow this website.
sajjan bhurtyal says
in above question 1st and 3rd the options are same…2nd and 4th are also same….there is no correct answer for the questions…the correct answer would be selecting the cells that contain the worksheet title and from home tab- alignment group- merge and center button…….
sajjan bhurtyal says
Which of the following is not true about Find and Replace in Excel
• You can search for bold and replace with italics
• You can decide whether to look for the whole word or not
• You can search in formula too
• You can search by rows or columns or sheets
the answer shows d.
but I think option b. is correct…there is no options in find dialog box to look for whole word or not…but we can see all other options except option b.
Mahesh Paudel says
Sajjan bro, I agree with you. Your opinion is true. There is no option to decide whether to look for the whole word or not in Find and Replace dialog box.
Aparichit Mitra Adhikari says
11. The autofill feature
Extends a sequential series of data
Automatically adds a range of cell values
Applies a boarder around selected cells
None of above
in one set ans is a and in another set ans is d which is correct
janak dhami says
I think option A is correct answer