Search Header Logo

30 MCQs on Google Sheets Basics

Authored by Rw8 Sodvadiya

Information Technology (IT)

University

Used 1+ times

30 MCQs on Google Sheets Basics
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

@

=

#

$

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which menu is used to apply conditional formatting?

Data

Format

Tools

Insert

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

.csv

.xlsx

.txt

.docx

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula is used to add a range of numbers?

COUNT

SUM

AVERAGE

MAX

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Lock

Freeze

Hold

Protect

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Adds numbers

Counts all cells with numbers

Counts text values

Returns average

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these can be shared directly from Google Sheets?

Only Excel file

Link

Image only

None

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?