0
=SUM(A1:A17)
for example
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
When might use the sum function in your schoolwork or workplace?
You use the sum function whenever you wish to total up a column or row of numbers.
What is the sum of the numbers in the 11Th row of Pascal's Triangle?
When evaluating row n+1 of Pascal's triangle, each number from row n is used twice: each number from row ncontributes to the two numbers diagonally below it, to its left and right. From this it is easily seen that the sum total of row n+1 is twice that of row n. The first row of Pascal's triangle, containing only the single '1', is considered to be row zero. Its total, 1, is given by 20. From the above observations, we can conclude that the total of row n is given by 2n. For the eleventh row: 211 = 2048.
What is function in spreadsheets?
Function can be used for calculations in a spreadsheet. A simple example of a function is for adding a column of numbers.EXAMPLE: You have a column of 23 numbers in column B, from row 1 to row 23. To add all of those numbers, and display the results in cell B24, enter =SUM(B1:B23) in cell B24.See related links for more Excel functions.
What is the formula for the sum of the numbers in the 100th row of Pascals triangle?
Each number in Pascal's triangle is used twice when calculating the row below. Consequently the row total doubles with each successive row. If the row containing a single '1' is row zero, then T = 2r where T is the sum of the numbers in row r. So for r=100 T = 2100 = 1267650600228229401496703205376
When using spreadsheet software a function does what?
Function can be used for calculations in a spreadsheet. A simple example of a function is for adding a column of numbers.EXAMPLE: You have a column of 23 numbers in column B, from row 1 to row 23. To add all of those numbers, and display the results in cell B24, enter =SUM(B1:B23) in cell B24.See related links for more Excel functions.
When does Excel assign the SUM function to cells next to numbers?
It you select the blank cell under a column of numbers or a blank cell at the end of a row of numbers and hit the Autosum button it will enter the SUM function and select the cells above in the column, or to the left in a row. Pressing Alt and the = key will also do the same thing. If you select the column or the row with the numbers and click the button or do Alt and the = key, then it will also do the same.
How do you arrange the numbers 1-9 on a grid so that each row column and diagonal total 15?
top row 8,1,6 2nd row3,5,7 3rd row 4,9,2
Try to put the numbers 1 to 7 in the seven diamonds below so that the numbers in each row of three diamonds add up to 10 with only each number only being used once?
First Row 7,6 Second row 4,1,5 Third row 3,2
What are the numbers to the left of every row in a spreadsheet called?
The numbers start with one and increase for each subsequent row.
How many odd numbers are there in the 100th row of pascal's triangle?
If you consider row 0 as the row consisting of the single 1, then row 100 has 6 odd numbers.
What is the total numbers of valence electrons in IBr?
I (if you count the rows) is at the 7th row, so it has 7 valence electrons. The is the same for Br, so there is a total of 14 electrons. :)
What is row numbers?
3
