Beginner Excel Test

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

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

2 / 10

How to round up to the first decimal

=ROUNDUP(A2,1)

=ROUNDUP(A2,-1)

=ROUND(A2,1)

=INT(A2)

3 / 10

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

Alt+=

Ctrl+S

Ctrl+Alt+S

Ctrl+Shift+S

4 / 10

How to extract the first 4 characters of each cell?

=TEXT(A2,4)

=LEN(A2)-4

=RIGHT(A2,-4)

=LEFT(A2,4)

5 / 10

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

Write the formula =MONTH(A1)+1

Write each month one-by-one

Write the first month and use the fill-handle

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

6 / 10

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

=B1-B2

=MINUS(B1,B2)

=B1+B2

=B2-B1

7 / 10

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

=B2*(1+C2)

=MULTIPLY(B2;C2)

=B2*C2

=B2^C2

8 / 10

Which answer DOESN'T return 20%?

0.2

20%

0.2%

=20/100

9 / 10

How to write the SUM formula when working with Tables?

=SUM(Table1[Valeur])

=SUM(Table1''Valeur'')

=SUM(Table1{Valeur})

=SUM(Table1!Valeur)

10 / 10

Which formula returns the number of characters in a cell?

=COUNTCHAR(A2)

=LENGTH(A2)

=CHAR(A2)

=LEN(A2)

Your score is

The average score is 42%

Beginner Excel Test

Most Viewed Posts