ChatGPT Excel quiz

Released: March 2, 2024

Updated: March 23, 2024

By: Excel Effects

Basic ChatGPT Excel quiz.

Excel Effects wanted to try out the functionality of this popular AI tool. So, we had the AI create a basic quiz on Excel. Well, we think it is fairly basic. Also, we thought the AI was pretty impressive. However, there was one minor issue and one error.

Minor issue: Four of the five answers from the AI was B. It did not mix up the answers the way we would like. Therefore, we switch some of them around.

One error: It gave us a wrong answer on one of the questions, which we fixed.

Take ChatGPT Excel quiz

It is time to take the five question AI quiz on Excel. Again, it is fairly basic. Also, we put in all the questions and answers exactly how the AI gave us. To start the quiz, click on the start button below.

Keep in mind, you only get to pick your answer once. So, make it a good one.

Passing score is 80%. Enjoy!

ChatGPT Excel quiz I

1 / 5

1. Which function is used to look up a value in a table in Excel?

SEARCH()

COUNTIF()

VLOOKUP()

2 / 5

2. What does the cell reference $A$1 indicate?

Absolute column and relative row.

Absolute row and relative column.

Absolute column and absolute row.

3 / 5

3. How do you freeze panes in Excel?

Select the row or column, right-click, and choose "Freeze Panes."

Press Ctrl + F to freeze the panes.

Go to the View tab, click on Freeze Panes, and select the option.

4 / 5

4. Which formula is used to find the average of a range of cells?

SUM()

AVERAGE()

COUNT()

5 / 5

5. What does the function SUM(A1:A5) do?

Multiplies the values in the range.

Adds the values in the range.

Finds the average of the values in the range.

Your score is