MS Excel Practice Questions

In this series of blogs, we will post MS Excel Practice Questions. These questions will be helpful for the candidates who have attended our MS Excel training as well as others who wish to learn and practice.

This first section covers the overview of MS Excel and contains basic concepts, in the subsequent blogs we will be covering more advanced techniques. Explore more by practicing questions on Conditional formatting in excel.

Ques1. Create the following sheet in MS Excel. Format the sheet exactly the way shown below.

excel problems for practice
Figure1. Sample Excel Sheet

Ques 2. What is the address (Row/Column) of Product ID = 4, Sub-Category = Chairs

Ques 3. How can we see the data only for Category = Furniture. See the screen shot below for the output.

Figure2. Data for Category = Furniture

Ques 4. Refer to the data in screen shot Figure1. Sort Sub-Category from in alphabetical order. Refer to the screen shot below for the output.

excel problems for practice
Figure3. Data output when Sub-Category is ordered Alphabetically

Ques 5. What option you will choose to search Chairs in the entire data set.

Ques 6. Create an exact copy of the worksheet you are working on. Mention the steps/options you will take to achieve this.

Ques 7. Create a heading above the dataset, the way it is shown in the screenshot below.

excel problems for practice
Figure4. Data with Product Details header on Top

Ques 8. Do not display the Discount column in the data shown above in Figure4. Make sure not to delete it. Refer to the screen shot below for the output.

Figure5. Data without displaying the Discount column

Ques 9. In the above sheet, on any empty cell enter a word – MS Excel. Link it to the url https://en.wikipedia.org/wiki/Microsoft_Excel. Refer to the screen shot below.

excel problems for practice

Click here to look for questions on Conditional formatting in excel.

For a step-by-step approach to learning more advanced features in Excel, take a look at the book Excel Basics to Advanced.

Feel free to post your comments in the comment section of this blog.


About the Author

Chandraish Sinha has  20+ years of experience in Information Technology. He is an accomplished author and has published 11 books covering Business Intelligence related topics such as, Tableau,Power BI, and Qlik. Checkout his Amazon Author profile.

His latest book Excel Basics to Advanced covers all the aspects of MS Excel and provides exercises for self-learning.

Similarly, his recent book, Dashboarding with Tableau, covers all the features in Tableau and includes exercises for self-learning.

He has implemented IT solutions in different domains viz. Pharmaceutical, Healthcare, Telecom, Financial and Retail.

He blogs regularly on various IT topics. Check them out in the links given below: 

Blogs

Learn Tableau

Learn All Bi

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.