Google Sheets Formulas and Basic Functions Questions and Answers

Question 1

A user has a list of sales figures in cells C2 through C50.
Some cells are blank, indicating no sales for that day.
To calculate the average sales for only the days where a sale was made, which function should be used?

Accepted Answer

=AVERAGE(C2:C50)

Answer

=AVERAGEA(C2:C50)

Answer

=SUM(C2:C50)/50

Answer

=MEDIAN(C2:C50)

Question 2

In Google Sheets, what is the primary difference between the `COUNT` and `COUNTA` functions?

Accepted Answer

`COUNT` only counts numeric values, while `COUNTA` counts both numeric and text values.

Answer

`COUNT` counts all cells in a range, while `COUNTA` excludes blank cells.

Answer

`COUNT` is used for single columns, while `COUNTA` can be used for multiple columns.

Answer

`COUNT` is an older function, and `COUNTA` is the newer, more efficient version.

Question 3

A project manager wants to combine a project name from cell A2 with a task description from cell B2, separated by a hyphen. Which of the following formulas will correctly achieve this?

Accepted Answer

=A2 & " - " & B2

Answer

=JOIN("-", A2, B2)

Answer

=CONCAT(A2, "-", B2)

Answer

=COMBINE(A2, "-", B2)

Question 4

You are creating a report and need to display the current date and time, which should automatically update every time the spreadsheet is opened or modified. Which function should you use?

Accepted Answer

=NOW()

Answer

=DATE()

Answer

=TODAY()

Answer

=CURRENT_DATETIME()

Question 5

A sheet contains a list of products in column A and their corresponding sales revenue in column B. To calculate the total revenue for only the products named 'T-Shirt', which formula is most appropriate?

Accepted Answer

=SUMIF(A:A, "T-Shirt", B:B)

Answer

=SUM(B:B)

Answer

=VLOOKUP("T-Shirt", A:B, 2, FALSE)

Answer

=IF(A:A="T-Shirt", SUM(B:B))

Question 6

Which of the following formulas correctly uses the `VLOOKUP` function to find the price of a 'Laptop' (located in cell E1) from a table in the range A2:C10, where prices are listed in the third column of the range?

Accepted Answer

=VLOOKUP(E1, A2:C10, 3, FALSE)

Answer

=VLOOKUP(A2:C10, E1, 3, TRUE)

Answer

=VLOOKUP(E1, 3, A2:C10, "Exact")

Answer

=VLOOKUP(C2:C10, E1, 1, FALSE)

A user has a list of sales figures in cells C2 through C50.Some cells are blank, indicating no sales for that day.To calculate the average sales for only the days where a sale was made, which function should be used?

A user has a list of sales figures in cells C2 through C50.
Some cells are blank, indicating no sales for that day.
To calculate the average sales for only the days where a sale was made, which function should be used?