Tutorials References Exercises Get Certified Sign In
MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA
Great job! You have successfully calculated the SUM using the SUM function.
Iva, Liam and Adora have 33 Pokeballs in total.
Let's change a value to see what happens. Type B2(7) :
The value in cell B2 was changed from 2 to 7 . Notice that the formulas are doing
Tutorials References Exercises Get Certified
calculations when we change the value in the cells, and the SUM is updated from 33 to 38 . It
Sign In
allows us toJQUERY
MYSQL change values that are
EXCEL used by
XML the formulas,
DJANGO and the calculations
NUMPY PANDAS remain.
NODEJS DSA
Chapter Summary
Values used in formulas can be typed directly and by using cells. The formula updates the
result if you change the value of cells, which is used in the formula. The fill function can be
used to continue your formulas upwards, downwards and sidewards. Excel has pre-built
functions, such as SUM.
In the next chapter you will learn about relative and absolute references.
Test Yourself With Exercises
Excel Exercise:
Complete the Excel formula:
8+10
Submit Answer »
Start the Exercise
❮ Previous Sign in to track progress Next ❯
Tutorials References Exercises Get Certified Sign In
MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA
COLOR PICKER
REMOVE ADS
PLUS SPACES
Tutorials References
GET CERTIFIED
Exercises
FOR TEACHERS
Get Certified Sign In
MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA
FOR BUSINESS CONTACT US
Top Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
How To Tutorial
SQL Tutorial
Python Tutorial
[Link] Tutorial
Bootstrap Tutorial
PHP Tutorial
Java Tutorial
C++ Tutorial
jQuery Tutorial
Top References
HTML Reference
CSS Reference
JavaScript Reference
SQL Reference
Python Reference
[Link] Reference
Bootstrap Reference
PHP Reference
HTML Colors
Java Reference
AngularJS Reference
jQuery Reference
Top Examples Get Certified
HTML Examples HTML Certificate
CSS Examples CSS Certificate
JavaScript Examples JavaScript Certificate
How To Examples Front End Certificate
SQL Examples SQL Certificate
Python Examples Python Certificate
[Link] Examples PHP Certificate
Bootstrap Examples jQuery Certificate
PHP Examples Java Certificate
Java Examples C++ Certificate
XML Examples C# Certificate
jQuery Examples XML Certificate
Tutorials References
FORUM ABOUT
Exercises
ACADEMY
Get Certified
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and
Sign In
learning.
MYSQL JQUERY
Tutorials, EXCEL
references, XML
and examples DJANGO
are constantly NUMPY
reviewed to PANDAS
avoid errors, but NODEJS
we cannot warrant full DSA
correctness
of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and
privacy policy.
Copyright 1999-2025 by Refsnes Data. All Rights Reserved. W3Schools is Powered by [Link].