Excel Ch 3 Review Exam | Questions & Answers (100%Correct)

Excel Ch 3 Review Exam | Questions & Answers (100%Correct) Excel Ch 3 Review Exam | Questions & Answers (100%Correct) Returns a number that corresponds to the system date & time beginning with December 31, 1899. - ANSWER - NOW function Returns a number that corresponds to the system date & time beginning with December 31, 1899. - ANSWER - NOW function Formats a cell quickly by copying a cell's format to another cell or range of cells - ANSWER - format painter button Formats a cell quickly by copying a cell's format to another cell or range of cells - ANSWER - format painter button Determines the value of a cell on which the formula depends. - ANSWER - goal seeking Determines the value of a cell on which the formula depends. - ANSWER - goal seeking Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell. - ANSWER - what-if analysis Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell. - ANSWER - what-if analysis Shows the relationship or proportion of parts to a whole. - ANSWER - Pie chart Shows the relationship or proportion of parts to a whole. - ANSWER - Pie chart Excel will display titles on the screen, no matter how far you scroll - ANSWER - freeze titles Excel will display titles on the screen, no matter how far you scroll - ANSWER - freeze titles Adjusts a cell referen ce when copying a formula or function - ANSWER - relative cell referencing Adjusts a cell referen ce when copying a formula or function - ANSWER - relative cell referencing Offsets a piece of a pie chart for emphasis - ANSWER - exploding Offsets a piece of a pie chart for emphasis - ANSWER - exploding Assigns a value to a cell based on a logical test. - ANSWER - IF function Assigns a value to a cell based on a logical test. - ANSWER - IF function Keeps a cell reference constant when copying a formula or function. - ANSWER - absolute cell referencing Keeps a cell reference constant when copying a formula or function. - ANSWER - absolute cell referencing A Pie chart with one or more slices offset is called a(n) ______. - ANSWER - Exploded Pie Chart A Pie chart with one or more slices offset is called a(n) ______. - ANSWER - Exploded Pie Chart When you change a value on which a chart is dependent, Excel _____. - ANSWER - immediately redraws the chart based on the new value When you change a value on which a chart is dependent, Excel _____. - ANSWER - immediately redraws the chart based on the new value If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on shich the formula depends. - ANSWER - Goal seeking If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on shich the formula depends. - ANSWER - Goal seeking Keeps a cell reference constant when copying a formula or function - ANSWER - Absolute Cell Reference Keeps a cell reference constant when copying a formula or function - ANSWER - Absolute Cell Reference Shows the relationship or porportion of parts to a whole. - ANSWER - Pie chart Shows the relationship or porportion of parts to a whole. - ANSWER - Pie chart A cell reference with only one dollar sign before either the column or the row. - ANSWER - Mixed Cell Reference A cell reference with only one dollar sign before either the column or the row. - ANSWER - Mixed Cell Reference Indicates a cell reference error. - ANSWER - #REF!