Beginner Excel Test

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

How to extract the first 4 characters of each cell?

=TEXT(A2,4)

=LEFT(A2,4)

=RIGHT(A2,-4)

=LEN(A2)-4

2 / 10

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

Ctrl+S

Ctrl+Alt+S

Ctrl+Shift+S

Alt+=

3 / 10

Which result is returned by the function =COUNT(B2:D5)?

4 / 10

What is the result returned by the formula in B7?

5 / 10

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

To the middle of the cell

To the right of the cell

No specific position, it's randomly align

To the left of the cell

6 / 10

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

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

Write the first month and use the fill-handle

Write the formula =MONTH(A1)+1

Write each month one-by-one

7 / 10

Which formula returns the number of characters in a cell?

=COUNTCHAR(A2)

=CHAR(A2)

=LEN(A2)

=LENGTH(A2)

8 / 10

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

=RETP(0,5)

Write the 2 first values and use the fill-handle

=SEQUENCE(10,,0,5)

Write each value one by one

9 / 10

How to add a break-line in a cell to write your text on 2 lines?

Enter

Ctrl + Enter

Shift + Enter

Alt + Enter

10 / 10

Which function returns a list of unique values?

=EXTRACT(A2:A11)

=WITHOUT.DUPLICATE(A2:A11)

=UNIQUE(A2:A11)

=DUPLICATE(A2:A11)

Your score is

The average score is 41%

Beginner Excel Test

Most Viewed Posts