Mod 6 - Displaying & Optimizing Data in Excel

Question 1

What kind of data are scatterplots good for?

Answer 1

They are good at representing scientific or numerical data.

Question 2

What does the filter button do?

Answer 2

It allows to narrow down a data set by only displaying data that meet certain criteria. (merely hides data)

Question 3

What is a pivot table?

Answer 3

It allows you to reorganize selected rows & columns from a data set to give a summary report. You can easily move the location of rows and columns to show desired information, hence the name “pivot” table. You can also add filters to sort the data.

Question 4

What is a pivot chart?

Answer 4

It creates a table and a graph to display the data in the table visually & conveniently.

Question 5

What is the SUMPRODUCT function?

Answer 5

It multiplies corresponding components in the given
arrays and returns the sum of those products. What-if-analysis more convenient though.
=SUMPRODUCT(array 1, array 2, etc.)

ex. =SUMPRODUCT(C3:C6, D3:D6)

Question 6

What is a what-if-analysis? (goal seek)

Answer 6

It changes the values in cells to see how those
specific changes will affect the outcome of formulas on the worksheet.

ex. set cell: $D$8
to value: 80%
by changing cell: $D$6