Google Sheets Functions and Features

This video tutorial introduces Google Sheets, guiding users through creating and organizing spreadsheets, inputting and formatting data, using functions and formulas, and leveraging advanced features for collaboration. It covers essential skills for beginners, including account setup, sheet management, data manipulation, and teamwork tools.

What is the shortcut to create a new Google Sheet directly from your browser?

• create.sheets

• new.sheets

• sheets.new

• sheets.create

How can you automatically convert uploaded files to Google Sheets format?

• By using the 'Convert Uploaded Files' option in Settings

• By opening the files with Google Sheets

• By dragging files into Google Sheets

• By renaming the files with a .gsheet extension

What is the purpose of freezing rows or columns in Google Sheets?

• To lock the data from editing

• To keep headers visible while scrolling

• To prevent data from being copied

• To highlight important data

Which of the following is NOT a text formatting option in Google Sheets?

• Underline

• Italic

• Bold

• Strikethrough

What happens when you drag the bottom right corner of a cell containing a date?

• The date is copied to the next cell

• The date sequence is expanded

• The date is converted to text

• The date is deleted

How can you ensure a cell reference remains constant when copying a formula?

• By using the 'lock' function

• By using the 'constant' function

• By highlighting the cell

• By adding a dollar sign before the column and row

Which function would you use to find the highest value in a range?

• SUM

• AVERAGE

• MAX

• MIN

What feature allows multiple users to work on a Google Sheet simultaneously?

• Version history

• Collaboration mode

• Shared editing

• Real-time collaboration

How can you notify a colleague about a comment in Google Sheets?

• By sharing the document link

• By using the 'Notify' button

• By tagging them with a plus sign and their email

• By sending an email manually

What is the primary use of notes in Google Sheets?

• To create charts

• To format cells

• To perform calculations

• To add descriptions to data