Law | search
Click here to view Law news from 60+ newspapers.
Bookmark or Share- Excel specifications and limits - Microsoft SupportIn Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.
- VLOOKUP function - Microsoft SupportUse the VLOOKUP function to look up a value in a table. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also called the lookup value. The range where the lookup value is located.
- Using calculation operators in Excel formulas - Microsoft SupportThere are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators.
- Create a Venn diagram - Microsoft SupportYou can create a SmartArt graphic that uses a Venn diagram layout in Excel, Outlook, PowerPoint, and Word. Venn diagrams are ideal for illustrating the similarities and differences between several different groups or concepts. Overview of Venn diagrams.
- CONCATENATE function - Microsoft SupportUse CONCATENATE, one of the text functions, to join two or more text strings into one string. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on.
More
