GMetrix Exam GMetrix Excel: Formulas and Functions 4

Question 1

What does =DAYS("2026-12-31", "2026-01-01") calculate?

Accepted Answer

The number of calendar days between the dates

Answer

DAYS returns the total number of calendar days between two dates.

Question 2

Which function removes all spaces from a text string except single spaces between words?

Accepted Answer

TRIM

Answer

TRIM removes leading, trailing, and extra internal spaces, leaving only single spaces between words.

Question 3

What does the formula =SUMPRODUCT(A1:A5, B1:B5) do?

Accepted Answer

Multiplies corresponding values then sums the results

Answer

SUMPRODUCT multiplies corresponding elements in arrays and returns the sum of those products.

Question 4

Which function returns the current date and time that updates automatically?

Accepted Answer

NOW()

Answer

NOW() returns the current date and time and recalculates every time the worksheet is recalculated.

Question 5

What does =PROPER("hello world") return?

Accepted Answer

Hello World

Answer

PROPER capitalizes the first letter of each word and lowercases the remaining letters.

GMetrix Exam Practice Test