(T, F) The function below returns the value of \"False\" \"=IF(10 > 9, \"True\",
ID: 3838065 • Letter: #
Question
(T, F) The function below returns the value of "False" "=IF(10 > 9, "True", "False")". (T, F) Goal-seeking analysis is the reverse of what -if -analysis. (T, F) Area charts emphasize the magnitude of change over time similar to line charts, and can be used to draw attention to the total value over a time period. (T, F) XY (scatter) charts show relationships between two sets of data- for example, total sales and advertising budgets, or years of education and yearly income. (T, F) Conditional Formatting is used if you are interested to see the entire table and, at the same time, highlight the information that meets specific criteria. (T, F) PivotTable is accessed through the Edit menu. (T, F) In FREQUENCY (data_ array, bins_ array) Data array is an array or reference to a set of values for which you want to count frequencies and bins_ array must be organized in ascending order. (T, F) To add a title to your chart, you must click DESIGN from CHART TOOLS.Explanation / Answer
83. False
84. True
Goal-seeking analysis works in reverse way as that of what-if and sensitivity analysis i.e, instead of observing the effect of change in variable, first target output value is chosen and the required variable is computed.
85. True
Area charts emphasize the magnitude of change over time and can be used to draw attention to the total value across a trend. For example, data that represents profit over time can be plotted in an area chart to emphasize the total profit. A stacked area chart also shows the relationship of parts to a whole.
86. True
87. True
88. False
89. True
90. True
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.