asked 91.9k views
3 votes
14. Copy the formula in cell N8 to the range N9:N16, pasting the formula only, and then edit the copied formulas to return the value from the column indicated by the label in column M.

1 Answer

7 votes

Final answer:

The question involves copying a formula in a spreadsheet from cell N8 to cells N9:N16 and adjusting references according to labels in column M.

Step-by-step explanation:

The student is asking how to copy a formula from one cell to a range of cells, specifically from cell N8 to cells N9:N16, with the requirement that the copied formulas need to refer to a column indicated by labels in column M. This process involves two steps: first, using the copy-paste special feature to only paste the formula, and second, editing the copied formulas to reference the correct column as indicated by the corresponding row in column M.

This can be typically done in spreadsheet software where you would use the copy and paste special functions to duplicate the formula and then manually adjust each pasted formula to ensure it references the correct column data. The process teaches the concepts of relative and absolute cell referencing in spreadsheets.

answered
User Robin Berjon
by
7.6k points

Related questions

asked May 21, 2023 196k views
Dipen Gajjar asked May 21, 2023
by Dipen Gajjar
7.6k points
1 answer
1 vote
196k views
asked May 16, 2023 190k views
LongZheng asked May 16, 2023
by LongZheng
7.8k points
1 answer
1 vote
190k views
asked Jul 12, 2023 31.5k views
Lova Chittumuri asked Jul 12, 2023
by Lova Chittumuri
8.0k points
1 answer
4 votes
31.5k views