What is microsoft excel and what does it do

What are the 10 uses of Microsoft Excel? What are the 5 functions in Excel? Why Excel is so popular? What are the main functions of Excel? What are the main functions of a spreadsheet? What are the features of Excel? What is basic Excel knowledge? Why is used in Excel? Also Read Who decides how much college tuition is? Also Read Can you be fired for something you say outside of work?

Read More. Common Questions. Share Tweet Pin Share Reddit. More About This. How long after Botox can you shower? The good news is if you don't need the full suite of Microsoft tools, you can access a number of its apps online for free -- including Word, Excel, PowerPoint, OneDrive, Outlook, Calendar and Skype.

Here's how to get them:. Go to Office. Log in to your Microsoft account or create one for free. Select the app you want to use, and save your work in the cloud with OneDrive.

You may be saying, wait a minute -- if I can get all of those apps for free, why pay for Microsoft in the first place? The reason is that the functionality of these apps is limited: They only run in your web browser, and you can only use them when you're online. They also have fewer features than the full Microsoft versions. There are still a number of benefits, however, including the ability to share links to your work and collaborate in real time, similar to what G Suite tools allow.

If you're looking for basic versions of each of these apps, the free version should work well for you. In Cell A1, I have the value Select a function from a group Formulas tab The Recently Used button. Auto functions under the AutoSum button. Five handy formulas for common tasks. Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

The electronic spreadsheet was essentially invented in by software pioneer Dan Bricklin , who started up Software Arts with Bob Frankston and created VisiCalc. Versions of Excel up to 7. Versions 8. Version Word : Microsoft Office Word is used for word processing, such as creating and editing documents.

Excel : Excel is used for data analysis and numeric manipulation. PowerPoint : PowerPoint is used to create and deliver presentations. Microsoft's current strategy for Office means that you can download its mobile apps for Word, Excel , and PowerPoint for free on a wide range of devices including Android and iOS.

You can download these apps for iOS, Android and Windows 10 using the links below. Select cell C2. Select cell A2 in the worksheet by using the mouse or the keyboard. This action places the cell reference A2 in the formula in the cell.

Select cell B2 in the worksheet by using the mouse or the keyboard. Press Enter. If you look down the left side of the grid, you'll see numbers, which start at number 1 at the very top and go down to over a million.

The exact number of rows and columns are 1,, rows and 16, columns. You've never going to need this many! You can click a number to highlight an entire Row. A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form.

Spreadsheets are developed as computerized simulations of paper accounting worksheets.