NO VBA - Excel Basic to Advance Test

This is an Excel Test that contains 15 questions, designed to test the persons knowledge about excel.

It covers the most used commands and functions:

1. Keyshortcuts

2. Naming convention of the Cell, Row and Column

3. Sumif, sumifs, countif, countifs, if, ifs, counta, countblank, vlookup and hlookup functions.

The correct answers are the following:

1. Columns have letters as notations

2. Rows have numbers as notations

3. Cells have a combination of letters and numbers - first the letter corresponding the column and then the number corresponding the row (ex. A1) 

4. Ctrl+1

5. Alt+=

6. = starts a formula

7. Ctrl+h

8. =IF(AND(C22>9;D22>1,5);"True";"False") - same formula with different cells for the next 3 rows.

9. =COUNTIF(C28:G32;D28)

10. Good Apples: =COUNTIFS(C36:C55;C38;D36:D55;D38)

      Bad Apples: =COUNTIFS(C36:C55;C38;D36:D55;D37)

11. =SUMIF(C36:C55;C38;E36:E55)

12. =SUMIFS(E36:E55;C36:C55;C38;D36:D55;D36)

13. =VLOOKUP(C40;C35:E55;3;0)

14. =COUNTBLANK(E36:E55)

15. =COUNTA(E36:E55)

16. V stands for vertical and H for horizontal

17. Yes, the second, third etc IFs should be put in the value_if_false argument. 

The score should be marked with 1pt and the sum of all points should be divided by the number of questions: 12points (12 correct answered questions)/17questions = 70.58% > 71%.

The passing score should be 90% if you want to make sure that the person knows the basic of Microsoft Excel.