microsoft.excel.courses.in.london - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Excel

microsoft.excel.courses.in.london - Excel

resolvedResolved · Low Priority · Version Standard

Michelle has attended:
Excel Introduction course

Excel

What is Autocalculate?

RE: Excel

Hi Michelle

Thank you for your question.

AutoCalculate refers to a feature you will find in the status bar (grey bar) at the bottom of the Excel screen.

What it does is that if you select a range of cells that contain numbers, it will, by default, tell you what the sum (total) of the selected cells is. It will say SUM= followed by the total.

You can right-click on where you see SUM= and choose a different function to display, for example, AVERAGE, which will then display the average of the selected cells.

Amanda


Server loaded in 0.08 secs.