answersLogoWhite

0

When worksheet cells are selected, a message displays on the status bar in the AutoCalculate box. AutoCalculate is not a substitute for writing worksheet formulas or functions. However, it is handy for making quick, temporary calculations that are not recorded on the worksheet. AutoCalculate can average, count, sum, and find the minimum or maximum number in a group of numbers. The default calculation is SUM. To use AutoCalculate, click and drag across the values you want to calculate. The sum of the values will display automatically on the status bar. To make a different type of calculation (for example, an average), right-click the AutoCalculate box on the status bar to display its shortcut menu. Choose the appropriate type of calculation.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the symbol for autosum?

The symbol for autosum in Excel is a Greek letter sigma (∑) located in the toolbar or ribbon at the top of the application. It is used to quickly add up a range of selected cells in a spreadsheet.


What value you will add to any organisation if selected?

If you are selected, your education and previous experience can add value to an organization.


To add a row of cells quickly click on the located in the Function Library group?

Insert | Insert Sheet Rows


Which option needs to be selected so that locked cells and objects cannot be changed?

Turn protection on. If you want to ensure nothing is changed, add a password.


Which excel feature will display the sum of all the selected cells?

Enter =sum(A1:A20) in the cell that you would like to display the sum, where A1:A20 is the range of cells you would like to add.


What is auto sum?

Autosum allows you to quickly add values in ranges of cells. If you have a column of numbers and put the cursor on the cell below them and click the Autosum, it will automatically add the cells above it by highlighting the range into the formula. If you try the same thing at the end of a row, it will add those.


How do you add two cells together on a spreadsheet?

To add two cells together in a spreadsheet, click on the cell where you want the result to appear. Then, type the formula =A1 + B1, replacing A1 and B1 with the actual cell references you want to sum. Press "Enter," and the sum will be displayed in the selected cell. You can also use the SUM function by typing =SUM(A1, B1) for the same result.


What is frequency in sports?

to add or to gain more time to your selected sport or activity.


How do you add 2 cells to a spreadsheet?

Click on Insert at the top of the page then click on add cells then choose how many you want :)


What value you will add to you are selected for this position?

i will work hard to provide a good service for the company


How do you quickly add all of the numeric data on a spreadsheet?

type '=SUM(enter the numeric data here)'. for example if you have numbers listed in cells A1-A10, you would type =SUM(A1:A10)


How do you grow if you do not add new muscle cells?

probably by adding fat cells.