Which sequence of steps would you use to enter a formula that averages B2:B6?

Which sequence of steps would you use to enter a formula that averages B2:B6?

• A. Formulas tab, function library, autosum, average.
• B. Home tab, editing group, autosum button arrow, average, enter.
• C. Review tab, new comment.
• D. Data tab, sort, average.

Answer: (B)

Using the AutoSum drop-down to insert an Average is the quickest way to create a formula that averages a range. In the Home tab, within the Editing group, click the AutoSum button’s arrow and choose Average. Excel will place =AVERAGE(B2:B6) in the active cell; you can adjust the range by selecting B2:B6, then press Enter to complete. This path is faster and more direct for this purpose than using tabs that don’t provide a quick formula option or that lead you to unrelated features.

Using the AutoSum drop-down to insert an Average is the quickest way to create a formula that averages a range. In the Home tab, within the Editing group, click the AutoSum button’s arrow and choose Average. Excel will place =AVERAGE(B2:B6) in the active cell; you can adjust the range by selecting B2:B6, then press Enter to complete. This path is faster and more direct for this purpose than using tabs that don’t provide a quick formula option or that lead you to unrelated features.