Question 1

Which Google Sheets function is used to count the number of cells in a range that meet a certain condition?

Accepted Answer

COUNTIF

Answer

MAXIF

Answer

AVERAGEIF

Answer

SUMIF

Question 2

What does the Google Sheets function VLOOKUP stand for?

Accepted Answer

Vertical Lookup

Answer

Variable Lookup

Answer

Value Lookup

Answer

Vector Lookup

Question 3

How can you protect specific cells in Google Sheets from being edited by others?

Accepted Answer

Select the cells, right-click, choose 'Protect range', set permissions

Answer

Highlight the cells and press Ctrl + P

Answer

Use a password to lock cells individually

Answer

Go to Data menu and select 'Lock cells'

Question 4

How can you add a hyperlink to a cell in Google Sheets?

Accepted Answer

Insert > Link

Answer

View > Add link

Answer

Data > Connect to link

Answer

Format > Hyperlink

Question 5

How can you add a filter to a range of data in Google Sheets?

Accepted Answer

Data > Create a filter

Answer

Insert > Filter

Answer

Format > Add filter

Answer

View > Show filter

Question 6

What is the shortcut key to undo your last action in Google Sheets?

Accepted Answer

Ctrl + Z

Answer

Ctrl + X

Answer

Ctrl + S

Answer

Ctrl + Y

Question 7

How can you insert a new row in Google Sheets?

Accepted Answer

Right-click on the row number and select 'Insert 1 above' or 'Insert 1 below'

Answer

Press Ctrl + R

Answer

Double-click on the row number

Answer

Go to Edit menu and select 'Insert Row'

Question 8

How can you freeze rows or columns in Google Sheets to keep them visible while scrolling?

Accepted Answer

View > Freeze > 1 row/1 column

Answer

Format > Lock > 1 row/1 column

Answer

Tools > Protect > 1 row/1 column

Answer

Insert > Freeze > 1 row/1 column

Question 9

What function in Google Sheets allows you to calculate the sum of a range of cells?

Accepted Answer

SUM

Answer

COUNT

Answer

AVERAGE

Answer

MAX

Question 10

What is the function of the VLOOKUP formula in Google Sheets?

Accepted Answer

Searches for a value in the leftmost column of a table and returns a value in the same row from a specified column

Answer

Deletes duplicate entries in a column

Answer

Inserts a new column to the right of the table

Answer

Calculates the average of a range of cells

Question 11

What feature in Google Sheets allows you to protect certain cells or ranges from being edited?

Accepted Answer

Protect Sheets

Answer

AutoFill

Answer

Data Validation

Answer

Freeze Panes

Question 12

What does the IMPORTRANGE function in Google Sheets allow you to do?

Accepted Answer

Import data from one Google Sheets spreadsheet to another

Answer

Find the average of a range of cells

Answer

Merge multiple cells into one

Answer

Calculate the total of a range of cells

Question 13

How can you protect an entire Google Sheets workbook from unauthorized access?

Accepted Answer

Set permissions and sharing settings to restrict access to specific users

Answer

Apply conditional formatting to hide the data

Answer

Lock cells containing sensitive information

Answer

Use the Freeze Panes feature to limit editing options

Question 14

In Google Sheets, what function can be used to count the number of cells that contain numbers within a specified range?

Accepted Answer

COUNT

Answer

AVERAGE

Answer

SUM

Answer

MAX

Question 15

Which tool in Google Sheets is commonly used for creating visual representations of data?

Accepted Answer

Charts

Answer

Filters

Answer

Formulas

Answer

Tables

Question 16

How can you freeze rows and columns in Google Sheets so that they remain visible as you scroll?

Accepted Answer

Freeze Panes

Answer

Unfreeze Cells

Answer

Hide Rows

Answer

Lock Cells

Question 17

How can you use conditional formatting in Google Sheets to highlight cells that meet specific criteria?

Accepted Answer

Format Rules

Answer

Filter Views

Answer

Data Validation

Answer

Sort Range

Related quizzes

Related quizzes