Sheets

Question 1

What is Google Sheets?

Answer 1

A web-based spreadsheet application that allows users to create, edit, and share spreadsheets online.

Question 2

True or False: Google Sheets is part of Google Workspace.

Answer 2

True

Question 3

What file format does Google Sheets use by default?

Answer 3

Google Sheets format (.gsheet)

Question 4

Fill in the blank: In Google Sheets, a _____ is a collection of cells organized in rows and columns.

Answer 4

Spreadsheet

Question 5

What is the shortcut to create a new Google Sheets document?

Answer 5

Ctrl + N (or Cmd + N on Mac)

Question 6

What feature allows you to automatically fill cells with a series of numbers or dates?

Answer 6

Autofill

Question 7

What function would you use to sum a range of cells in Google Sheets?

Answer 7

SUM

Question 8

Multiple choice: Which of the following is NOT a function in Google Sheets? A) AVERAGE B) COUNT C) SUMMARIZE D) MAX

Answer 8

C) SUMMARIZE

Question 9

How can you protect a sheet from being edited by others?

Answer 9

By setting permissions and using the ‘Protected sheets and ranges’ feature.

Question 10

True or False: Google Sheets can be accessed offline.

Answer 10

True

Question 11

What does the CONCATENATE function do?

Answer 11

It joins two or more strings of text together.

Question 12

What is the maximum number of rows in a Google Sheets document?

Answer 12

10 million cells, which translates to about 18,278 rows if each column is used.

Question 13

Fill in the blank: The _____ function returns the highest value in a numeric range.

Answer 13

MAX

Question 14

Multiple choice: Which of the following can you NOT do in Google Sheets? A) Create charts B) Use pivot tables C) Edit videos D) Share documents

Answer 14

C) Edit videos

Question 15

What is a pivot table used for in Google Sheets?

Answer 15

To summarize and analyze data from a larger dataset.

Question 16

What is the purpose of the VLOOKUP function?

Answer 16

To search for a value in the first column of a range and return a value in the same row from a specified column.

Question 17

True or False: You can import data from other spreadsheets into Google Sheets.

Answer 17

True

Question 18

What is the purpose of conditional formatting?

Answer 18

To change the appearance of cells based on specific conditions.

Question 19

Fill in the blank: The _____ function counts the number of cells that meet a specific condition.

Answer 19

COUNTIF

Question 20

What does the ‘Filter’ feature do in Google Sheets?

Answer 20

It allows users to display only the rows that meet certain criteria.

Question 21

How do you insert a new row in Google Sheets?

Answer 21

Right-click on a row number and select ‘Insert row above’ or ‘Insert row below’.

Question 22

What keyboard shortcut opens the ‘Format’ menu in Google Sheets?

Answer 22

Alt + Shift + F

Question 23

True or False: Google Sheets automatically saves your work.

Answer 23

True

Question 24

What is the function of the ‘Sort’ feature?

Answer 24

To arrange the data in a specified order, either ascending or descending.

Question 25

Fill in the blank: The _____ function allows you to find the average of a range of numbers.

Answer 25

AVERAGE

Question 26

What does the 'Data validation' feature do?

Answer 26

It restricts the type of data or values that can be entered into a cell.

Question 27

Multiple choice: Which of the following is a way to share a Google Sheets document? A) Email B) Link C) Directly in Google Drive D) All of the above

Answer 27

D) All of the above

Question 28

What is the purpose of the 'Undo' function in Google Sheets?

Answer 28

To revert the last action taken in the spreadsheet.