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,213)
How to make automatic calendar in Excel
(160,732)
Dash for 0 in Excel
(132,727)
Convert YYYYMMDD to DD/MM/YYYY
(116,805)
Date Format in Excel
(112,672)
Excel Split Date and Time
(90,866)
How to calculate VAT in Excel?
(88,662)
Exchange rate in Excel
(80,631)
UNIQUE Function – Remove duplicates with formulas
(67,382)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,483)
Quiz Excel for Expert Users
Start
<<
1
2
3
4
5
6
7
8
9
10
>>
1.
Which statistics function returns the most frequent value in a list of values?
=RANK(B2:E11)
=MODE.SNGL(B2:E11)
=STDEV.S(B2:E11)
=FREQUENCY(B2:E11)
2.
Which custom conditional formatting formula colors the weekends with a different color?
=WEEKDAY(A1)<5
=WEEKDAY(A$1;2)>5
=WEEKDAY(A1)>5
=IF(WEEKDAY(A1)>5;TRUE;FALSE)
3.
Which custom number format code displays negative numbers in parentheses?
(0)
# ##0,00;''(''# ##0,00'')''
(# ##0,00)
# ##0,00;(# ##0,00)
4.
Which formula counts the number of rows for men with an income greater than 40000
=COUNTIFS(''No'';D2:D13;>=400000;F2:F13)
=COUNTIFS(D2:D12;''No'';F2:F13;''>=40000'')
=COUNTIFS(D2:D13;''No'';F2:F13;''>=40000'')
=COUNTIFS(D2:D13;''No'';F2:F13;>=40000)
5.
Which statistical function should be associated with the average to know the dispersion around the mean?
STDEV
QUARTILE
MODE.SNGL
FREQUENCY
6.
Which function allows you to find the position of an element in a list, for example, the rank of Friday in the list of weekdays?
MATCH
INDIRECT
INDEX
RANK
7.
Which formula adds 5 hours to cell A1?
=A1+TIME(5;0;0)
=A1+5
=A1+TIME(0;5;0)
=A1+5/24
8.
Which formula allows you to add only 10% to the price of cookies under 5$?
=SI(B2=''Coockies''+ET+C2<5;C2*1,1;C2)
=SI(B2=''Coockies''+C2<5;C2*1,1;C2)
=SI(ET(B2=''Coockies'');ET(C2<5);C2*1,1;C2)
=SI(ET(B2=''Coockies'';C2<5);C2*1,1;C2)
9.
Which formula allows you to find the number of
unmarried men
?
=COUNTIFS(''Man'';A2:A13;''No'';D2:D13)
=COUNTIFS(A2:A13;''Man'';D2:D13;''No'')
=COUNTIFS(A2:A13;''Man'';D2:D13;''Unmarried'')
=COUNTIF(A2:A13;''Man'';D2:D13;''No')
10.
Which formula finds the number of lines with negative temperatures?
=COUNTIF(B2:B13;-0)
=COUNTIF(B2:B13;''<0'')
=COUNTIF(''<0'';B2:B13)
=SUMIF(B2:B13;-0)
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)"}}
