Consider the spreadsheet given below: A B C 1 Project Number of Days 2 A 15 3…

PYQ UGC NET 2022

Consider the spreadsheet given below:

A

B

C

1

Project

Number of Days

2

A

15

3

A

20

4

B

30

5

A

10

6

B

10

7

A

5

What is the output of the following formula in Cell C1?

= SUMIF (A2 : A7, "A", B2 : B7)
  1. A.

    90

  2. B.

    80

  3. C.

    50

  4. D.

    20

Attempted by 4 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…