USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Perry is using multiple worksheets and would like to total the numbers into one summary worksheet. Which built-in Excel tool should Perry use to accomplish his goal quickly?
|
|
Consolidate Data
|
|
|
Error Checking
|
|
|
Evaluate Formula
|
|
|
Watch Window
|
Explanation:
Detailed explanation-1: -On the Data tab, under Tools, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. In each source sheet, select your data, and then click Add.
Detailed explanation-2: -Combine and Transform Data To combine all the files with a query, and then launch the Power Query Editor, select Combine > Combine and Transform Data. Combine and Load To display the Sample file dialog box, create a query, and then load to worksheet, select Combine > Combine and Load.
Detailed explanation-3: -Click the Insert Worksheet tab at the bottom of the screen. Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets.
There is 1 question to complete.