Scribd
Upload
47 views3 pages

Excel 2007 Basic Calculation Guide

The document contains an order details table listing products with prices, quantities, discounts and revenue. It provides calculations to perform including: calculating revenue and tax for each product; calculating net income of each product and totals; counting number of products and those for a specific order ID; and calculating total net income for an order ID.

Uploaded by

Monic Vidal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
47 views3 pages

Excel 2007 Basic Calculation Guide

The document contains an order details table listing products with prices, quantities, discounts and revenue. It provides calculations to perform including: calculating revenue and tax for each product; calculating net income of each product and totals; counting number of products and those for a specific order ID; and calculating total net income for an order ID.

Uploaded by

Monic Vidal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Ms.

Excel 2007 exercise basic calculations


Order Details
ADD
Tax(2 %
for each
Order ID Product Unit Price Quantity Discount Revenu order)
10259 Sir
Rodney's 8 100 35% 520 10.4
Scones
10259 Gravad 20.8 1
0%
lax ? ?
10260 Jack's 7.7 16
New
England 20%
Clam
Chowder
? ?
10260 Ravioli 15.6 50
35%
Angelo ? ?
10260 Tarte au 39.4 15
20%
sucre ? ?
10260 Outback 12 21
20%
Lager ? ?
10261 Sir 8 20 0%
Rodney's
Scones ? ?
10261 Steeleye 14.4 20 0%
Stout ? ?
10262 Chef 17 12 20%
Anton's
Gumbo
Mix ? ?
Total: ?
1. Calculat the revenue and tax on the revenue for earch product
2. Calculate the net come of each product
3. Calculate the total revenue of all products
4. Calculate the total net income of all products
5. Count the number of products in the list above
6. Count the number of products of Order ID 10260
7. Calculate the total net income of products of Order ID 10260
Total

530.4

?
?
Add 2%
Amount 2% Total
9 0.18 9.18 -9
70 1.4 71.4
67 1.34 68.34
34 0.68 34.68

You might also like