Latest:
LinkedIn Microsoft Excel Certification 

What does this formula do? =Sum(Sheet1:Sheet4!D18)

Editorial Staff
  • It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
  • It adds data from cell A1 of Sheet1 and cell D18 of sheet4
  • It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3, and Sheet4
  • It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and 4

The correct answer is:

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

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

You May Also Like

Based on the data in columns D,G,H, and K below, what formula will calculate the average compensation for full-time employees who have a job rating of 5?

Editorial Staff 0

How do you remove the background of an inserted image?

Editorial Staff 0

Excel’s default view contains the Quick Access Toolbar and the ribbon. Which can you customize?

Editorial Staff 0