Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
Contact
French

Quiz Excel for Advanced Users

1. Which formula calculates the percentage increase between 2 months?

Percentage increase and decrease with conditional formatting

=(B2-B3)/B3

=B2-B3/B3

=B3-B2/B3

=(B3-B2)/B2

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

Question result returns by the SUMIF function

3. 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'')

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

=ISEMPTY(B2)

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

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

Question remove the space at the beginning

=TRIM(A2)

=NO.SPACE(A2)

=SPACE(A2)

=CLEAN(A2)

5. Which formula allows you to return the number of rows corresponding to Men?

=COUNT(A2:A13)=''Man''

=COUNTIF(A2:A13)=''Man''

=COUNTIF(''Man'',A2:A13)

=COUNTIF(A2:A13,''Man'')

6. Which custom format code returns the date in A1?

d ddd mmmm yyyy

''Wed'' dd mm yy

dd dd mmm yyyy

ddd dd mmmm yyyy

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

Fill Series

Magic Fill

Automatic Fill

Flashfill

8. Which formula should be used to calculate the prices including all taxes using the reference of cell C1?

Question formula to calculate the price and tax

=B4*1+$C$1

=B4*(1+C1)

=B4*C1

=B4*(1+$C$1)

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

=EQUAL(A2;B2)

=SAME(A2;B2)

=COMPARE(A2;B2)

=A2=B2

10. What is the name of this chart?

Donuts

Sunburst

Multi-pie chart

Treemap

Your email address:

Your name:

Most Viewed Posts

Quiz Excel for Advanced Users

Recent Posts