#### Quiz-summary

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)?

CorrectIncorrectMost 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?

CorrectIncorrectThis 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?

CorrectIncorrectA 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?

CorrectIncorrectOur 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?

CorrectIncorrectTo 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. Question

1 pointsWhat is the purpose of “Conversion” in the formula shown in cell E2?

CorrectIncorrectFunctions 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?

CorrectIncorrect - 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)

CorrectIncorrectThis 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.)

CorrectIncorrect - 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)?

CorrectIncorrectVlookup() means

. 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.*vertical lookup* - 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?

CorrectIncorrect- 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?

CorrectIncorrectUsing 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?

CorrectIncorrectWe 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?

CorrectIncorrect - 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?CorrectIncorrect