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,490)
How to make automatic calendar in Excel
(161,014)
Dash for 0 in Excel
(132,925)
Convert YYYYMMDD to DD/MM/YYYY
(117,005)
Date Format in Excel
(112,892)
Excel Split Date and Time
(91,067)
How to calculate VAT in Excel?
(88,783)
Exchange rate in Excel
(80,772)
UNIQUE Function – Remove duplicates with formulas
(67,562)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,630)
Exercise with SUM, MIN, MAX
In
this
exercise,
we
will
see
how
to
use the basic Excel functions. We will use
SUM
AVERAGE
MIN
MAX
Start
<<
1
2
3
4
5
6
7
>>
1.
In B11, which formula will return the sum of the items sold on Monday?
=B4+B5+B6+B7+B8+B9+B10
=SUM(B4:B10)
=SUBTOTAL(B4:B10)
=SUM(B4+B5+B6+B7+B8+B9+B10)
2.
How to calculate the number of items sold on Tuesday?
=SUM(C4:C10)
=B11
=COPY(B11)
=C4+C5+C6+C7+C8+C9+C10
3.
What formula can be used to determine the number of products A sold during the week?
=B4+C4+D4+E4+F4
=SUM(B4:F4)
=COLUMNS(B4:F4)
=ADD(B4:F4)
4.
What is the average number of items sold for each product?
=AVERAGE(B4:F4)
=AVERAGE(B4:G4)
=SUM(B4:F4)/5
=(B4:F4)/5
5.
What
is
the
minimum
quantity
of
products
sold
per
day?
=MIN(B4:B10)
=MINIMUM(B4:B10)
=MINUS(B4:B10)
=MIN(B4:B11)
6.
What
is
the
maximum
quantity
of
products
sold
per
day?
=MAX(B4:B11)
=MAXIMUM(B4:B10)
=MAX(B4:B10)
=MAXIMUS(B4:B10)
7.
Which formula will return the number of items sold during the week for all the products?
=SUM(B4:F10)
=SUM(B4:B10)+SUM(C4:C10)+SUM(D4:D10)+SUM(E4:E10)+SUM(F4:F10)
=SUM(B4:B10,C4:C10,D4:D10,E4:E10,F4:F10)
=GRANDTOTAL(B4:F10)
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)"}}
