Google Sheets and Data Analysis Quiz

What is the first step to create a Google Sheets spreadsheet?

• Use Microsoft Excel

• Download Google Sheets app

• Open Google Drive and select Sheets

• Open Google Docs

In a typical x and y axis table, where do you place the independent variable?

• At the bottom

• On the left side

• In the middle

• On the right side

Which chart type is best for visualizing data points in Google Sheets?

• Bar chart

• Pie chart

• Line chart

• Scatter plot

How can you add a trendline to your scatter plot in Google Sheets?

• By drawing it manually

• By checking the 'Trendline' box under series options

• By using the 'Insert' menu

• By selecting 'Add Line' from the menu

What formula can you use to calculate the slope from your data in Google Sheets?

• TREND

• SLOPE

• INTERCEPT

• LINEST