How can data consolidation be helpful? Check all that apply •It can set up automatic updating of data within one worksheet.
•it can summarize data from worksheets in different workbooks.
•it helps to summarize data from worksheets that are not identical.
•it combines data from multiple sheets to create one concise table.
• it summarizes data based on how many rows and columns have values.