Beginner Excel Test

701

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

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

Alt + Enter

Ctrl + Enter

Enter

Shift + Enter

2 / 10

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

3 / 10

What is the result returned by the formula in B7?

4 / 10

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

No specific position, it's randomly align

To the middle of the cell

To the left of the cell

To the right of the cell

5 / 10

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

Ctrl+Shift+S

Ctrl+S

Ctrl+Alt+S

Alt+=

6 / 10

Which answer DOESN'T return 20%?

0.2%

20%

0.2

=20/100

7 / 10

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

Write the first month and use the fill-handle

Write the formula =MONTH(A1)+1

Write the formula =TEXT(A1,"mmmm")

Write each month one-by-one

8 / 10

How to capitalize only the first letters?

=PROPER(A2)

No formula in Excel

=UPPER(A2)

=UCASE(A2)

9 / 10

How to round up to the first decimal

=ROUND(A2,1)

=ROUNDUP(A2,-1)

=INT(A2)

=ROUNDUP(A2,1)

10 / 10

How to write the SUM formula when working with Tables?

=SUM(Table1{Value})

=SUM(Table1!Value)

=SUM(Table1"Value")

=SUM(Table1[Value])

Your score is

The average score is 45%

Beginner Excel Test

Most Viewed Posts