CM 130 Excel Prep

Front

Which Excel function is used to add a list of numbers?

Back

=SUM

Front

What type of chart is best for showing data over time with years on the x-axis?

Back

Scatter (X, Y) Chart

Front

When adding a trendline to a scatter chart, which options should you enable? Display Equation and R² Value, Show Gridlines and Legend, Display Data Table and Colors, Add Title and Subtotal

Back

Display Equation and R² Value

Front

In the equation of a line, y = mx + b, what does m represent?

Back

The slope

Front

If your trendline equation is y = 2x + 5, what is the value of y when x = 10?

Back

25

Front

What does the R² value tell you about a trendline?

Back

How well the line fits the data

Front

Which chart element makes your graph easiest to understand? Options: Vague axis labels, A clear chart title, More gridlines, Bright colors only

Back

A clear chart title

Front

What’s the quickest way to sum values in cells B2 through B20?

Back

Use AutoSum

Front

If a dataset includes years and totals, which column should be used for the X-axis?

Back

Years

Front

Before submitting your chart, which of these is best practice? Include equation & R², with clear labels, Keep the default title “Chart 1”, Leave axes unlabeled, Hide the equation to keep it simple

Back

Include equation & R², with clear labels