FINALS EXAM

To calculate the mean of values in H2 through H6, which formula should you use in Google Sheets?

• MEAN(H2:H6)

• It is not possible to calculate the mean in Google Sheets

• =AVERAGE(H2:H6)

• =AVG(H2:H6)

Which tab should you use to insert a graph in a spreadsheet?

• The fill handle

• =MAX(range)

• Insert menu > Chart

• Pie chart

True or False: You can merge cells across columns in a single row.

• True

• False

Which function identifies the highest value in a range of data in Google Sheets?

• MAX(range)

• =MAX(range)

• MAXIMUM(range)

• =MAXIMUM(range)

If you use the SUM formula on A1:A3, what result will it return in Google Sheets?

• 4

• 6

• 5

• 15

What is the most appropriate chart to illustrate A PART OF A WHOLE?

• Pie chart
• Histogram
• Line graph
• Bar chart

The values in A1 : A3 are ______ aligned?

• left
• center
• justified
• right

What does clicking the 'Decrease Decimal Places' button do in Google Sheets?

• Rounds the numbers down permanently

• Reduces visible decimal digits without changing the actual value

• Converts the cell format to decimal point numbers

• Deletes all digits after the decimal point

Which feature allows you to fill adjacent cells with a sequence based on a pattern?

• Autofit

• Merge cells

• Fill handle

• Border tool

Which chart would be most effective to show monthly temperature trends over a year?

• Pie chart

• Bar chart

• Line chart

• Scatter plot