Excel's intercept function takes the data points that define a line on a graph and calculates the y value for the point on the graph where x is equal to zero.