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
French
Most Viewed Posts
Displaying Negative Numbers in Parentheses – Excel
(260,701)
How to make automatic calendar in Excel
(161,191)
Dash for 0 in Excel
(133,038)
Convert YYYYMMDD to DD/MM/YYYY
(117,129)
Date Format in Excel
(113,026)
Excel Split Date and Time
(91,206)
How to calculate VAT in Excel?
(88,871)
Exchange rate in Excel
(80,872)
UNIQUE Function – Remove duplicates with formulas
(67,667)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,713)
Quiz Excel for Advanced Users
Start
<<
1
2
3
4
5
6
7
8
9
10
>>
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?
=NO.SPACE(A2)
=SPACE(A2)
=CLEAN(A2)
=TRIM(A2)
8.
What result returns the formula =SUMIF(A2:A9,B10,C2:C9)
5
16
11
13
9.
Which custom format number displays a negative number in parenthesis?
#,##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:
Loading...
Recent Posts
Move a cell with the mouse in Excel
Excercise for beginners: Create a drop-down menu
Excercise for beginner: Create an Invoice with Excel
Exercise for beginners: functions SUM, MIN, MAX Excel
Exercise for beginners: Dollars in Excel Formula
{"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)"}}