0 of 15 questions completed
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.
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:
0 of 15 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
Thank you for your time!
To review the questions with your answers, please click on VIEW QUESTIONS.
Question 1 of 15
1. Question1 points
What is the shortcut to “paste” anything in MS Excel (or anything else in Microsoft Windows)?Correct
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
Question 2 of 15
2. Question1 points
Why is the cell B4 in red and between parenthesis?Correct
This is just one of the options to FORMAT CELLS as NUMBERS.
Question 3 of 15
3. Question1 points
Why is this formula not going to work when pressing ENTER?Correct
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. Question1 points
If I need the addition of A1 and C1 into B1, why is this formula not going to work?Correct
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. Question1 points
What would you do if you needed to have in the rest of column D the same formula as in D2?Correct
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.
Re-writing is even painfully longer!
Question 6 of 15
6. Question1 points
What is the purpose of “Conversion” in the formula shown in cell E2?Correct
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. Question1 points
What is the use of the inverted triangles on the first line of the spreadsheet above?Correct
Question 8 of 15
8. Question1 points
In 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
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. Question1 points
What 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
Question 10 of 15
10. Question1 points
In 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
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. Question1 points
You are given the database above and you need to quickly get the total sales per Account and per city. What do you do?Correct
- 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. Question2 points
Something is missing in D2 so that you can drag the formula in the rest of column D. How should my formula be written?Correct
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. Question3 points
If we drag this formula from E2 to E7, what are those 6 cells going to display?Correct
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. Question3 points
What is the growth percentage of our sales from Year 1 to Year 2?Correct
Question 15 of 15
15. Question3 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