Beginner Excel Test

140

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

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

=B2^C2

=B2*C2

=MULTIPLY(B2,C2)

=B2*(1+C2)

2 / 10

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

=SEQUENCE(10,,0,5)

Write each value one by one

Write the 2 first values and use the fill-handle

=RETP(0,5)

3 / 10

Which formula returns the number of characters in a cell?

=CHAR(A2)

=LEN(A2)

=COUNTCHAR(A2)

=LENGTH(A2)

4 / 10

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

Ctrl + Enter

Enter

Alt + Enter

Shift + Enter

5 / 10

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

Ctrl+S

Ctrl+Alt+S

Ctrl+Shift+S

Alt+=

6 / 10

Which Excel tool allows you to insert a drop-down menu in a cell?

Insert > Object

Data > Data Validation

Data > Dropdown list

Insert > Dropdown list

7 / 10

What is the result returned by the formula in B7?

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 function returns a list of unique values?

=UNIQUE(A2:A11)

=WITHOUT.DUPLICATE(A2:A11)

=EXTRACT(A2:A11)

=DUPLICATE(A2:A11)

10 / 10

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

Your score is

The average score is 38%

Beginner Excel Test

Most Viewed Posts