Question

Match each term in the second column with its correct definition in the first column. Write the letter of the term on the blank line in front of the correct definition. A chart that shows the relationship of each part to a whole. A what-if analysis tool that find the input needed in one cell to arrive at the desired result in another 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. A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point. A workbook sheet that contains only a chart. A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled. The entire chart and all of its elements. The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet. The mathematical formula to calculate a rate of increase. The mathematical rules for performing multiple calculations within a formula. The Excel feature which, after typing - and the first letter of a function, displays a list of function names. A line that serves as a frame of reference for measurement and that borders the chart plot area. The area along the bottom of a chart that identifies the categories of data; also referred to as the x-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. The formula for calculating the value after an increase by multiplying the original value the base by the percent for new value.

Answer 1

Answer:

1. Pie chart.

2. Goal seek.

3. Relative reference cell.

4. Data marker.

5. Chart sheet.

6. What-If-Analysis.

7. $Rate = \frac {Amount \; of \; increase}{Base}$

8. Order of operations.

9. Formula AutoComplete.

10. Axis.

11. Category axis.

12. Value axis

13. $Value \; after \; increase = Base * Percent \; for \; new \; value$

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. $Rate = \frac {Amount \; of \; increase}{Base}$: 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. $Value \; after \; increase = Base * Percent \; for \; new \; value$: the formula for calculating the value after an increase by multiplying the original value the base by the percent for new value.