Excel Exercise
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
post
RSS
Learning Excel
1-Excel Keywords
2-First Calculation
3-Number Format
4-Formula with cell reference
5-Function SUM
6-Copy Paste
7-Exercise with SUM, MIN and MAX
8-Reference with Dollar
9-Fill Series
10-Quiz for beginner
Practise Excel
1. Build Logical Test
2. Exercise on logical tests
3. The functions AND or OR
4. Exercise with AND and OR
5. The IF Function
6. Count rows with COUNTIFS
7. Sum on specific criteria with SUMIFS
Quizzes
Quiz Excel for Beginners
Quiz Excel for Advanced Users
Quiz Excel for Expert Users
Quiz Excel Keywords
Quiz Excel Shortcuts
Exercises
Most useful Functions
Tips and Tricks
Contact
French
ARTICLES LES PLUS VUS
Displaying Negative Numbers in Parentheses – Excel
(269,603)
The 10 most useful Excel Functions in 2023
(198,342)
How to make automatic calendar in Excel
(168,384)
Dash for a zero in Excel
(138,136)
Convert YYYYMMDD to DD/MM/YYYY with Excel
(123,205)
Date Format in Excel
(118,955)
Excel Split Date and Time
(97,020)
How to calculate VAT in Excel?
(92,871)
Function XLOOKUP in Excel
(87,746)
Exchange rate in Excel
(85,918)
UNIQUE Function – Remove duplicates with formulas
(72,461)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(67,900)
Comma or Semicolon in an Excel formula
(63,502)
Add Emojis to your charts, formulas
(63,349)
How to Compare 2 Columns in Excel
(58,214)
Change the default Date format in Excel
(56,827)
SUMIFS Function in Excel
(50,337)
COUNTIFS – Count rows automatically in Excel
(47,714)
Dynamic SUM in Excel
(47,389)
Add filter option for all your pivot table columns
(47,011)
How to display hours over 24 in Excel?
(40,857)
Anonymise your data
(38,014)
First day – Last day in Excel
(34,849)
Round to the Nearest Tenth, Hundredth with Excel
(33,491)
Find Weekends or weekdays in Excel
(31,691)
Title with date in Excel
(30,727)
Population Pyramid with Excel
(30,384)
XLS vs XLSX file format?
(30,307)
VLOOKUP to the left in Excel
(27,636)
How to Link Excel to Google Maps
(27,484)
Exercise: Calculate the income of the week
In this exercise, we will create formulae to calculate the income for the week.
Start
This quiz must be completed in 15 minutes.
900
In this exercise, we will create formulae to calculate the income for the week.
Start
0%
Loading...
Recent Posts
Excel formula to Extract the Worksheet Name
Move cells with the mouse in Excel
How AI can be used in Excel for your data?
Build a nested IF in Excel
Return a result between 2 values
Add progress bar in your cells
Copy the formula and not the formatting in Excel
How to Highlight Min and Max values in Excel
Excel Dropdown list – Excluding Previously Selected Items
Why VLOOKUP returns #N/A?
In Excel, How to highlight missing values?
How to highlight the Min and Max in Excel?
Conditional Formatting – Color scale
Exercise with the AND and OR functions in Excel
Exercise: Calculate the income of the week
{"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.3.1"},"themify_common":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify.common.min.css","v":"7.3.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.3.1"},"tb_tbp":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.min.css","v":"3.1.2"},"tf_theme_site-logo":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.min.css","v":"7.1.4"},"tf_theme_site-description":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-description.min.css","v":"7.1.4"},"tf_search_form":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.min.css","v":"7.3.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.3.1"},"wp-block-library":{"s":"https:\/\/www.excel-exercise.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"6.3.1"},"tb_image":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.min.css","v":"7.3.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.3.1"},"tb_text":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.3.1"},"theme-style":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/style.min.css","v":"7.1.4"},"themify-media-queries":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/media-queries.min.css","v":"7.1.4","m":"(max-width:1200px)"}}