Answer:
=IF(D15<1500, "Discontinue", "No Change")
Explanation:
In an Excel environment, you should navigate to cell F15 and apply the IF function. The structure of the IF function is
IF(<condition>, <value if true>, <value if false>)
Your condition is placed before the first comma, which is D15 < 1500.
The second segment, located before the second comma, is the text to display when D15 is below 1500, which is "Discontinue".
Finally, the last part should show text if D15 is 1500 or higher, which is "No Change".
The complete formula can be expressed as =IF(D15<1500, "Discontinue", "No Change")
Answer:
1. The home tab
2. Font group
3. The small arrow at the bottom right of the font command group.
4. Under "Font" heading (then "All text" subheading)
Explanation:
This explanation will guide Su in completing her task.
1. Navigate to the home tab;
2. From the home tab, Su will access a variety of command groups, but for her needs, she requires the Font command group.
3. A tiny arrow can be found at the bottom left of the font command group section; clicking it will unveil the font dialogue.
4. Within the font dialogue, there are two headings. The "font" heading and the "character spacing" heading.
For her purposes, she must focus on the "Font" heading, which includes various subheadings. To reach the underline color option, she needs to select the "All text" subheading.
Refer to the attached image for guidance.