Excel Exercise
RSS
Learning Excel
1-Excel Keywords
2-First Calculation
3-Number Format
4-Formula with cell reference
5-Function SUM
6-Copy Paste
7-Reference with Dollar
8-Fill Series
9-Quiz for beginner
Quizzes
Quiz Excel for Beginners
Quiz Excel for Advanced Users
Quiz Excel for Expert Users
Quiz Excel Keywords
Quiz Excel Shortcuts
Exercises
Functions
Tips and Tricks
Pivot Table
Contact
French
Most Viewed Posts
Displaying Negative Numbers in Parentheses – Excel
(261,115)
How to make automatic calendar in Excel
(161,515)
Dash for 0 in Excel
(133,273)
Convert YYYYMMDD to DD/MM/YYYY
(117,390)
Date Format in Excel
(113,316)
Excel Split Date and Time
(91,469)
How to calculate VAT in Excel?
(89,050)
Exchange rate in Excel
(81,137)
UNIQUE Function – Remove duplicates with formulas
(67,903)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,905)
Quiz Excel for Advanced Users
Start
<<
1
2
3
4
5
6
7
8
9
10
>>
1.
Which formula calculates the percentage increase between 2 months?
=(B2-B3)/B3
=B2-B3/B3
=B3-B2/B3
=(B3-B2)/B2
2.
What result returns the formula =SUMIF(A2:A9,B10,C2:C9)
5
13
16
11
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?
=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?
=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:
Loading...
Recent Posts
Calculate Quarter with Excel
Move a cell with the mouse in Excel
Change the language of Excel
Excercise for beginners: Create a drop-down menu
Excercise for beginner: Create an Invoice with Excel
{"mobile_concate":{"mobile-menu":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/mobile-menu.min.css"},"tf_base":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/base.min.css","v":"7.1.1"},"themify_common":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify.common.min.css","v":"7.1.1"},"builder-styles-css":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/themify-builder-style.min.css","v":"7.1.1"},"tb_tbp":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.min.css","v":"3.0.8"},"tf_theme_site-logo":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.min.css","v":"7.1.1"},"tf_theme_site-description":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-description.min.css","v":"7.1.1"},"tf_search_form":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.min.css","v":"7.1.1"},"tb_post-content":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.1.1"},"wp-block-library":{"s":"https:\/\/www.excel-exercise.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"6.2"},"tb_image":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.min.css","v":"7.1.1"},"tb_app":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/appearance.min.css","v":"7.1.1"},"tb_image_top":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image_styles\/top.min.css","v":"7.1.1"},"tb_text":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.1.1"},"theme-style":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/style.min.css","v":"7.1.1"},"themify-media-queries":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/media-queries.min.css","v":"7.1.1","m":"(max-width:1200px)"}}