0
What is a predefined formula that adds all the numbers in a selected range?
Wiki User
∙ 11y ago
=SUM(range) or
=SUBTOTAL(9,range)
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
What is the formula to find out the Range of a series of numbers?
subtract the lowest number from the heigest
What two numbers with a range of 10?
What are two numbers with a range of 10
What is the range of y equals 8x-3?
11
What is a range in math terms?
The range of a group of numbers is the difference between the highest and lowest numbers
What happens when a selected range is next to numbers and the SUM button is clicked?
You will find the sum of the numbers.
Is it true If each cell in a selected range is next to a row of numbers Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked?
false
What is the Excel function that adds all the numbers in a selected range of cells is the?
Sum Function
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
What is the formula to find out the Range of a series of numbers?
subtract the lowest number from the heigest
What is the command in autocalculate area displays the highest value in the selected range?
I didn't know there was one; I always make a formula with the MAX() function.
What is the closed numbering scheme in communications?
In a closed numbering scheme,the range of numbers that can be assigned to the subscribers is predefined and cannot be changed. You cannot assign numbers at will and program them into the switching system. Wheras in open numbering scheme you can allot numbers on your own and program them into the switching facility. For eg Asterix Exchange.HOPE THIS HELPS!!
What command in the AutoCalculate area displays the highest value in the the selected range?
I didn't know there was one; I always make a formula with the MAX() function.
What is an Excel name box?
The name box shows the address of the current cell selected or the name of that cell if a special name has been given to it. It can also show the name of a range. You can type in a cell reference or a range name in the name box and it will bring you to that location. The name box appears to the left of the formula bar.
What function formula can you use to add the numbers in Excel in the range X1 to X10?
=SUM(X1:X10)
What is the formula for calculating maximum in Excel?
MAX. If you had a series of numbers in the range B1:B84 the following formula would show the largest of them: =MAX(B1:B84).
What is a selected group of cells?
Range
