In the previous blog, we practiced some basic questions on MS Excel formatting and filtering. In this blog, we will look at Excel conditional formatting practice questions.
if you want to practice more Excel questions, visit Excel Basics to Advanced Practice Questions.
New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.
Ques 1. Using the data set given in the previous blog, change the formatting of the values in the Profit column. Negative values should be displayed in red color and in parenthesis.
Output:
Figure1. Negative Profit values are displayed in red and in parenthesisQues 2. Using the list of numbers below, format them as phone numbers.
Figure2.List of numbersOutput: After tformatting the above numbers, your output should appear like the one shown below.
Figure3. List of numbers formatted as phone numbersQues 3. Use the list courses shown below, format them so that a bullet icon appear before them.
Figure4. List of CoursesOutput: After you have completed your changes, the output should appear like the one shown below
Figure5. Course names formatted in bulletsQues 4. Use the output of Ques 1 as the dataset for this question. Format the Sales values in such a way that Sales greater than 200 is highligted in green color and is double underline.
Output:
Figure6. Sales > 200 displayed in Green color and double underlinedQues 4. Use the same dataset as shown above. Highlighed Profit less than $10 in red color.
Output:
Figure7. Profit < $10 displayed in redQues 5. Insert two blank rows in the above data set. Create a conditonal formatting rule to highlight the blank rows in blue.
Output:
Figure8. Blank rows displayed in blueQues 6. Use the above dataset. Create a column on the far right to Input the Category values. Start with Category = Furniture. When Furniture is entered, all the rows in the dataset pertaining to Furniture should highlight in brown. When anyother value is entered for the Category, those rows should get hightlighted.
Output: When Category Furniture is entered for Input Category
Figure9. Furniture rows are highlightedOutput: When Category Office Supplies is entered for Input Category
Figure10. Office Supplies rows are highlightedFor a step-by-step approach to learning more advanced features and functions in Excel, take a look at the book Excel Basics to Advanced.
Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.
Explore more of his work on his Amazon Author Profile.
Post a Comment