Classes | Practice Tests / Quizzes | User Guide | Life Manuals

28.5K quizzes covering K–12, CBSE, SAT, ACT, GRE, UPSC, SSC, Banking, Reasoning & more.

Microsoft Excel
| Take A Quiz

If Statement: In Cell G2 - Create A Formula That Will Place The Word "Yes" If Cell F2 (Quantity In Stock) Is Less Than 25% Of H2 (Quantity In Reorder) Or "No" If This Condition Is Not Met

🎲 Try a Random Question | Total Questions in Quiz: 55 | 🧠 Study this quiz with Flashcards

This question is part of a full practice quiz:

Prove It - Microsoft Excel Test — practice the complete quiz, review flashcards, or try a random question.

🧠 Flashcards (fast review) 🧪 Practice Quiz ⚔️ Challenge a Friend 🥊 📊 View Stats

1. If Statement: In Cell G2 - Create A Formula That Will Place The Word "Yes" If Cell F2 (Quantity In Stock) Is Less Than 25% Of H2 (Quantity In Reorder) Or "No" If This Condition Is Not Met

Click The Design Tab. Click The More Arrow In The Chart Styles Section. Click Style 8.
Click The Task Name Drop-down Arrow. Click The Vacation Checkbox. Click The Ok Button.
Click The Data Tab - Then Click The Text To Columns Button. Click The Next Button. Uncheck The Tab Checkbox. Click The Other Checkbox - Then Type ":" Into The Other Field. Click The Next Button. Click The Finish Button.
Click The Formulas Tab - Click The Insert Function Button. Click If In The Function List - Then Click The Ok Button. Type "F2<(.25*h2)" In The Logical_test Field. Click The Value_if_true Field And Type "Yes". Click The Value_if_false Field And Type "No". Click The Ok Button.

Welcome to Fatskills

Join 4M+ learners. Unlock unlimited quizzes, wrong-answer tracking, flashcards + reminders, study guides, and 1-on-1 challenges.

Create a free account Sign in

900+ exams • Millions of questions • No spam

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈 Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

If Statement: In Cell G2 - Create A Formula That Will Place The Word "Yes" If Cell F2 (Quantity In Stock) Is Less Than 25% Of H2 (Quantity In Reorder) Or "No" If This Condition Is Not Met

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know? Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com