Beginner Excel Test

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

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

No specific position, it's randomly align

To the left of the cell

To the middle of the cell

To the right of the cell

2 / 10

How to capitalize only the first letters?

No formula in Excel

=PROPER(A2)

=UCASE(A2)

=UPPER(A2)

3 / 10

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

=MULTIPLY(B2;C2)

=B2*(1+C2)

=B2*C2

=B2^C2

4 / 10

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

5 / 10

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

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

Write the formula =MONTH(A1)+1

Write the first month and use the fill-handle

Write each month one-by-one

6 / 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

7 / 10

Which function returns a list of unique values?

=EXTRACT(A2:A11)

=UNIQUE(A2:A11)

=DUPLICATE(A2:A11)

=WITHOUT.DUPLICATE(A2:A11)

8 / 10

How to extract the first 4 characters of each cell?

=TEXT(A2,4)

=RIGHT(A2,-4)

=LEFT(A2,4)

=LEN(A2)-4

9 / 10

How to add 7 days to cell A1?

=DATE(A1)+7

=A1+7

=DATE(A1)+DAY(7)

=DAY(A1)+7

10 / 10

Which formula returns the number of characters in a cell?

=COUNTCHAR(A2)

=CHAR(A2)

=LEN(A2)

=LENGTH(A2)

Your score is

The average score is 42%

Beginner Excel Test

Most Viewed Posts