Page 16 of 28PREVNEXT

Audio course: So that's how! Great Excel features

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


How do you select numbers to add up that are scattered in different rows or columns?

Press and hold down CTRL while you select each number.

Press and hold down SHIFT while you select each number.

Press and hold down CTRL+SHIFT while you select each number.

How do you change the result from Sum to Average?

Click Validation on the Data menu.

Right-click the status bar.

Click Formula Auditing on the Tools menu.

As you learned in the practice, if you do not see the sum in the status bar, click Status Bar on the _____ menu to turn the feature on.

Edit

Tools

View

Page 16 of 28PREVNEXT