Beginners Guide to Google Sheets - Anticipation Guide

Before watching the video, read each statement and select True or False based on what you currently think. 1. Google Sheets is mainly used for:

• A) Writing essays

• B) Creating and analyzing spreadsheets

• C) Making videos

• D) Editing photos

In Google Sheets, a column is:

• A) A horizontal line of cells

• B) A vertical line of cells

• C) A single square in the spreadsheet

• D) A row and a cell combined

To start a formula in Google Sheets, you must begin with which symbol?

• #

• +

• =

• @

Dragging the Fill Handle (small square at the bottom right of a selected cell) copies or extends the cell content to adjacent cells.

• Copies or extends cell content to adjacent cells

• Moves the cell content to a different location

• Deletes the cell content

• Formats the cell as bold

Which of the following is NOT a function in Google Sheets?

• SUM

• AVERAGE

• PRINT

• MIN

If you want to change the background color of a cell, you should use:

• The Fill Color tool

• The SUM function

• The Sort tool

• The Delete button

What does the 'Freeze' function do?

• Locks certain rows or columns so they stay visible when scrolling

• Turns numbers into text

• Deletes the top row

• Creates a graph

What is the purpose of the Sort function?

• To change text size

• To organize data in a specific order (alphabetically or numerically)

• To delete empty rows

• To merge two columns

Which of the following functions calculates the total sum of selected numbers?

• SUM

• AVERAGE

• MIN

• MAX

What does the AVERAGE function do?

• Adds all the numbers together

• Finds the middle value in a list

• Finds the highest value

• Finds the lowest value