Wednesday Recap for Day 2

Which function is used to add up a range of numbers in Google Sheets?

• COUNT

• SUM

• AVERAGE

• ADD

How do you freeze the top row in Google Sheets?

• View > Freeze > 1 row

• Format > Row > Freeze

• Insert > Freeze

• Data > Freeze

What is the shortcut to insert the current date in a cell?

• Ctrl + D

• Ctrl + ;

• Ctrl + Shift + :

• Ctrl + /

What is the purpose of conditional formatting?

• To filter values

• To apply color or style based on conditions

• To lock cells

• To create forms

What type of question allows users to select multiple answers in Google Forms?

• Multiple choice

• Short answer

• Checkboxes

• Dropdown

How can responses from Google Forms be directly stored?

• In a Word document

• In Google Keep

• In Google Sheets

• In Google Docs

How do you make a question required in Google Forms?

• Click the three-dot menu > Required

• Click the toggle button labeled “Required”

• It is required by default

• Type "Required" in the description

What is Google Sheets used for?

• Writing stories

• Making spreadsheets and calculations

• Sending emails

• Editing photos

How do you start a new Google Sheet?

• From Google Calendar

• From Gmail

• Click “+ Blank” in Google Sheets

• Type in a search bar

What symbol starts a formula in Google Sheets?

• #

• =

• $

• &