Google Sheets Quiz

In a Google Spreadsheet, the letters across the top represent __________.

• Rows
• Numbers
• Columns
• Functions

Which of the following is a feature of Google Sheets?

• Offline access, image editing tools, video conferencing

• Real-time collaboration, data analysis tools, formulas and functions, import and export data

• Spreadsheets, word processing, presentation software

• Social media integration, cloud storage, project management

Avery, Ethan, and Priya are working on a group project in Google Sheets. They want to highlight the important points by changing the font size of certain cells. How can they do this?

• Select the cell or cells they want to change, then click on the 'Font size' drop-down menu in the toolbar and select the desired font size.

• Right-click on the cell and select 'Font size'

• Go to the 'Format' menu and select 'Font size'

• Type the font size in the cell and press enter

What is the function used to sum a range of cells in Google Sheets?

• AVERAGE

• MAX

• SUM

• COUNT

Which of the following is NOT a valid cell reference in Google Sheets?

• AA1

• 0A

• B2

• C3

How can you apply a border to a cell in Google Sheets?

• Select the cell or range of cells, click on the 'Borders' button, and choose the desired border style.

• Right-click on the cell and select 'Apply Border'

• Go to the 'Format' menu and choose 'Border'

• Press Ctrl+B to apply a border to the cell

What is the formula to calculate the average of cells A1 to A10 in Google Sheets?

• =AVERAGE(A1:A10)*10

• =AVERAGE(A1:A10)

• =SUM(A1:A10)/10

• =AVERAGE(A1:A10)/10

Which of the following is a valid cell format in Google Sheets?

• Alphabet, Boolean, Image, Formula, Checkbox

• Number, Date, Time, Currency, Percentage, Text

• Integer, Email, URL, Phone Number, Boolean

• Color, Array, Time Zone, Scientific Notation, Checkbox

How can you freeze rows or columns in Google Sheets?

• Right-click on the row or column and select 'Freeze'

• Select the row or column you want to freeze, click on the 'View' menu, and then select 'Freeze'.

• Press the 'Ctrl' and 'F' keys simultaneously

• Type 'Freeze' in the search bar and select the first result

What is the function used to find the maximum value in a range of cells in Google Sheets?

• MIN

• AVERAGE

• SUM

• MAX