DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
*.doc
|
|
|
*.xls
|
|
|
*.ppt
|
|
|
*.pdf
|
|
|
*.psd
|
Detailed explanation-1: -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.
Detailed explanation-2: -Save to Different File Formats Click Save As. Click the Save as type list arrow. The default file type is an XLSX Excel file, but you can choose from plenty of other file formats in this menu. Select the desired format.
Detailed explanation-3: -An MS Excel file is saved with an extension of .xls.
Detailed explanation-4: -XLSX files are encoded/decoded as XML files to be saved/loaded from disc. Saving plain text files takes more time and affects the loading/saving of such files. XLSB files are saved as plain binary encoded compressed data which takes less time to save and load.