Q 01/05

In the Google Sheets function VLOOKUP, what does the letter V stand for?

A) Value

B) Vector

C) Vertical

D) Variable

Answer · why

C) Vertical

Vertical is the word, because the search runs down a column, while the sister function HLOOKUP does the same job horizontally across the top row.

Q 02/05

Google Sheets can open and edit .xlsx files, the native format of which rival spreadsheet program?

A) Apple Numbers

B) Lotus 1-2-3

C) LibreOffice Calc

D) Microsoft Excel

Answer · why

D) Microsoft Excel

Microsoft Excel still treats 1900 as a leap year, a long-standing bug that Google Sheets quietly corrects in its own date system.

Q 03/05

In the Google Sheets formula =GOOGLETRANSLATE(A2,"en","ko"), which language does the code "ko" request?

A) Khmer

B) Kazakh

C) Korean

D) Kurdish

Answer · why

C) Korean

Korean is the target here, because the function reads its codes in order, source first and target second, and "auto" lets it detect the source languag...

Q 04/05

Google Sheets labels its first 26 columns A to Z, so which label does the very next column carry?

A) ZA

B) A1

C) AA

D) Z1

Answer · why

C) AA

AA comes next, then AB, AC and onwards: once the single letters run out, spreadsheet column labels simply double up.

Q 05/05

Which Google app for building surveys and quizzes can save every response to a linked Google Sheets file?

A) Keep

B) Sites

C) Slides

D) Forms

Answer · why

D) Forms

Forms can create a fresh response spreadsheet in one click, and Sheets automatically arranges the incoming answers in a table.