Complex Google Sheets Test - 35+ MCQs: Google Sheets Quiz: Test Your Spreadsheet Proficiency with Challenging Questions

1. How do you merge data from multiple Google Sheets into a single sheet?

Using the IMPORTRANGE function

Manually copying and pasting

Exporting as CSV and importing

Applying a custom script

2. Which formula is used to count the number of unique entries in a column?

=COUNTUNIQUE()

=UNIQUE_COUNT()

=DISTINCT()

=COUNT_DISTINCT()

3. Which feature allows you to protect specific cells from being edited in Google Sheets?

Cell Locking

Protect Sheet

Cell Permissions

Read-only Cells

4. Which function would you use to extract the nth word from a text string in Google Sheets?

=SPLIT()

=TOKEN()

=WORD()

=MID()

5. Which of the following is NOT a valid error type in Google Sheets?

#N/A

#ERROR

#DIV/0!

#VALUE!

6. What function would you use to concatenate text in Google Sheets?

=MERGE()

=CONCAT()

=TEXTJOIN()

=COMBINE()

7. Which function can you use to calculate the internal rate of return (IRR) in Google Sheets?

=IRR()

=RATE()

=NPV()

=ROI()

8. How can you freeze rows and columns in Google Sheets?

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

Go to 'View' and select 'Freeze'

Use the 'Freeze Panes' option in the toolbar

Drag the freeze handle from the top-left corner

9. How do you apply conditional formatting based on multiple criteria in Google Sheets?

Using the 'Format cells if...' option and setting multiple conditions

Applying a custom script

Manually formatting each cell

Using the 'Conditional Formatting Wizard'

10. Which function is used for conditional formatting in Google Sheets?

=FORMAT_CONDITIONAL()

=STYLE_IF()

=IF_CONDITION()

=CONDITIONAL_FORMAT_RULE()

11. How can you filter data in Google Sheets?

Using the 'Filter' option under 'Data'

Manually hiding rows

Sorting columns alphabetically

By coloring cells with different shades

12. What function would you use to find the average of cells B1 to B10?

=MEAN(B1:B10)

=AVERAGE(B1:B10)

=AVG(B1:B10)

=SUM(B1:B10)/10

13. Which of the following formulas can you use to generate a random number between 1 and 100?

=RND() * 100

=RAND() * 100

=RANDOM(1,100)

=NUMBER(1,100)

14. Which formula would you use to find the sum of cells A1 to A10?

=SUM(A1:A10)

=ADD(A1:A10)

=TOTAL(A1:A10)

=COUNT(A1:A10)

15. How can you add a chart or graph to your Google Sheet?

Using the 'Chart' option under 'Insert'

By manually drawing the chart

By importing an image of the chart

By using a third-party add-on

16. How can you protect an entire Google Sheet from being viewed by unauthorized users?

Setting the sheet's visibility to 'Private'

Applying a password protection

Restricting sharing options

Using Google Drive's advanced sharing settings

17. How do you insert a new sheet in Google Sheets?

Right-click on an existing sheet tab and select 'Insert Sheet'

Go to 'Insert' and choose 'New Sheet'

Press Ctrl + Shift + N

All of the above

18. Which formula is used to perform a two-dimensional lookup in Google Sheets?

=LOOKUP()

=HLOOKUP()

=VLOOKUP()

=2DLOOKUP()

19. How do you split text into different columns based on a delimiter?

Using the 'Split text to columns' feature

Using the 'Concatenate' function

Manually copying and pasting

Using the 'Data Format' option

20. What does the QUERY function do in Google Sheets?

Returns values based on specified conditions

Counts the number of cells in a range

Returns the first non-empty value in a range

Creates a new sheet

21. What shortcut can you use to autofill a series of numbers in a column?

Ctrl + A

Ctrl + F

Ctrl + E

Ctrl + R

22. How do you sum a range of cells in Google Sheets?

=SUM(A1:A10)

=TOTAL(A1:A10)

=ADD(A1:A10)

=RANGE_SUM(A1:A10)

23. Which formula would you use to find the most frequently occurring value in a range?

=FREQUENT()

=MOST_COMMON()

=MODE.MULT()

=FREQ_MODE()

24. What does the GOOGLEFINANCE function allow you to do in Google Sheets?

Retrieve financial data for stocks, currencies, and mutual funds

Calculate financial ratios

Graph financial trends

Generate financial reports

25. How can you protect an entire sheet in Google Sheets?

By setting the sheet to 'Read-Only' mode

By sharing the sheet as a PDF

By using the 'Protect Sheet' feature

All of the above

26. Which function is used to fetch data from another sheet in Google Sheets?

=SHEET()

=TAB()

=GET_SHEET()

=INDIRECT()

=FETCH_SHEET()

27. How can you adjust column width in Google Sheets?

Dragging the column boundary

Using the 'Format' menu

Entering specific width values

All of the above

28. How can you transpose a row into a column (or vice versa) in Google Sheets?

Using the 'Transpose' function

Manually copying and pasting

Using the 'Sort & Filter' option

Converting the sheet to a CSV file and importing

29. How can you create a dynamic drop-down list in Google Sheets based on another cell's value?

Using a combination of INDIRECT and Data Validation

Applying VLOOKUP with Data Validation

Using the FILTER function with Data Validation

Utilizing the QUERY function with Data Validation

30. How can you create a drop-down list in Google Sheets?

Using the 'Data Validation' feature

Inserting a combo box

Manually typing list items and using autofill

Using the 'Sort & Filter' option

Google Sheets MCQ Test 1