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,124)
How to make automatic calendar in Excel
(161,525)
Dash for 0 in Excel
(133,277)
Convert YYYYMMDD to DD/MM/YYYY
(117,396)
Date Format in Excel
(113,323)
Excel Split Date and Time
(91,478)
How to calculate VAT in Excel?
(89,057)
Exchange rate in Excel
(81,140)
UNIQUE Function – Remove duplicates with formulas
(67,907)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,910)
Exercise for beginners #1: Use the cells in your calculation
In
this
exercise,
we
will
see
how
to
work
correctly
with
Excel
.
We will see
How
to
enter
numbers
in
a
cell
How
to
do
calculations
with
numbers
How
to
do
calculations
with
cell
references
and
how
to
use
Excel
'
s
built
-
in
functions
Start
<<
1
2
3
4
5
6
7
>>
1.
In cell B3, write the number of sales for January (10,000) and do the same for February (9,500) and March (10,500)
=$10000$
=NUMBER(10000)
=10000
10000
Loading...
2.
The price for the shop rent is 24,000 for the whole year.
What formula should you write in B3 to calculate the rent for each month?
1500
2000
=DIVIDE(24000;12)
=24000/12
Loading...
3.
The amount of the Salary is 5000 in January.
The amount for February and March is equivalent to January. This means if the value of January changes, the result for February and March will change automatically.
How do you write the formula in this situation?
=COPY(B4)
=B4
=B4+5000
=5000
Loading...
4.
The expenses for water and electricity are equal to 10 percent of the sales
How to write the formula for January, February and March?
=B2*10%
=B5*10%
=B2*10
=B2/10%
Loading...
5.
The total of the expenses for January is the sum of the 3 cells' rent, salary, and electricity. What is the formula?
When it's done, copy the formula for February and March.
=B3+B4+B5
=B2+B3+B4
=B3+B4
=SUM(B2)+SUM(B3)+SUM(B4)
Loading...
6.
The global Result (in B7) is the
difference between the number of Sales and the Total Expenses
. How do you write the formula?
=B2-B6
=B6-B2
=10000-8000
=B2+B6
Loading...
7.
To
finish
we
will
calculate
the
number
of
sales
and
expenses
for
Quarter
1. Here, we will use our first Excel functions
What is the formula in E2?
=SUM(B2;D2)
=SUM(B2,D2)
=SUM(B2.D2)
=SUM(B2:D2)
Loading...
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)"}}
