what are the steps to calculate data across worksheet
Answers
Answered by
19
Answer:
- Select the cell where you would like the formula to appear, probably on a new “Summary Worksheet.”
- Enter the formula until you get to the point of entering a cell reference or range.
- Click the worksheet with the data you would like included, and select the cell or cell range that you would like to use.
- Enter the operator (+, -, /, *, etc.) that you would like to use.
- Click the next worksheet with the additional data you would like to use, and select the cell or cell range to be included.
- If desired, enter the operator (+, -, /, *, etc.) that you would like to use, and repeat this process until you are done, and end your formula with a closing parenthesis.
- Press “Enter” and you will be returned to your Summary sheet, or wherever you began your calculation across worksheets.
Hope this will help you.
If so please mark me brainliest.
Answered by
9
Answer:
Pls mark as BRAINLIST ANS
Attachments:
Similar questions
Chemistry,
5 months ago
Math,
5 months ago
Computer Science,
5 months ago
English,
10 months ago
Geography,
10 months ago
Social Sciences,
1 year ago