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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
To add a row of cells quickly click on the located in the Function Library group?
Insert | Insert Sheet Rows
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.
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.
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 :)
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)
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 grow if you do not add new muscle cells?
probably by adding fat cells.
Can you add up to 8 different conditions to a cell or a range of cells in excel?
you can add too many conditions to a cell or a range of cells in excell
What does an increase in red blood cells mean?
To add more blood to your body cells.
