Imagine you are a financial analyst tasked with analyzing quarterly sales data for a multinational corporation. The data is stored in separate sheets within an Excel workbook, each representing sales figures from different regions (e.g., North Zone, East Zone, South Zone).How can you efficiently view and compare quarterly sales data from multiple regions in a single spreadsheet to identify trends and relationships?
(a) By creating separate charts for each region’s data.
(b) By using the Consolidate function to combine information from all regional sheets into one summary sheet.
(c) By manually copying and pasting data from each region’s sheet into a new sheet.
(d) By deleting unnecessary data from each region’s sheet.
