Quizsummary
0 of 15 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
Information
This is a quick test on your Excel skills.
There are 14 questions from the very basics to advanced features and formulas. In addition, time is limited to 10 min, so you need to manage your time!
Your results will be shown directly at the end of the test, as well as sent to you via email.
In addition by clicking on VIEW QUESTIONS at the end of the test you can view the entire correction.
Thank you!
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 15 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score 

Your score 

Categories
 Knowledge 0%
 Reasoning 0%

Thank you for your time!
To review the questions with your answers, please click on VIEW QUESTIONS.
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 Answered
 Review

Question 1 of 15
1. Question
1 pointsWhat is the shortcut to “paste” anything in MS Excel (or anything else in Microsoft Windows)?
Correct
Incorrect
Most shortcuts are with CTRL in addition to one or 2 other keys.
SHIFT + “letter” gives you a capital letter…
The absolutely unavoidable shortcuts are
Copy: CTRL + C
Paste: CTRL + V
Cut: CTRL + X
Bold: CTRL + B
Italic: CTRL + I
Underlined: CTRL + U
Undo: CTRL + Z
Redo: CTRL + Y
Select All: CTRL + A
Save: CTRL + S
Find: CTRL + F
etc….

Question 2 of 15
2. Question
1 pointsWhy is the cell B4 in red and between parenthesis?
Correct
Incorrect
This is just one of the options to FORMAT CELLS as NUMBERS.

Question 3 of 15
3. Question
1 pointsWhy is this formula not going to work when pressing ENTER?
Correct
Incorrect
A formula cannot start with anything else than a “=”, “+” or “” sign. Otherwise it will not process the calculation…
In addition, the formula MULTIPLY() does not exist.

Question 4 of 15
4. Question
1 pointsIf I need the addition of A1 and C1 into B1, why is this formula not going to work?
Correct
Incorrect
Our formula processes the SUM of everything in the range from A1 to C1, which includes B1. But B1 is what we are looking for. We cannot be using B1 in the calculation. It is called a CIRCULAR REFERENCE and returns obviously an error.
The formula ADDITION() does not exist.
The formula SUM() should be used with a range of data (with a “:”) or a list of cells/numbers (separated with “,”).

Question 5 of 15
5. Question
1 pointsWhat would you do if you needed to have in the rest of column D the same formula as in D2?
Correct
Incorrect
To quickly reproduce a formula following a row or a column, you can grab and drag the bottom right corner of the initial cell in which you have the actual formula.
Copy/paste is longer.
Rewriting is even painfully longer!

Question 6 of 15
6. Question
1 pointsWhat is the purpose of “Conversion” in the formula shown in cell E2?
Correct
Incorrect
Functions always have parenthesis and CONVERSION() does not exist.
The feature that changes the display of data from vertical to horizontal or vice and versa is called TRANSPOSE.
The picture shows a tab called “Conversion” which gives you an additional tip…

Question 7 of 15
7. Question
1 pointsWhat is the use of the inverted triangles on the first line of the spreadsheet above?
Correct
Incorrect

Question 8 of 15
8. Question
1 pointsIn the example above where percentages of growth between Year 1 and Year 2 are either in green or in red, what Excel feature has been used to make those colors change automatically depending on the value of the cell?
(Here in red for negative percentages and green for positive ones)
Correct
Incorrect
This is just called CONDITIONAL FORMATTING…
FORMAT CELLS will not change color automatically.
AUTOMATIC FILTER sorts and filters column following the criteria you decide.
The other options do not exist.

Question 9 of 15
9. Question
1 pointsWhat is the Excel feature that corresponds to what we see on the image above?
(Feature that makes us jump from line 1 to 8 and from column A to D leaving 2 thicker and darker lines.)
Correct
Incorrect

Question 10 of 15
10. Question
1 pointsIn the example above, what type of formula was used in B3 to display automatically the price of the “wanted product” (cell A2) from the price list (columns D and E)?
Correct
Incorrect
Vlookup() means vertical lookup. You use it to search for a value in the first column of a table array and it returns a value in the same row from another column in the table array.

Question 11 of 15
11. Question
1 pointsYou are given the database above and you need to quickly get the total sales per Account and per city. What do you do?
Correct
Incorrect
 Grouping groups rows or columns together and creates a “+” or a “” in the margin to expand or collapse the grouped rows or columns
 Vlookp() was already explained
 SUM() is too simple
 FIND() searches a string of characters within a usually larger string of characters
 CONDITIONAL FORMATTING was already explained

Question 12 of 15
12. Question
2 pointsSomething is missing in D2 so that you can drag the formula in the rest of column D. How should my formula be written?
Correct
Incorrect
Using a “$” sign in front of the column letter or the row number locks respectively the column or the row when dragging the formula.
In this example, we only need to lock the row 3 of our exchange rate, but not the rows or columns of B2 and C2.
In conclusion, we absolutely need a “$” in front the 3 and no “$” sign in B2*C2.

Question 13 of 15
13. Question
3 pointsIf we drag this formula from E2 to E7, what are those 6 cells going to display?
Correct
Incorrect
We have 2 functions combined: IF() and AND().
If the conditions of function IF() is true, then the formula displays “Bonus”, if not, it displays nothing.
The condition is an AND() function, which means that several conditions (2 here) have to be met for the overall condition to be true.
The 2 conditions are here that (1) we need to be in the “motorcycle” category and (2) we need to have a growth from Year 1 to Year 2.

Question 14 of 15
14. Question
3 pointsWhat is the growth percentage of our sales from Year 1 to Year 2?
Correct
Incorrect

Question 15 of 15
15. Question
3 points[IMPORTANT: There are 2 good answers to this questions. You need to check both of them to get it correct! Cell formatting may be needed afterwards to display properly the % sign]
What should you exactly type in C2 character by character in order for Excel to calculate the percentage of growth from Year 1 to Year 2?
Correct
Incorrect