What does the following MS Excel formula do? =SUM(Sheet1:Sheet4!D18)

PYQ UGC NET 2023

What does the following MS Excel formula do? =SUM(Sheet1:Sheet4!D18)

  1. A.

    It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4

  2. B.

    It adds data from cell D18 of Sheet1 and cell D18 of Sheet4

  3. C.

    It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4

  4. D.

    It adds data from cell A1 of Sheet1 and cell D18 of Sheet4

Attempted by 8 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…