answersLogoWhite

0

A function can reference cells or named ranges in the function.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

Is lookup and reference an excel function category?

Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.


How to reference an Excel sheet in a formula or function?

To reference an Excel sheet in a formula or function, you can use the sheet name followed by an exclamation mark (!) before the cell reference. For example, to reference cell A1 in a sheet named "Sheet1", you would write "Sheet1!A1" in the formula.


Does excel allow you to cycle through the different reference types using he function 2 key?

You use the F4 key to cycle through the different reference types in Excel.


What is the function of reference bar in micro soft excel?

muffins. its all about the muffins son


What does the ROW function do in Excel?

It gives you the row part of a cell reference. =ROW(D3) This will give the value 3, as that is the row part of the cell reference.


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 does excel display in an invalid reference?

If there is an invalid cell reference you will see #REF! in the cell. If you refer to a defined range name that does not exist or a function name that does not exist you will see the #NAME! error.


What reference of Excel is an example of B1?

B1 is a relative reference.


What is a revised reference in excel?

m


What type of cell reference is B12 in Excel?

B12 is a relative reference.


What is an Excel reference function that looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify?

hlookup