Question: Ways to reference or 'parameterize' an Excel spreadsheet include the following techniques: Options: 1) When working with a formula where a piece of information is

Ways to reference or 'parameterize' an Excel spreadsheet include the following techniques:

Options:

1) When working with a formula where a piece of information is needed, simply clicking on the cell where the data resides, wherein Excel will then insert the row and column of the needed data

2) all of these answers are correct

3) When working in a formula where a piece of information is needed, one can type the row and column location of the needed data

4) Naming the piece of information for use anywhere in the spreadsheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!