Beginner Excel Test

380

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

How to capitalize only the first letters?

No formula in Excel

=PROPER(A2)

=UCASE(A2)

=UPPER(A2)

2 / 10

What is the result returned by the formula in B7?

3 / 10

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

Write each value one by one

=RETP(0,5)

=SEQUENCE(10,,0,5)

Write the 2 first values and use the fill-handle

4 / 10

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

=B2*(1+C2)

=B2^C2

=B2*C2

=MULTIPLY(B2,C2)

5 / 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 right of the cell

To the middle of the cell

6 / 10

How to round up to the first decimal

=ROUNDUP(A2,-1)

=ROUND(A2,1)

=ROUNDUP(A2,1)

=INT(A2)

7 / 10

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

=MINUS(B1,B2)

=B1-B2

=B1+B2

=B2-B1

8 / 10

How to write the SUM formula when working with Tables?

=SUM(Table1{Value})

=SUM(Table1!Value)

=SUM(Table1"Value")

=SUM(Table1[Value])

9 / 10

Which formula returns the number of characters in a cell?

=LENGTH(A2)

=COUNTCHAR(A2)

=LEN(A2)

=CHAR(A2)

10 / 10

Which answer DOESN'T return 20%?

0.2

20%

0.2%

=20/100

Your score is

The average score is 44%

Beginner Excel Test

Most Viewed Posts