Excel Ch 3 Terms 2Online version Match the definitions with its correct term. by Kerri Stegman 1 A chart that resides completely on a separate sheet of paper a chart sheet b pie chart c offsetting d sparkline chart 2 Can be used to quickly format a cell by copying a cell’s format to another cell or range of cells a data series b nested if function c format painter d what-if analysis 3 Data that determines the size of the slices in a pie a pie chart b goal seeking c what-if analysis d data series 4 IF function within an IF function a nested if function b what-if analysis c data series d goal seeking 5 Setting off from the rest so it stands out a chart sheet b offsetting c category names d goal seeking 6 To determine the value of a cell on which the formula depends a what-if analysis b offsetting c goal seeking d nested if function 7 Identifies the slices in a Pie chart a data series b format painter c chart sheet d category names 8 Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell a what-if analysis b goal seeking c nested if function d offsetting 9 Used to show the relationship or proportion of parts to a whole a format painter b category names c pie chart d sparkline chart 10 Provides a simple way to show trends and variations in a range of data within a single cell a goal seeking b chart sheet c nested if function d sparkline chart 11 Useful when you want to assign a value to a cell based on a logical test a fill series b IF function c range finder d assumptions
New game