Distinguish between formal and Informal Information System Information systems
1 answer:
You might be interested in
Answer:
1. Pie chart.
2. Goal seek.
3. Relative reference cell.
4. Data marker.
5. Chart sheet.
6. What-If-Analysis.
7.
8. Order of operations.
9. Formula AutoComplete.
10. Axis.
11. Category axis.
12. Value axis
13.
Explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.
A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems.
Some of the terminologies and features of the Microsoft Excel software includes the following;
1. Pie chart: a chart that shows the relationship of each part to a whole.
2. Goal seek: a what-if-analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
3. Relative reference cell: in a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to in the formula.
4. Data marker: a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
5. Chart sheet: a workbook sheet that contains only a chart.
6. What-If-Analysis: the process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
7. : The mathematical formula to calculate a rate of increase.
8. Order of operations: the mathematical rules for performing multiple calculations within a formula.
9. Formula AutoComplete: the excel feature which, after typing - and the first letter of a function, displays a list of function names.
10. Axis: a line that serves as a frame of reference for measurement and that borders the chart plot area.
11. Category axis: the area along the bottom of a chart the identifies the categories of data, also referred to as the x-axis.
12. Value axis: a numerical scale on the left side of a chart that shows the range of numbers for the data points, also referred to as the y-axis.
13. : the formula for calculating the value after an increase by multiplying the original value the base by the percent for new value.