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)
Answers
Answered by
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
Answered by
0
Answer:
= SUM ( $ Sheet 1. D2:D20 )
In my book this is written as answer
I think option a seems similar to my answer !!
Similar questions