Subject | English | Chinese simplified |
comp., MS | implicit intersection | 绝对交集 (A reference to a range of cells instead of a single cell that is calculated like a single cell. If cell C10 contains the formula =B5: B15*5, Excel multiplies the value in cell B10 by 5 because cells B10 and C10 are in the same row) |
comp., MS | set intersection | 交集 (The collection of elements in a first set that also appear in a second set) |