Question

Write the features and importance of MS Excel​

Answer 1

Answer:

IN OFFICE WORKS TO MAKE TABLE, CHART ETC. ;)

Answer 2

Answer:Microsoft Office Excel is one of the most important tools to perform the calculation, analysis, and visualization of data and information. It helps people to organize and process data by the use of columns and rows with formulas and some cool features of Excel. In MS Excel 2010, row numbers range from 1 to 1048576. There are total 1048576 rows, and columns range from A to XFD and there are total 16384 columns. Now, let’s take a closer look at some of the best Microsoft Excel features or functions you can use to become more efficient.

Explanation:

Features are as follows:

Vlookup() function

Pie Chart

Mixed or Combination Type Charts

Data Validation

IFERROR Function

Removing Duplicates

Conditional Formatting

MINVERSE() function

DB() function

Data Visualization

Complex() function

MKDIR() function

IF() and OR() functions

Hyperlink() function

Transpose() function

INDIRECT() function

FORMAT() function

CONCATENATE() function

Paste Special

TRIM() function

ROUND() function

PROPER() function

NOW() function

CHOOSE() function

Named Ranges

Quick Feature

Input Restriction

New Shortcut Menu

Hide Data

PMT() and IPMT() functions