Basic Excel Test Test
2 Questions
| Attempts: 1947
Test your current Excel proficiency
Questions and Answers
- 1.
Which function is used to remove superfluous blank characters?
- A.
TRIM
- B.
SPIN
- C.
CLEAN
- D.
SNIP
- E.
SEP
Correct Answer
A. TRIM -
- 2.
Which of these two functions could you use in combination to look-up employees salaries in a database?
- A.
INDEX and FIND
- B.
INDEX and MATCH
- C.
MATCH and FIND
- D.
MATCH and LOOKUP
- E.
MATCH and SORT
Correct Answer
B. INDEX and MATCH -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 03, 2013Quiz Edited by
ProProfs Editorial Team -
Jul 31, 2009Quiz Created by
Chris_littlewood
Back to top