DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
msxcl
|
|
|
xcl
|
|
|
xlsx
|
|
|
xlsm
|
Detailed explanation-1: -In Microsoft Excel, workbooks are saved as Excel Workbooks (. xlsx) by default. You can change the default file format to any other file format that is supported in Excel.
Detailed explanation-2: -The XLS file extension is used for files saved as Microsoft Excel worksheets. Excel is a popular spreadsheet program used with data like numbers and formulas, text, and drawing shapes. Excel is part of the Microsoft Office Suite of software.
Detailed explanation-3: -For example, the file has an . xlsx file name extension but it’s really a text file and should have a . txt file name extension.
Detailed explanation-4: -Description. The Microsoft Excel Binary File format, with the . xls extension and referred to as XLS or MS-XLS, was the default format used for spreadsheets in Excel through Microsoft Office 2003. The format is also referred to as Binary Interchange File Format (BIFF) in Microsoft’s technical documentation.