• Which statement best describes the purpose of Goal Seek in Excel?
    A. It changes multiple cells to solve equations
    B. It deletes formulas and replaces them with values
    C. It adjusts one input cell until a formula reaches a target result
    D. It creates Pivot Tables automatically

  • Which formula correctly counts the number of numeric values in a range A1:A10?
    A. =COUNT(A1:A10)
    B. =COUNTA(A1:A10)
    C. =SUM(A1:A10)
    D. =COUNTIF(A1:A10,"Text")

  • Which formula-based rule highlights all rows where Column A > 100 and Column B = "Yes"?
    A. =$A1>100
    B. =$B1="Yes"
    C. =AND($A1>100,$B1="Yes")
    D. =OR($A1>100,$B1="Yes")

  • What is the main use of the Name Manager in Excel?
    A. To rename worksheets
    B. To format tables
    C. To store and manage named ranges and formulas
    D. To create Pivot Charts

  • You enter a formula =SEQUENCE(5) in cell A1, but Excel shows a #SPILL! error. What is the most likely cause, and how can you fix it?

    A. Excel version is outdated → Update to Excel 365 to support dynamic arrays
    B. There are values blocking the spill range → Clear the cells below A1
    C. The formula syntax is wrong → Rewrite as =SEQUENCE(1,5)
    D. SEQUENCE requires manual array entry (Ctrl+Shift+Enter) → Use CSE instead

  • Which function returns the number of payment periods for a loan or investment?
    A. NPER
    B. RATE
    C. PMT
    D. PV

  • Which formula counts how many values in A1:A10 are greater than 50?
    A. =COUNT(A1:A10>50)
    B. =SUM(IF(A1:A10>50,1,0))
    C. =IF(A1:A10>50)
    D. =SUMPRODUCT(A1:A10<50)

  • Which formula correctly checks if A1 is at least 50 and B1 contains "Pass", returning "Qualified" if true, otherwise "Not Qualified"?
    A. =IF(AND(A1>=50,B1="Pass"),"Qualified","Not Qualified")
    B. =IF(A1>=50 AND B1="Pass","Qualified","Not Qualified")
    C. =IF(OR(A1>=50,B1="Pass"),"Qualified","Not Qualified")
    D. =IF(A1=50,B1="Pass","Qualified")

  • Which rule highlights every other row in a table for zebra striping?
    A. =A1>0
    B. =MOD(ROW(),2)=0
    C. =ISBLANK(A1)
    D. =LEN(A1)>5

  • To find the number of units sold needed to reach $50,000 in revenue (Revenue = Price × Quantity), which cell should Goal Seek adjust?
    A. The Revenue cell (output)
    B. The Quantity cell (input)
    C. The Price cell (fixed input)
    D. The formula itself

Download Answers