Still overwhelmed by exam stress? You've come to the right place!

We know exam season has you totally swamped. To support your studies, access Gold Membership for FREE until December 31, 2025! Normally £29.99/month. Just Log In to activate – no strings attached.

Let us help you ace your exams efficiently!

Questions
Questions

BUSI_V 335 972 2025SS Extra practice - Excel Basics (ungraded)

Multiple choice

A university is evaluating student grades using an Excel spreadsheet. In column G it would like to indicate "Y" for those whose final grade is 50 and above, and "N" otherwise. What is the correct formula it should enter in cell G3? Choose all correct answers.  

Options
A.=IF(F3<50,"N","Y")
B.=IF(F3>=50,"Y","N")
Question Image
View Explanation

View Explanation

Standard Answer
Please login to view
Approach Analysis
The question asks which formulas correctly put "Y" in G3 when the Final Grade in F3 is 50 or higher, and "N" otherwise. Option 1: =IF(F3<50,"N","Y"). This reads......Login to view full explanation

Log in for full answers

We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

Similar Questions

In this nested IF function example,  =IF(C4<1000,0,IF(C4<2000,2,1))*C$1 if the value in C4 is 1200, the result is...   

For this question only, instead of using a VLOOKUP function, you want to complete column E (cells E2:E21) using an IF function (or nested IF). The rules remain the same as in the previous question: ports coded 200-499 are in the Northern Region, and those coded 500-999 are in the Southern Region. Completing column E (cells E2:E21) using an IF function, or nested IF functions, instead of a VLOOKUP function is (choose the best answer below):

Review the following Excel formula and choose the correct statement:   =IF( A1 > 10, "High", IF( A1 > 5,  "Medium",  "Low") )   Spaces are added to the formula above to make the text easier to read and will not affect the result.

If the payment amount due is more than $100 and the number of days late is more than 4, account should say "Review", otherwise cell should be blank.Which IF statements are correct? Select all that are correct.

More Practical Tools for International Students

To make preparation and study season easier for more international students, we've decided to open up Gold Membership for a limited-time free trial until December 31, 2025!