Strings are blocks of text that appear in Spreadsheet cell, like names of people, names of cities, e-mail addresses, or names of items sold in a store. When we type strings into Spreadsheet, we always use quotation marks around them to tell Spreadsheetthat what it's about to read is one coherent block of text.
Read more What is String in Spreadsheet?
Following are some important file types:
The most common file format is XLSX. The advance users of Excel also use XLSM and XLSB to record and save Macros in Workbook.
Excel file formats
Format
|
Extension
|
Description
|
Excel Workbook
|
.xlsx
|
The default XML-based file format for Excel 2010 and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
|
Excel Macro-Enabled Workbook (code)
|
.xlsm
|
The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
|
Excel Binary Workbook
|
.xlsb
|
The binary file format (BIFF12) for Excel 2010 and Excel 2007.
|
Excel 97- Excel 2003 Workbook
|
.xls
|
The Excel 97 - Excel 2003 Binary file format (BIFF8).
|
XML Data
|
.xml
|
XML Data format.
|
Excel Add-In
|
.xlam
|
The XML-based and macro-enabled Add-In format for Excel 2010 and Excel 2007. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).
|
Excel 97-2003 Add-In
|
.xla
|
The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.
|
CSV (comma delimited) |
.csv |
Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. |
If you receive a file with extention .xls, it means it is Excel 97 - Excel 2003 file format, you can save as this file into new excel file format, i.e, .xlsx. In this way latest functionality is available and file size has also been reduced.
These are used interchangeably, however,A parameter is a variable in a method definition. When a method is called, the arguments are the data you pass into the method's parameters. When a variable is passed to a subroutine or function it is called an argument. The value used in place of the parameter when we make the procedure call is called an argument.
Read more Differences Between Parameters and Arguments
The word text string has been frequently used while writing excel formulas. A text string means, also known as a string or simply as text, a group of characters that are used as data. Text strings are most often comprised of words, numbers, special characters, the dash symbol, or the number sign.
Remember, text strings are left-aligned in a cell while the number data is right-aligned. In some cases, you may notice that number data is left-aligned. IWhen an error is identified, a small green triangle on top left corner in the cell appears, hby selection this cell, here you can see an option/tool tip that give you a short description of the error, clcik on the tool tip to convert this cell value into number.
Read more What is text string in Excel
Excel is one of the most popular spreadsheet software used by professionals in the world. In my trainings many people ask me what is advance excel? and they come to attend my training only to see that what are the advance tools in excel that make it advance? I am always happy to answer all type of strange questions that my trainees ask me.
Read more What is Advance Excel?