Exploring Averages and Bar Graphs in Google Sheets

Mr. Peterson provides a quick tutorial on calculating averages and creating graphs using spreadsheet software. The video covers selecting data, applying formulas, and visualizing data with bar graphs. It also includes tips on customizing graph titles and axes for better understanding.

What is the first step to calculate the average of numbers in a spreadsheet?

• Highlight the column

• Use the formula bar

• Select the top cell of the column

• Press the enter key

Which tool does Mr. Peterson use to calculate the average of numbers?

• None of the above

• Manual calculation

• Computer

• Calculator

What key combination is used to select a range of data in a spreadsheet?

• Ctrl + Click

• Alt + Click

• Shift + Click

• Cmd + Click

How can you replicate a formula to another cell in a spreadsheet?

• Use the formula bar

• Drag the fill handle

• Type the formula again

• Copy and paste

What graphical representation does Mr. Peterson decide to create?

• Pie chart

• Line graph

• Bar graph

• Scatter plot

What does Mr. Peterson want to paste specifically after copying?

• Formulas

• Values

• Formatting

• All of the above

What action does Mr. Peterson take after calculating the average?

• Closes the program

• Prints the document

• Saves the file

• Copies the result

What is the purpose of labeling axes in a graph according to Mr. Peterson?

• To confuse the viewers

• To identify the variables

• To make the graph look better

• To comply with standards

What does Mr. Peterson adjust in the chart settings?

• Chart title

• Data range

• Chart type

• All of the above

What is the final step in Mr. Peterson's graph creation process?

• Inserting the chart

• Labeling the axes

• Adjusting the data range

• Saving the file