• Which rule would highlight all cells greater than 100 in a selected range?
    A. Highlight Cells Rules → Greater Than → 100
    B. Highlight Cells Rules → Equal To → 100
    C. Data Bars → Red Fill
    D. Top/Bottom Rules → Top 10 Items

  • Which formula returns “Pass” if cell A1 is greater than or equal to 50, otherwise “Fail”?
    A. =IF(A1>50,"Pass","Fail")
    B. =IF(A1>=50,"Pass","Fail")
    C. =IF(A1<50,"Pass","Fail")
    D. =IF(A1=50,"Pass","Fail")

  • Which Excel function calculates the future value of an investment based on constant payments and interest?
    A. NPV
    B. IRR
    C. FV
    D. RATE

  • What will =ROUND(123.4567,2) return?
    A. 123.45
    B. 123.46
    C. 123.00
    D. 124.00

  • How can you restrict a cell to only accept dates after today?
    A. Validation type: Text, formula: =TODAY()+1
    B. Validation type: List, source: TODAY()+1
    C. Validation type: Date, criteria: Greater than =TODAY()
    D. Validation type: Number, greater than =TODAY()

  • What is the first step to create a Pivot Table from a data range?
    A. Insert a chart
    B. Go to Home tab → Format Table
    C. Go to Insert tab → Pivot Table
    D. Apply Conditional Formatting

  • What does the formula =IF(A1>90,"A",IF(A1>80,"B","C")) return if A1 = 85?
    A. A
    B. B
    C. C
    D. Error

  • Which method will sort a data range from largest to smallest based on a selected column?
    A. Data tab → Filter
    B. Data tab → Sort A to Z
    C. Home tab → Sort & Filter
    D. Data tab → Sort Z to A

  • How do you apply a filter to show only rows where the value in Column B is “Completed”?
    A. Use Conditional Formatting with “Completed”
    B. Use the Sort function
    C. Use Filter → Select only “Completed” from the dropdown
    D. Use a Pivot Table

  • What happens when you apply an icon set (e.g., traffic lights) to a numeric range?
    A. It colors each value with a random icon
    B. It hides all values
    C. It replaces numbers with symbols only
    D. It visually indicates the relative value of numbers

Download Answers