FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this?

A	Conditional Formatting
B	Page Layout
C	Quick Format
D	Cell Alignment

Explanation:

Detailed explanation-1: -Firstly, you should select the data up to which you want to apply the Conditional Formatting to color the status Pass/Fail. Here, I have selected the data range D5:D15. Secondly, from the Home tab » you must go to the Conditional Formatting command. Thirdly, you need to choose the New Rule option to apply the formula.

Detailed explanation-2: -IF function is also known as logical tests because it is used to test a logical condition. It allows you to perform the comparisons between two values and returns results in one value, either TRUE or FALSE. For example, if you want to pass the exam, then score marks above 60. =IF(marks>60, "Pass", "Fail").

Detailed explanation-3: -The color light red with hexadecimal color code #ffcccb is a very light shade of red. In the RGB color model #ffcccb is comprised of 100% red, 80% green and 79.61% blue.

There is 1 question to complete.