Monthly revenues of 2019 are entered in B2:M2, as shown below, To get year-to-date running total revenues, what formula should you enter in B3 and autofill through M3?

  • =SUMIF($B$2:$M$2,”COLUMN($B$2:$M$2)<=COLUMN())”)
  • =SUM($B2:B2)
  • =SUM(OFFSET($A1,0,0,1,COLUMN()))
  • =B2+B3

The correct answer is:

  • =SUM($B2:B2)

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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock