Latest:
LinkedIn Microsoft Excel Certification 

What dows this formula do?

Editorial Staff

=SUM(Sheet1:Sheet4!D18)

  • It adds data form all D18 cells in Sheet1, Sheet2, Sheet3, Sheet4
  • It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
  • It adds alla data in the range A1:D18 in Sheet1,Shee2, Shee3, and Sheet4
  • It adds data from cell A1 of Sheet1 and cell D18 of Sheet4

The correct answer is:

  • It adds data form all D18 cells in Sheet1, Sheet2, Sheet3, Sheet4

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?

Editorial Staff 0

You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?

Editorial Staff 0

How can you drill down into a PivotTable to show details?

Editorial Staff 0