DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Function
|
|
|
Conditional Formatting
|
|
|
Export
|
|
|
Ribbon
|
Detailed explanation-1: -While you’ll use Save or press Ctrl+S to save an existing workbook in its current location, you need to use Save As to save your workbook for the first time, in a different location, or to create a copy of your workbook in the same or another location.
Detailed explanation-2: -xlsm, . xltx, . xltm), the workbook is saved in Excel 97-2003 file format (. xls), a file format that can be opened by earlier versions of Excel.
Detailed explanation-3: -On the External Data tab, in the Export group, click Excel. In the Export-Excel Spreadsheet dialog box, review the suggested file name for the Excel workbook (Access uses the name of the source object). If you want, you can modify the file name. In the File Format box, select the file format that you want.