8th Spreadsheets: Trends and Forecast

What is the primary use of line graphs in data analysis?

• To show percentages of a whole

• To compare different categories

• To display changes over time

• To forecast future trends

All of the following are types of charts except...

• Circle

• Scatter

• Line

• Column

What does a pie chart best represent?

• Changes over time

• Predictions of future trends

• Comparison of quantities

• Percentage breakdown of a whole

What is the purpose of adding a trendline in a graph?

• To compare different sets of data

• To show the percentage of each category

• To predict future data points

• To display data in a more colorful way

Which type of graph is most suitable for showing the population growth of a city over ten years?

• Pie chart

• Bar chart

• Line graph

• Scatter plot

Which of the following is not a data source?

• Primary

• Published

• Frequency

• Original

Primary source information includes artifacts and original documents that were created or gathered by people who were directly involved in events.

• True

• False

Original data can be collected using all of the following except?

• Measurements

• Chatgpt

• Surveys

• Observation

When creating a chart, which of the following tabs will you find the chart options?

• Home

• Insert

• View

• Data

What is an advantage of using a line graph instead of a bar chart for displaying data over time?

• It can show exact values for each data point

• It is better at showing the trend over time

• It can display multiple categories more clearly

• It is more visually appealing