Blog - Page 2 of 4

Symbols Used in Excel Formula

Here are the important symbols used in Excel Formulas. Each of these special characters have used for different purpose in Excel. Let us see complete

The information entered in an Excel Cells in called as Cell Contents in Excel. Any kind of Data (String, Numeric, Date, Currency) and Formulas are

The information or Objects used in Excel Workbooks to visualize the data is called Contents in Excel. All the Objects in a Workbook or information

Same information populated in multiple cells, sheets or any other objects in Excel is called duplicate data. Data can be duplicated in multiple rows,

Definition: A Data in Excel is the information store in the Excel Objects. We can store in Excel Cells, Ranges, Rows, Columns, Sheets, Charts, Tables

It is very easy to find duplicates in Excel. We can use built in tools (Conditional Formats, Filters) or formula (COUNTIF or VLOOKUP) to

We can close an Excel Workbook in different methods: We close the Workbook by using the Close Window button (X icon in the application menu)

We can save Excel Files in the following ways: Using shortcuts: We can use keyboard shortcut keys Ctrl+S to Save Excel Workbook Save Icon: We

We can Open multiple Excel Workbooks in the same window in different methods: If the Excel Application is already opened, we can use the Open command

Excel is MDI (Multi Document Interface till Excel 2010. i.e; when you open a new workbook, it will open in the already opened ApplicationWindow. We