Question 1

What function would you use in Google Sheets to calculate the average of a range of numbers?

Accepted Answer

AVERAGE

Answer

MAX

Answer

COUNT

Answer

SUM

Question 2

Which function would you use to find the highest number in a range in Google Sheets?

Accepted Answer

MAX

Answer

AVERAGE

Answer

MIN

Answer

SUM

Question 3

What formula would you use to count the number of cells that contain numbers in a range in Google Sheets?

Accepted Answer

COUNT

Answer

AVERAGE

Answer

COUNTA

Answer

SUM

Question 4

Which function can you use in Google Sheets to find the minimum value in a range of cells?

Accepted Answer

MIN

Answer

MAX

Answer

COUNT

Answer

AVERAGE

Question 5

Which function would you use to return the number of non-empty cells in a range in Google Sheets?

Accepted Answer

COUNTA

Answer

SUM

Answer

COUNT

Answer

COUNTIF

Question 6

Which formula would you use to add numbers in cells B1 and B2 in Google Sheets?

Accepted Answer

B1 + B2

Answer

ADD(B1, B2)

Answer

SUM(B1, B2)

Answer

TOTAL(B1, B2)

Question 7

What function would you use to count how many cells in the range C1 to C10 contain numeric values?

Accepted Answer

COUNT(C1:C10)

Answer

SUM(C1:C10)

Answer

COUNTA(C1:C10)

Answer

TOTAL(C1:C10)

Question 8

Which formula would you use to find the difference between the values in cells F1 and F2 in Google Sheets?

Accepted Answer

F1 - F2

Answer

MINUS(F1, F2)

Answer

SUBTRACT(F1, F2)

Answer

DIFFERENCE(F1, F2)

Question 9

What function would you use to calculate the square root of a number in cell H1 in Google Sheets?

Accepted Answer

SQRT(H1)

Answer

ROOT(H1)

Answer

POWER(H1, 0.5)

Answer

SQUARE(H1)

Question 10

What function can you use in Google Sheets to find a value in a table based on a key?

Accepted Answer

VLOOKUP

Answer

SUM

Answer

HLOOKUP

Answer

MATCH

Question 11

In the VLOOKUP function, what does the 'range' parameter specify?

Accepted Answer

The table from which to retrieve data

Answer

The number of rows to return

Answer

The name of the spreadsheet

Answer

The key to search for

Question 12

What does the 'col_index_num' argument in the VLOOKUP function specify?

Accepted Answer

The column number from which to return the value

Answer

The total number of columns

Answer

The row number to search in

Answer

The search key

Question 13

What will VLOOKUP return if it does not find the specified key?

Accepted Answer

An #N/A error

Answer

The last value in the column

Answer

A blank cell

Answer

A zero

Question 14

What is a common use of the VLOOKUP function in Google Sheets?

Accepted Answer

To retrieve information from a database

Answer

To create charts

Answer

To send emails

Answer

To format text

Question 15

Which of the following is a requirement for the first column in a range used with VLOOKUP?

Accepted Answer

The first column must contain unique keys

Answer

It can contain duplicates

Answer

It must be the last column

Answer

It must be sorted in descending order

Question 16

In Google Sheets, what function would you use to sum values in a range based on multiple criteria?

Accepted Answer

SUMIFS

Answer

SUMIF

Answer

AVERAGEIFS

Answer

COUNTIFS

Question 17

Which of the following is a correct use of the SUMIFS function syntax in Google Sheets?

Accepted Answer

SUMIFS(C2:C10, A2:A10, "">5"", B2:B10, "<10")

Answer

SUMIFS(C2:C10, A2:A10, B2:B10, "5 to 10")

Answer

SUMIFS(A2:A10, C2:C10, ">5", B2:B10)

Answer

SUMIFS(C2:C10, "A2:A10>5", B2:B10, "<10")

Question 18

What result would you get using the formula: SUMIFS(B2:B8, A2:A8, "Apple", C2:C8, ">50") in Google Sheets?

Accepted Answer

The sum of values in B2:B8 where corresponding A2:A8 is "Apple" and C2:C8 is greater than 50

Answer

The sum of all values in B2:B8

Answer

The average of values in B2:B8 that meet the criteria

Answer

The number of cells in B2:B8 that meet the criteria

Question 19

Which chart type is best used for showing the relationship between two numerical values in Google Sheets?

Accepted Answer

Scatter plot

Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Question 20

In Google Sheets, what feature allows you to visually represent data trends over time?

Accepted Answer

Line chart

Answer

Bubble chart

Answer

Pie chart

Answer

Column chart

Question 21

Which type of chart would you use to show parts of a whole in Google Sheets?

Accepted Answer

Pie chart

Answer

Scatter plot

Answer

Bar chart

Answer

Line chart

Question 22

In Google Sheets, how do you create a chart from your data?

Accepted Answer

Select the data range and click on the 'Insert' menu to choose 'Chart'

Answer

Use the 'Edit' menu to add a chart

Answer

Right-click on the data and select 'Create Chart'

Answer

Double-click the data cells to generate a chart

Question 23

What is the purpose of the 'Chart editor' in Google Sheets?

Accepted Answer

To customize and format your charts

Answer

To perform calculations on data

Answer

To delete existing data

Answer

To input data into the spreadsheet

Question 24

Which chart type in Google Sheets is best suited for comparing different categories of data?

Accepted Answer

Bar chart

Answer

Pie chart

Answer

Line chart

Answer

Scatter plot

Question 25

What feature in Google Sheets allows you to visualize data without creating a separate chart?

Accepted Answer

Conditional formatting

Answer

Data validation

Answer

Sort

Answer

Filter

Related quizzes

Related quizzes