Google Sheets Quiz

Which of the following data types does Auto-fill work with?

• Text and numbers

• Numbers and time

• Text, numbers, and dates

• Text, numbers, and time

What does the 'Fill handle' in Google Sheets allow you to do?

• Merge cells

• Auto-fill data

• Format cells

• Freeze rows and columns

How can you access the 'Advanced range sorting options' in Google Sheets?

• Format menu

• Data menu

• View menu

• Edit menu

What does the 'Fit to data' option do when resizing a column in Google Sheets?

• Adjusts the column width to fit the longest data inside its cells

• Resizes the column to a default width

• Fits all columns to the same width

• Adjusts the row height based on the data inside its cells

What does merging cells in Google Sheets mean?

• Combining two or more cells into one

• Dividing a cell into smaller parts

• Changing the format of a cell

• Creating a new cell between existing cells

What is Google Sheets' Auto-fill feature primarily used for?

• Formatting text

• Entering data quickly based on patterns

• Sorting data

• Merging cells

Which of the following data types will Auto-fill NOT work with?

• Text

• Numbers

• Time (e.g., 11:30am)

• Dates (e.g., 11/5/2022)

How can you initiate Auto-fill using the fill handle?

• Click and drag the fill handle vertically or horizontally

• Right-click and select Auto-fill from the context menu

• Double-click the fill handle

• Press Enter key after typing data

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

• To combine cells for a cleaner look

• To enable scrolling in the spreadsheet

• To retain specific rows and columns while scrolling

• To format data automatically