CM 130 Excel Prep

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

• =TOTAL

• =ADD

• =SUM

• =COUNT

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

• Pie Chart

• Scatter (X, Y) Chart

• Bar Chart

• Histogram

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

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

• The y-intercept

• The slope

• The R² value

• The average

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

• 15

• 20

• 25

• 30

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

• How well the line fits the data

• The slope of the line

• The number of data points

• The maximum value in the dataset

Which chart element makes your graph easiest to understand?

• Vague axis labels

• A clear chart title

• More gridlines

• Bright colors only

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

• Type each number manually

• Use AutoSum

• Highlight cells and press Enter

• Right-click → Add

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

• Totals

• Years

• Both columns

• None

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