> > >

Excel MCQs

Let's say you have a large sheet of expenses and want to highlight those that are higher than 100 or less than 5. How would you do this?

Select the cells and bring up the Format Cells dialog box. Create a custom style.

Select all the cells and create a conditional format for cells greater than 100, and another conditional format for cells less than 5.

Select all the cells and create a conditional format for cells between 5 and 100.

Select all the cells and create a conditional format using the Exceptions rule. Enter 100 and 5.

Answer

Correct Answer: Select all the cells and create a conditional format for cells greater than 100, and another conditional format for cells less than 5.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it