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.
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.
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.
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.
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.
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.
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:
