课程: Excel 2016: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

Using autocalculate in the status bar

Using autocalculate in the status bar

课程: Excel 2016: Advanced Formulas and Functions

开始一个月试用 购买团队方案

Using autocalculate in the status bar

“

- At the bottom of the Excel screen, just below the Sheet names, is an area called the Status bar, and it has a valuable tool in it called Auto Calculate. At the moment we're seeing nothing here. Now, I'm highlighting some cells. If I highlight two or more cells with values, we see a number of totals down here. Now, if you're using this on your computer right now, if you happen to not see as many of the entries as I'm seeing right now, there's six different ones, you can right-click down there, and in this section right here, where I'm scrolling up and down, you'll see Average, Count, Numerical Count, Minimum, Maximum, Sum. You can uncheck these if you wish. If I uncheck Count, that's no longer visible in the Status bar, Numerical Count. On the other hand, those might come in handy. But any time we highlight two or more cells, we get those totals down there, and that can be used for a variety of different reasons. On a different worksheet here, to the left, maybe I simply want to know…

内容