GMetrix Exam GMetrix Excel: Formulas and Functions 4 — Questions and Answers
Question 1: What does =DAYS("2026-12-31", "2026-01-01") calculate?
- The number of work days between the dates
- The number of calendar days between the dates (Correct answer)
- The difference in months
- A date error
Correct answer: The number of calendar days between the dates
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?
- CLEAN
- TRIM (Correct answer)
- STRIP
- REPLACE
Correct answer: TRIM
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?
- Adds all values in A1:A5 and B1:B5
- Multiplies corresponding values then sums the results (Correct answer)
- Returns the product of the sums
- Counts matching pairs
Correct answer: Multiplies corresponding values then sums the results
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?
- DATE()
- TODAY()
- NOW() (Correct answer)
- TIME()
Correct answer: NOW()
NOW() returns the current date and time and recalculates every time the worksheet is recalculated.
Question 5: What does =PROPER("hello world") return?
- HELLO WORLD
- hello world
- Hello World (Correct answer)
- Hello world
Correct answer: Hello World
PROPER capitalizes the first letter of each word and lowercases the remaining letters.
Question 6: Which function returns the number of characters in a text string?
- COUNT
- LEN (Correct answer)
- SIZE
- CHARS
Correct answer: LEN
LEN returns the length of a text string, counting every character including spaces.
Question 7: What does =NETWORKDAYS(start_date, end_date) calculate?
- Days the network is available
- Total calendar days
- Number of working days excluding weekends (Correct answer)
- Hours between two times
Correct answer: Number of working days excluding weekends
NETWORKDAYS returns the number of workdays between two dates, automatically excluding Saturdays and Sundays.
GMetrix Exam GMetrix Excel: Formulas and Functions 4
What does =DAYS("2026-12-31", "2026-01-01") calculate?