30 MCQs on Google Sheets Basics

Which symbol is used to start a formula in Google Sheets?

• @

• =

• #

• $

Which menu is used to apply conditional formatting?

• Data

• Format

• Tools

• Insert

What is the default file extension of Google Sheets when downloaded as Excel?

• .csv

• .xlsx

• .txt

• .docx

Which formula is used to add a range of numbers?

• COUNT

• SUM

• AVERAGE

• MAX

Which feature allows you to freeze the top row for easy navigation?

• Lock

• Freeze

• Hold

• Protect

What does the function `=COUNT(A1:A10)` do?

• Adds numbers

• Counts all cells with numbers

• Counts text values

• Returns average

Which of these can be shared directly from Google Sheets?

• Only Excel file

• Link

• Image only

• None

Which formula finds the largest number in a range?

• MAX

• LARGE

• TOP

• HIGH

Which shortcut inserts a new sheet?

• Shift + N

• Shift + F11

• Ctrl + Enter

• Ctrl + T

Which chart is best for showing percentages?

• Line

• Pie

• Column

• Scatter