Excel has a useful Data Validation feature to display messages and prevent incorrect cell entry. This feature works fine with manual data typing. However, validation messages will not be displayed if invalid data is entered into a cell by copying or filling; a formula in a cell evaluates to an invalid result; a macro enters invalid data into a cell; etc.
If you open a workbook created in an older version of Microsoft Excel, you may see Compatibility Mode near the filename in the title bar:
The PDF file format is widely used because there are many free programs, applications, and websites for viewing PDF files and the official free Adobe Reader program. A significant amount of modern professional printing equipment has hardware support for the PDF format, which allows you to print files in this format without using any software.
By default, Excel saves all workbooks in the newest format (*.xlsx), but you can change the default format to *.xls or anything else.
When you select a range of data, Excel may display the Quick Analysis icon in the lower-right corner of the range. After clicking this icon, you will see a list of analysis options that can be quickly applied to the selected data.
Saving your workbook to the same location with the same name is extremely easy. However, you need to take additional actions to put your copy in another place or with a different name.
By default, Excel automatic recalculation feature is enabled. Thus, all formulas in the workbook sheets recalculate immediately after data dependencies change. Automatic recalculation of all formulas also occurs when opening a workbook.
Excel displays a popup menu when you right-click the cell or the selected range. In addition, the Mini toolbar appears above or below the popup menu. The Mini toolbar in Excel contains commonly used tools from the Home tab. The Mini toolbar is especially useful when a tab other than Home is displayed.