Project 1: Spread sheet (excel)
1. Create spreadsheet and complete the following questions
No Customer name Amount 000.000br
asset liabilit capital income expense total
y
1 Agricultural industry 6000 2000
2 Automobile industry 7000 1500
3 Petroleum industry 8000 2200
4 Electrical industry 4500 2300
5 Petroleum industry 3900 1000
Sum
Min
Max
Average
Additional information’s to compute the remaining:
Capital =assetliability
Income = 15% of asset
Expense= 15% of liability
Total = capital + income–expense
2. Create a simple chart on the spreadsheet
9000
8000
7000
6000
5000
asset
4000 liability
capital
3000 income
expense
2000
total
1000
0
Project 2. Produce and complete Simple spreadsheet
1. On Microsoft Excel worksheet prepare the following & save it as Grade report in your folder
Students Name
Economic
Geograph
Phy. Edu.
Amharic
Average
History
RANK
Civic
Math
Total
Age
Eng
ICT
Sex
Abeba Bekele F 18 87 74 69 77 85 80 97 81 84
Alemu Kassa M 19 89 69 66 77 81 95 65 71 74
Zemezem Hussain F 18 58 60 45 66 58 59 40 51 68
Average
Minimum
maximum
1. Insert the following row’s data between Alemu and Zemzem.
Chaltu F 21 81 77 73 78 75 81 86 78 85
Tolosa
Tiblets F 21 82 70 72 78 73 80 89 79 86
Hagos
1. Complete the table using the excel functions.
2. Format the table as follows:
a. Font: Bookman Old style, Bold, 14, Red color
b. Alignment: left aligned
c. Border: line color(blue),
3. Prepare a chart using students Name and Average columns of save it as in sheet2. Chart title:
Grade report
X-axis: student’s name Y-
axis: Average result
EXERCISE 3
1. Create a folder under Local disk “D” by the name “PBE” And create the folding sub folder P1, P2, P3 andP4.
ETHIOPIAN CONSTRUCTION ASSOCIATION
Wheat
Buying Total Total
price Buying Selling
NO. Customer’s Name unit Quantity /quintal price Price Revenue
1 Cheralla PLC 2 1300
2 Nas foods PLC 5 1250
Quintal
3 Alfa foods PLC 6 1200
4 Kojj PLC 4 1330
5 Dh Geda PLC 3 1150
Sum
Minimum
Maximum
Average
Total buying price= quantity* buying price
Total selling price=total buying price+10%of total buying price
Revenue = total selling price - total buying price
Create the following chart in new sheet and save under “P1” by the name “I Pass COC”
Wheat Buying and Selling Chart
Buying
10000 price/quintal
8000
Amount
6000 Total Buying
price
4000
2000 Total Selling
0 Price
Cheralla PLC nas Foods AflaFoods KOJJPLC DH GedaPLC
Revenue
PLC PLC
CustomerList
EXERCISE 4
Kab Competency Assessment
Subtraction
Division
Average
Mid3 Pro Final Total
Rank
NO Name Of Trainees
0% 45% 25% 100%
1 AbebaGetache 25 35 20
2 SimiretAntenhe 30 30 23
3 AregaDesaleg 20 33 22
4 ZanaTenaye 23 31 19
5 BayaEyob 24 32 24
Max 30 35 24
Min 20 30 19
Page 1
Formula:-
Subtraction=Total-Mid Division=Total/3
Show The Average Every Trainer By Line Chart In New Sheet.
Chart Title:-Kab
X-Axis- Trainer Name
Y-Axis-AverageResultandSaveInthe“P2”byYourName“IPassCOC”.
EXERCISE 5
Copy the data below on spreadsheet software
Quantity Unit price Total revenue Price Net price VAT
Item /Price Discount
Computer 12 6500
Fax Machine 2 1200
Copy machine 4 20000
Hard Disk 3 2500
Paper 21 175
Printer 3 9500
Total
Minimum
Maximum
Average
Formula:- Total Price = Quantity*unit price
Price Discount = 2% of Total price
Net price = the difference between Total Price and Price Discount VAT = 15% of Net
Price
Task 2 Create Pie chart by using description of Item and Net Price of the spread sheet. Task 3 Save the
file as “Report” Under “P3’’
EXERCISE 6
1) Open Microsoft office excel in your computer
2) Create the following table & insert the data on sheet one as it is formatted
3) Fill the blank cell by using appropriate excel function and as per the given formula indicated below the table
4) Insert ”column chart” below the table by using “parameters and evaluated employees data” from the table
5) Savethedocumentonthedesktopunderthefolder“P4”withthe“filenamePerformance”
XZ Flour Factory Documentation Work Unit Employees Performance Evaluation Report
evaluated employees data
NO
DERARTU LEMA GEBRU ADEN AWAL
GUDISA TOLA ALEMU TESFAYE SALIM
parameters Maximum Minimum Range
Work quality
1 (10%) 9 7 8 8 10
Job knowledge
2 (15%) 14 13 12 15 11
3 Team work (10%) 8 8 9 7 8
4 Punctuality (15%) 14 12 11 13 10
Sum (50%)
result out of 100%
average
Given formula, Result out of 100% = Sum x 2, Range = maximum ‟ minimum and Average = sum/4
