0
E2 and G4 in the formula are both relative references.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What type of cell reference is equals E2 plus C3-G4?
All 3 cells are relative references.
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.
What type of cell reference is C14?
It is a relative cell reference.
What type of cell reference is D5?
It is a relative cell reference.
What type of cell reference is N29?
It is a relative reference.
What allows you to select cells for use in a formula by using a mouse?
You can click and drag from one cell along a row, down a column, or to the opposite corner of a rectangle to select with a mouse. When doing a formula you can select cells in that way after you start typing a formula. So to add all the values in the cells from A2 to A15, you could type: =SUM( Then you could either type the cell range, or select the range with the mouse. The completed formula would be as follows no matter which way you do it: =SUM(A2:A15)
What type of cells reference is C19?
It is a relative cell reference.
What type of cell reference is B12 in Excel?
B12 is a relative reference.
Where do you type a cell reference and then move directly to that cell in Excel?
The Name Box. If you type in a cell reference in the Name Box, and press Enter, it will bring you to that cell. You can also press F5 to open the Goto dialog box and use that to go to a particular cell too.
What type of cell reference is required if a formula containing a cell reference requires that the referenced cell remain the same even if the formula is moved to another cell position?
An absolute reference.
