0
It is a relative reference to the cell in column C and row 10.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Which key do you press to convert a related cell reference to an absolute cell reference?
As you are typing in the actual cell reference, press the F4 key and it will change it between the 4 available settings. So if your cell is C10, when you press F4 immediately after typing it, it will become: $C$10 then C$10 then $C10 and then back to C10. When you have it the way you want it, continue typing your formula or just press return if the formula is finished.
How do you connect two value in spreadsheet so that change in one leads to automatically change to other?
You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10
What is the cell reference for the nonadjacent block of cells B5 through C10?
The range for cells B10 through to C15 is B10:C15
E23 is a cell reference or cell listing?
cell reference
How would jade write the cell in row 6 of column a?
A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.
What is made up by the column letter and the row number?
A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.A cell reference or a cell address.
What is an example of an absolute cell reference?
Relative cell reference: A2 Absolute cell reference: $A$2
What is the cell address of the last cell of the Microsoft Excel 2003?
The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.
What do you use cell reference for?
Cell reference is loosely the cell you will be getting information from
What type of cell reference is this A1?
It is a relative cell reference.
What type of cell reference is A1?
It is a relative cell reference.
What type of cell reference C19?
It is a relative cell reference.
