Question

Edra kinsman is the sales manager for narbonne suites hotel chain, which has locations in washington, oregon, idaho, and montana. edra is using multiple worksheets to summarize sales data by state. break the external link in the worksheet, so that the formulas in the range b4:b7 of the manager information worksheet are replaced with static values. then switch to the manager information worksheet.

Answer 1

To summarize and present the findings from multiple worksheets, combine the data from each worksheet into a single worksheet.

Describe a worksheet?

In Excel documents, a "worksheet" is a collection of cells organised into rows and columns. Data consolidation enables the fusion of data from multiple worksheets into a single master worksheet.

In other words, you can quickly update a single worksheet by using the Data Consolidation tool to combine data from multiple worksheets or workbooks.

Thus, To summarize and present the findings from multiple worksheets

For more details about worksheet, click here:

https://brainly.com/question/27957051

#SPJ1