answersLogoWhite

0

How is a cell reference used?

User Avatar

Anonymous

15y ago
Updated: 8/18/2019

It is used any time you want to identify a cell.

EXAMPLE: =SUM(A1:A12); finds the sum for cells A1 through A12

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What type of cell reference is used in a formula will be adjusted appropriately when the formula is copied to another cell?

A relative reference.


What is E23 in called in excel?

E23 can be a cell reference, referring to the 23rd cell in column E. E23, or any cell reference, can be used in formulas.


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 an example of an absolute cell reference?

Relative cell reference: A2 Absolute cell reference: $A$2


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 the dollar sign called when put in between cell numbers in a spreadsheet?

The sign itself is still referred to as a dollar, but it changes a cell reference from being a relative reference to being either a mixed reference, if one dollar is used, or an absolute reference if two dollars are used.


What is cell reference box?

A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.


What function key will change a cell reference formula value to an absolute value in Excel 2010?

The F4 key can be used as you are typing in the cell reference in order to change it to a different reference type.


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 C14?

It is a relative cell reference.