What are 10 features of Microsoft Excel?

What are 10 features of Microsoft Excel?

The Top 10 Excel Features

• Conditional 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.

How do I put indicators in Excel?

Format cells by using icon sets

1. Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
2. On the Home tab, click Conditional Formatting.
3. Point to Icon Sets, and then click the icon set that you want. Tip: Icon sets can be combined with other conditional formats.

What is an Excel spreadsheet document called?

In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.

What is MS Excel and features?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software.

What makes a good Excel spreadsheet?

Excel for Architects – 9 Steps to Beautiful Spreadsheets

• Choose a good font.
• Align your data.
• Give your data some space.
• Define your headers.
• Choose your colors carefully.
• Shade alternate rows for readability.
• Use Grids Sparingly.
• Create cell styles for consistency.

How do I apply three flags icon in Excel?

In the New Formatting Rule dialog, select the following options:

1. Click the Reverse Icon Order button to change the icons’ order.
2. Select the Icon Set Only checkbox.
3. For the green flag, set >=3.
4. For the yellow flag, set >2.
5. Set Type to “Number” for both icons.

What are the basic parts of Microsoft Excel?

Also called a spreadsheet, the workbook is a unique file created by Excel XP.

• Title bar. The title bar displays both the name of the application and the name of the spreadsheet.
• Menu bar.
• Column headings.
• Row headings.
• Name box.
• Formula bar.
• Cell.
• Navigation buttons and sheet tabs.