basic computer MCQ #1799

MS Excel will not be able to calculate which of the following formulas if 'Sales' is not a defined name or range?

basic computer MCQ #1799

  1. Question 1

    Q1. MS Excel will not be able to calculate which of the following formulas if 'Sales' is not a defined name or range?

    • A) SUM(Sales)-A3
    • B) SUM(A1:A5)*0.5
    • C) SUM(A1:A5)/(10+10)
    • D) SUM(A1:A5)-10

    Answer: SUM(Sales)-A3

    Explanation: If "Sales" is not a defined named range in the workbook, the formula SUM(Sales)-A3 will return a #NAME? error because Excel cannot resolve the undefined name.