Excel Chapter 3: End-of-Chapter Quiz Already Graded A

Document Content and Description Below

Excel Chapter 3: End-of-Chapter Quiz Already Graded A Pie Chart ✔✔A chart that shows the relationship of each part to a whole Goal Seek ✔✔A what-if analysis tool that finds the input needed... in one cell to arrive at the desired result in another cell Relative cell reference ✔✔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 Data Marker ✔✔A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point Chart sheet ✔✔A workbook sheet that contains only a chart Bevel ✔✔A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled Chart area ✔✔The entire chart and all of its elements What-if analysis ✔✔The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet Rate = amount of increase/base ✔✔The mathematical formula to calculate a rate of increase Order of operations ✔✔The mathematical rules for performing multiple calculations within a formula Formula AutoComplete ✔✔The Excel feature which, after typing = and the first letter of a function, displays a list of function names Axis ✔✔A line that serves as a frame of reference for measurement and that borders the chart plot area Category axis ✔✔The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis 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 Value after increase ✔✔The formula for calculating the value after an increase by multiplying the original value-the base-by the percent for new value An enterprise fund ✔✔A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services Absolute ✔✔A cell reference that refers to a cell by its fixed position in a worksheet is Point ✔✔A value that originates in a worksheet cell and that is represented in a chart by a data marker is a.. Series ✔✔Related data points represented by data markers are referred to as the data.. Explode ✔✔The action of pulling out a pie slice from a pie chart Major unit ✔✔The value in a chart's value axis that determines the spacing between the gridlines in the plot area is the.. Increase ✔✔The percent by which one number increases over another number is the percentage rate of.. Line chart ✔✔A chart type that displays trends over time is a... Plot area ✔✔The area bounded by the axes of a chart, including all the data series, is the.. Category axis (2) ✔✔The x-axis is also known as the.. 3-D ✔✔The term that refers to an image that appears to have all three spatial dimensions is.. Value axis (2) ✔✔The y-axis is also known as the.. Color or pattern ✔✔In a chart, each data point-bar, slice, and so on- has a unique.. Base ✔✔The starting point when you divide the amount of increase by it to calculate the rate of increase is the.. A data marker ✔✔A pie slice is an example of.. [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: