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
Get step-by-step solutions from verified subject matter experts
