Question

Q13. Select the correct reference of linking cells D4:D20 of Sheet1 to get the sum of the selected range in cells A1 of sheet 2: *

=SUM(D4:D20.Sheet1)

=SUM(Sheet1!D4:D20)

=sum(Sheet1,D4:D20)

=SUM(D4:D20 of Sheet1)

​

Answer 1

Answer:

Create a link to or Sum a cell in all worksheets (worksheet functions). Create a ... If you only have a few sheets you can do this: ... The formula in row 1 link to cell A1 in the sheet Sheet1

Answer 2

Answer:

= SUM ( $ Sheet 1. D2:D20 )

In my book this is written as answer

I think option a seems similar to my answer !!