Which of the following is true of a what-if analysis?
A)It is an examination of how changing values entered directly in a worksheet affect calculated values.
B)It is used to display both the current date and the current time.
C)It has a fill handle that can be dragged over a range to fill the series.
D)It limits the type of data that can be entered in a cell and removes duplicate data in a row.

Question

Which of the following is true of a what-if analysis? ​
A)It is an examination of how changing values entered directly in a worksheet affect calculated values.
B)It is used to display both the current date and the current time.
C)It has a fill handle that can be dragged over a range to fill the series.
D)It limits the type of data that can be entered in a cell and removes duplicate data in a row.

Quizplus · Accepted Answer

What-if analysis is a process that allows you to change values in a spreadsheet to see how those changes will affect the outcomes of formulas in the sheet. It does not relate to displaying dates and times, filling series, or limiting data types and removing duplicates.

Which of the Following Is True of a What-If Analysis