Google Sheets Functionality and Features

This video tutorial provides a comprehensive guide to using Google Sheets. It begins with an introduction to the basic features of Google Sheets, followed by detailed instructions on creating a new sheet, entering data, and formatting it. The tutorial also covers how to rename and duplicate sheets, as well as how to sort and filter data effectively. The video concludes with a summary of the key points discussed.

What is the color of the Google Sheets icon?

• Red

• Blue

• Yellow

• Green

Where should you write your name in a new Google Sheet?

• In the 'untitled spreadsheet' field

• In the header

• In the first cell

• In the footer

How do you adjust the width of a column in Google Sheets?

• Both B and C

• Drag the column border

• Double-click the column border

• Right-click and select 'Resize column'

What should you do before adding borders to cells?

• Enter data

• Adjust column width

• Select the cells

• Rename the sheet

How can you rename a sheet in Google Sheets?

• Both A and B

• Go to File > Rename

• Right-click the sheet tab and select 'Rename'

• Double-click the sheet tab

What happens when you duplicate a sheet in Google Sheets?

• A new blank sheet is created

• The original sheet is renamed

• The original sheet is deleted

• A copy of the original sheet is created

How do you sort data from smallest to largest in Google Sheets?

• Click the filter icon and select 'Sort A to Z'

• Use the 'Sort' function in the Edit menu

• Use the 'Sort' function in the Data menu

• Manually rearrange the rows

What should you do before applying a filter to data?

• Adjust column width

• Select the data range

• Enter data

• Rename the sheet

How can you filter data to show only specific values?

• Use the 'Find' function

• Apply a filter and uncheck unwanted values

• Sort the data

• Manually hide rows

What is the final step after creating and formatting your Google Sheet?

• Review and edit the sheet

• Print the sheet

• Share the sheet

• Save the sheet