exam review module 4

Question 1

insert a chart

Answer 1

Highlight data, insert, chart

Question 2

To visualize data over time

Answer 2

use a line graph

Question 3

to properly move the chart

Answer 3

go under the “Design” tab.

Question 4

“quick layouts”

Answer 4

make quick design changes in the top left of the ribbon under design. (legend, labels, etc.)

Question 5

To compare between two variables

Answer 5

scatter plot

Question 6

types of charts

Answer 6

Column (good for distinguishing betwefilen 2 variables/ multiple criteria)
Line
Pie
Bar 
Area
XY (Scatter)

Question 7

why filter?

Answer 7

filtering can bring out certain data in order to bring out specific data points

Data Tab -> Filter (Ctrl+Shift+L)

Question 8

pivot tables

Answer 8

arrange and summarize complex data

Select all (range of cells)
Insert
PivotTable
New worksheet

Question 9

pivot charts

Answer 9

A pivot chart does the same thing as a pivot table, except that it also creates a chart out of the numbers within the table.

Question 10

WHAT IF analysis

ex: course grades

Participation 5% Grade 90%
Assignment 25% Grade 75%
Midterm 30% Grade 60%
Final Exam 40 % Grade x%

Answer 10

Final Grade =sumproduct(weight range:weight range)(grade range:grade range)

To figure out what your final grade will be, fill in the last grade x cell, and if your final grade cell if formatted properly with =sumproduct, you will be presented with an accurate number.

Data tab -> What if Analysis -> Goal seek
Set cell: Final grade% cell
To value: (what you want this value to be) = 80%
By changing cell: Final exam grade% = 98