Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
French

Quiz Excel for Advanced Users

1. What is the name of this chart?

Population pyramid

Stairs

Christmas tree

spiral

2. Which feature understands the text transformations you want to do and applies it to the rest of your data?

Fill Series

Automatic Fill

Magic Fill

Flashfill

3. Which formula build to know if 2 cells are identical?

=A2=B2

=SAME(A2;B2)

=EQUAL(A2;B2)

=COMPARE(A2;B2)

4. Which custom Time format must be applied to display the hours over 24H?

[h]:mm

(h:mm)

hhh:mm

(h):mm

5. Which tool allows you to change the color of cells automatically according to their values (here the 10 highest values)?

Fill Color

Chromatic tool

Conditional Formatting

Color Chart

6. What formula should be written to display the word "Out of Office" when the hours worked in column B are empty?

=IF(ISEMPTY(B2),''Out of Office'','''')

=ISEMPTY(B2)

=IF(ISEMPTY(B2),'''',''Out of Office'')

=IF(ISEMPTY(B2),''Out of Office'')

7. Which formula removes spaces before and after text in a cell?

Question remove the space at the beginning

=NO.SPACE(A2)

=SPACE(A2)

=CLEAN(A2)

=TRIM(A2)

8. What result returns the formula =SUMIF(A2:A9,B10,C2:C9)

Question result returns by the SUMIF function

9. Which custom format number displays a negative number in parenthesis?

Question negative number in parenthesis 2

#,##0.00,(#,##0.00)

#,##0.00;(#,##0.00)

#,##0.00;-(#,##0.00)

(#,##0.00)

10. Which Excel function returns the week number according to the European and Asian rule

=WEEKNUM(B2,2)

=ISOWEEKNUM(B2,2)

=WEEKNUM(B2)

=ISOWEEKNUM(B2)

Your email address:

Your name:

Most Viewed Posts

Quiz Excel for Advanced Users

Recent Posts