Testpoint Whatsapp group Testpoint Whatsapp group
Sticky Note
IF function used in Excel for _____?
اف فنکشن ایکسل میں کس لیے استعمال ہوتا ہے؟
  1. Performing logical comparisons
  2. Formatting text
  3. Creating charts
  4. None of these
Explanation
  • The IF function checks a condition and returns different values based on TRUE or FALSE.
  • Example: =IF(A1>50, "Pass", "Fail") (Returns "Pass" if A1 is greater than 50, otherwise "Fail").

    • Related MCQs

    Which Excel function is used to add the current system date?
    1. DATE()
    2. NOW()
    3. TODAY()
    4. CURRENT_DATE()
    اس سوال کو وضاحت کے ساتھ پڑھیں
    What would you do to delete a record in MS Excel?
    1. Select Data > Open data from dialog box to find the record and click the delete button
    2. Select Data > Delete record from the menu
    3. Delete Column from the work sheet
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    "Edit, Clear" Command does not include___function?
    1. Delete notes
    2. Delete formats
    3. Delete cells
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Function key to go to a specific cell in MS Excel is:
    1. F4
    2. F5
    3. F6
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Which Excel feature allows you to display only specific data based on a condition?
    ایکسل کی کون سی خصوصیت آپ کو شرط کی بنیاد پر صرف مخصوص ڈیٹا دکھانے کی اجازت دیتی ہے؟
    1. Grouping
    2. Sorting
    3. Filtering
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Test Point Whatsapp Channel

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    1 + 2 = ?



    All Rights Reserved © TestPoint.pk