Excel Chapter 3: End-of-Chapter Quiz

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

The address of a cell based on the relative position of the cell that contains the formula and the cell referred to.

<p>A single data point.</p> Signup and view all the answers

<p>A workbook sheet that contains only a chart.</p> Signup and view all the answers

<p>A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.</p> Signup and view all the answers

<p>The entire chart and all of its elements.</p> Signup and view all the answers

<p>The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.</p> Signup and view all the answers

<p>Rate = amount of increase/base.</p> Signup and view all the answers

<p>The mathematical rules for performing multiple calculations within a formula.</p> Signup and view all the answers

<p>The Excel feature that displays a list of function names after typing = and the first letter of a function.</p> Signup and view all the answers

<p>A line that serves as a frame of reference for measurement.</p> Signup and view all the answers

<p>The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.</p> Signup and view all the answers

<p>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.</p> Signup and view all the answers

<p>The formula for calculating the value after an increase by multiplying the original value by the percent for the new value.</p> Signup and view all the answers

<p>A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged.</p> Signup and view all the answers

<p>A cell reference that refers to a cell by its fixed position in a worksheet.</p> Signup and view all the answers

<p>A value that originates in a worksheet cell and is represented in a chart by a data marker.</p> Signup and view all the answers

<p>Related data points represented by data markers.</p> Signup and view all the answers

<p>The action of pulling out a pie slice from a pie chart.</p> Signup and view all the answers

<p>The value in a chart's value axis that determines the spacing between the gridlines.</p> Signup and view all the answers

<p>The percent by which one number increases over another number.</p> Signup and view all the answers

<p>A chart type that displays trends over time.</p> Signup and view all the answers

<p>The area bounded by the axes of a chart, including all the data series.</p> Signup and view all the answers

<p>The x-axis.</p> Signup and view all the answers

<p>An image that appears to have all three spatial dimensions.</p> Signup and view all the answers

<p>The y-axis.</p> Signup and view all the answers

<p>Each data point has a unique color or pattern.</p> Signup and view all the answers

<p>The starting point when you divide the amount of increase by it.</p> Signup and view all the answers

<p>A pie slice is an example of a data marker.</p> Signup and view all the answers