What Are The Main Features Of MS Excel?

What are the best features of Excel?

The Top 10 Excel FeaturesConditional Formatting.

Utility: 100 | Difficulty: 3 | Learn in 180 mins.

PivotTables.

Utility: 95 | Difficulty: 3 | Learn in 240 mins.

Paste Special.

Utility: 88 | Difficulty: 3 | Learn in 10 mins.

Add Multiple Rows.

Absolute References.

Print Optimisation.

Extend formula across/down.

Flash Fill.More items….

What are the main functions of MS Excel?

To help you get started, here are 5 important Excel functions you should learn today.The SUM Function. The sum function is the most used function when it comes to computing data on Excel. … The TEXT Function. … The VLOOKUP Function. … The AVERAGE Function. … The CONCATENATE Function.

What are the four major operation possible with MS Word?

Input, output, processing, storage.

What are the basics of MS Office?

The Office suite includes Word, a word-processing program; Excel, a financial spreadsheet program; Access, a database program; Publisher, for desktop publishing; PowerPoint, a program for creating presentations; Outlook, a program for email and scheduling; OneNote, to keep your notes organized; and InfoPath, an …

How many types of MS Office are there?

There is a perpetual version (desktop or standalone version) that is a one-time purchase. Office 2019 comes in three editions (as noted above), 2019 Home and Student for Pc/Mac, 2019 Home and Business for Pc/Mac and Microsoft Office 2019 Professional. The desktop versions are significantly different than Office 365.

What are the main features of MS Excel 2007?

So here are the top 10 features in Excel according to you.Excel Formulas. 63 people (50%) said Formulas are their favorite feature in Excel. … VBA, Macros & automation. … Pivot Tables. … Lookup Formulas. … Excel Charts. … Sorting & Filtering data. … Conditional formatting. … Drop down validation & form controls.More items…•

What are the main features of MS Word?

10 Supremely Useful Features in Microsoft WordConvert a List to a Table.Convert a Bulleted List to SmartArt.Create a Custom Tab.Quick Selection Methods.Add Placeholder Text.Changing Case.Quick Parts.Touch/ Mouse Mode in Word 2013.More items…

What is MS Office short note?

Microsoft Office is a set of computer applications mainly used for business or office purposes. First introduced in 1990, Office software is made by the Microsoft Corporation. MS Office helps simplify basic office tasks and improve work productivity. … Microsoft Office is also offered in 35 different languages.

What is the importance of MS Word?

The purpose of the MS Word is to allow the users to type and save documents. …Microsoft word is used to save documents. The documents can be copied to flash drive which serves as an external memory for your computer. This allows you to use the saved documents conveniently taking with you anywhere.

What are the uses of MS Office?

Microsoft Office is a collection of office-related applications. Microsoft Word is used to create documents. Microsoft PowerPoint is used to create presentations. Word: Microsoft Office Word is used for word processing, such as creating and editing documents.