asked 206k views
4 votes
Svieta is making a chart of the hours that different employees have put into a team project at work. What formula would AutoSum most likely generate if added into B8? =SUM(B2:B7) =(B2:B7) =SUM(B2+B7) =(B2+B7)

1 Answer

6 votes

Answer:

Its =SUM(B2:B7)

The worksheet range B2:B7 means B2, B3, B3, B4.....,B7.

And for finding the sum of all these cells we need to make use of the SUM, but we need to place the = sign at first, and then all aggregate function will be listed in dropdown, and then we need to pick the SUM from there, and mention the worksheet range as above to define the cells which we want to include in the formula.

Step-by-step explanation:

The answer does not require any further explanation.

answered
User Shawn Mclean
by
7.5k points