FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Many times you may have various worksheets where you want to roll up the numbers into one summary worksheet. Excel offers a built-in tool to help you do that very quickly and easily: ____
A
Consolidate Data
B
Compact Data
C
Either A or B
D
None of the above
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. The file path is entered in All references.

Detailed explanation-2: -If you have multiple worksheets and want to save all of them in the same PDF file, click Options in the Save As dialog box. The Options dialog box will appear. Select Entire workbook, then click OK.

Detailed explanation-3: -By clicking the sheet tabs at the bottom of the Excel window, you can quickly select one or more sheets. To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.

There is 1 question to complete.
Previous
Next