Learning MS Excel Formula, Functions and Charts
MS Excel is an application software that helps us to store and analyze data. It organizes data in the form or rows and columns. You can create and graphs from the data and convey more meaningful information through them. MS Excel is of great importance to those who maintain accounts for sales, bills or do mathematical calculations. MS Excel has features and applications for calculation, and graphics tools and tables for presenting text and numeric data.
• Ribbon Options : When you click Ribbon Options button, three different options related with the display of Ribbon is shown. Available options in Excel 2019 are "Auto-hide Ribbon", "Show Tabs", "Show Tabs and Commands".
Function should begin with the (=) or @ sign followed by the function name, SUM or AVG is a function name. The third part is arguments. It can be numbers, text or cell reference. Arguments are enclosed within parentheses (). When there is more than one argument, each is separated by a comma.
A two-dimensional chart has two axes-X-axis and Y-axis representing two different variables. Data are plotted on (X,Y) co-ordinates. A chart can also be three-dimensional, in which case data are plotted on three different variables, represented by X,Y and Z axes.