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