DATABASE FUNDAMENTALS
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: ____
|
|
Consolidate Data
|
|
|
Compact Data
|
|
|
Either A or B
|
|
|
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: -A workbook is a spreadsheet program file that you create in Excel. A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data.
There is 1 question to complete.