Career tools

Excel test

8 quick questions. Pick one answer each, then see your score and the right answers explained.

1. VLOOKUP searches for a value in:

the last row the first column of the table any column the header row

2. If A1 is 40, what does =IF(A1>50,"Pass","Fail") show?

Pass Fail 40 TRUE

3. Which shortcut enters today's date in a cell?

Ctrl + D Ctrl + ; Ctrl + T Ctrl + Shift + D

4. Which function adds up a range of cells?

ADD SUM TOTAL PLUS

5. Which function counts cells that are not empty?

COUNT COUNTA COUNTIF SUM

6. What does =AVERAGE(2,4,6) return?

4 6 12 3

7. Which reference stays fixed when the formula is copied?

A1 $A1 A$1 $A$1

8. Every Excel formula starts with:

+ = # @

of 8 answered