Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
French

Quiz Excel for Beginners

Do you know Excel? This quiz will ask you 10 questions among 50 to evaluate your Excel level.

1. What is the best way to create a list of months?

Write the formula =MONTH(A1)+1

Write the first month and use the fill-handle

Write each month one-by-one

Write the formula =TEXTE(A1,''mmmm'')

2. What formula should be written to calculate total sales (for each product line)?

Question how to calculate the total of the sales

=B2*C2

=B2*(1+C2)

=MULTIPLY(B2;C2)

=B2^C2

3. How to capitalize only the first letters?

=UPPER(A2)

No formula in Excel

=PROPER(A2)

=UCASE(A2)

4. How to write the SUM formula when working with Tables?

=SUM(Table1[Valeur])

=SUM(Table1!Valeur)

=SUM(Table1{Valeur})

=SUM(Table1''Valeur'')

5. How to add 7 days to cell A1?

=A1+7

=DATE(A1)+DAY(7)

=DAY(A1)+7

=DATE(A1)+7

6. How to write a series of numbers quickly with the same steps? (2 answers)

=SEQUENCE(10,,0,5)

=RETP(0,5)

Write the 2 first values and use the fill-handle

Write each value one by one

7. Which Excel tool allows you to insert a drop-down menu in a cell?

Insert > Dropdown list

Data > Dropdown list

Insert > Object

Data > Data Validation

8. How to extract the first 4 characters of each cell?

=RIGHT(A2,-4)

=LEN(A2)-4

=LEFT(A2,4)

=TEXT(A2,4)

9. How to round up to the first decimal

=ROUNDUP(A2,1)

=INT(A2)

=ROUNDUP(A2,-1)

=ROUND(A2,1)

10. Which function returns a list of unique values?

=UNIQUE(A2:A11)

=WITHOUT.DUPLICATE(A2:A11)

=EXTRACT(A2:A11)

=DUPLICATE(A2:A11)

Your email address:

Your name:

Most Viewed Posts

Quiz Excel for Beginners

Recent Posts