Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
Contact
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 result returned by the formula in B7?

2. Which formula returns the number of characters in a cell?

=CHAR(A2)

=COUNTCHAR(A2)

=LENGTH(A2)

=LEN(A2)

3. What is the shortcut that adds the SUM function in a cell?

Ctrl+Alt+S

Alt+=

Ctrl+Shift+S

Ctrl+S

4. When you write a number in a cell, what is the default alignment?

To the left of the cell

To the middle of the cell

To the right of the cell

No specific position, it's randomly align

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

=SUM(Table1''Valeur'')

=SUM(Table1{Valeur})

=SUM(Table1[Valeur])

=SUM(Table1!Valeur)

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

Question how to calculate the total of the sales

=B2*C2

=MULTIPLY(B2;C2)

=B2^C2

=B2*(1+C2)

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

=RIGHT(A2,-4)

=LEFT(A2,4)

=TEXT(A2,4)

=LEN(A2)-4

8. What formula should be written in B3 to make the difference between cells B1 and B2?

=B1-B2

=B1+B2

=B2-B1

=MINUS(B1,B2)

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

=SEQUENCE(10,,0,5)

Write the 2 first values and use the fill-handle

Write each value one by one

=RETP(0,5)

10. How to capitalize only the first letters?

=UCASE(A2)

=UPPER(A2)

=PROPER(A2)

No formula in Excel

Your email address:

Your name:

Most Viewed Posts

Quiz Excel for Beginners

Recent Posts