﻿ Excel 2007 exercises-Basic calculations SUM function

# Excel 2007 exercises-Basic calculations SUM function

## Basic calculations

In this exercise, you will learn to perform calculations on cells, and use sum function to calculate the total values.

1.Calculate the revenue of each sale
In cell F3, write the formula:
=(C3*D3)-(C3*D3)*E3
Press Enter and click to drag it until the last cell of the data sheet
2.Calculate the total revenue
In cell F10 write the formula:
=SUM(F3:F9)
Press Enter and click to drag it until the last cell of the data sheet
3.Calculate the net income of each sale
In cell H3, write the formula:
=F5-(F5*2/100)
Press Enter and click to drag it until the last cell of the data sheet
4.Calculate the total net income
In cell H10, write the formula:
=SUM(H3:H9)
Press Enter and click to drag it until the last cell of the data sheet

Syntax:
SUM(number1,number2, ...)

### Comments

 sarithahi, in this assignment i got a doubt for the last question i.e., calculate total net income of products of order id 10260 is = sumif(A5:H13,A7,H5:H13)--- can anyone tell me is this is the right formula?2017-09-21 sarithahi, in this assignment i got a doubt for the last question i.e., calculate total net income of products of order id 10260 is = sumif(A5:H13,A7,H5:H13)--- can anyone tell me is this is the right formula?2017-09-21 sarithahi, i got the column G - the formula is =f5*2%, now im doing with count function2017-09-21 sarithahi, i got the column G - the formula is =f5*2%, now im doing with count function2017-09-21 sarithahi, i could not understand , what about the column G2017-08-31 Ravinder Choprafrom where should i download this excel excersises can somebody help ?????????2017-06-30 AyeshaI just have a glanced look over these exercises I think i'll practice a lot through it. Thanks for your help. 2017-06-19 GeekCheekHi.... You should provide some sample dump or something like that for ppl to try out these tutorials... you know just in case if they havent got one?! i hope you do.....2016-11-23 LucciThank you so much, I am just learning excel, and your lessons helped me so much! MUCH LOVE, and peace 2016-05-24 smitha jayakumarvery good excercises2016-04-06 furqanGreat work to help beginners. Thanks2015-11-06 HendrixWow this is amazing!2015-11-02 mahmoud mahmad sadiekthanks a lot man really its amazing ex for practicing 2015-03-10 SadaThanks for useful excel exercises.2015-01-12

This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.