Scribd
Upload
17 views1 page

Excel Practical Two

The document outlines practical Excel tasks for creating and formatting a table of school data, including head teacher titles, school names, and charges for computer studies and lunch. It also includes instructions for creating a second sheet to track weekly expenditures with various financial categories, calculating totals, and generating multiple types of charts. The tasks emphasize data entry, formatting, and the use of Excel functions and charts.

Uploaded by

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

Excel Practical Two

The document outlines practical Excel tasks for creating and formatting a table of school data, including head teacher titles, school names, and charges for computer studies and lunch. It also includes instructions for creating a second sheet to track weekly expenditures with various financial categories, calculating totals, and generating multiple types of charts. The tasks emphasize data entry, formatting, and the use of Excel functions and charts.

Uploaded by

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

EXCEL PRACTICAL TWO

Section A
Head Teacher’s Title School
School Computer Studies Charges Lunch
Name Address Teacher’s Name
Mr. Kitende Kapa Sir Mavundu SS P.O. Box 10, Ms. Mukulu Julie 3,000 5,000
Mavundu
Ms. Kasiru Jovial Madam Twakoowa SS P.O. Box 1010, Mr. Mwana David 3,500 5,000
Twakoowa
Mrs. Kapa Zebra Madam Nabbutto P.O. Box 123, Mr. ObinaTom 4,000 5,000
College Kawere
Dr. Kasaala Pin Sir Serious SS P.O. Box 9090, Mrs. Nina Booked 4,500 5,000
Lwamugolodde
The table below shows details required from different schools

i. Create the table above and key in the data as provided.


ii. Insert a row above and type the word “ICT – SCHOOLS” as the title of the table then
merge and center the title
iii. Give the document a double border
iv. Charges and lunch column increase a number of two decimal place and change to dollars.
v. Column two from title give it “angle counter clock wise” and currencies “angle clockwise”
vi. Use formatting option e.g. alignment, font size and color, bold, italics and fill color to make
your table admirable.

Section B
(i) Insert and sheet and create the data below rename the sheet “my work 2”
MON TUE WED THU FRI SAT
Taxes 50,000 50,000 - - 50,000 50,000
Rent 80,000 25,000 80,000 90,000 80,000 80,000
Electricity 20,000 80,000 15,000 10,000 10,000 5000
Water 25,000 25,000 25,000 25,000 25,000 25,000
Personal 60,000 75,000 85,000 90,000 50,000 40,000
expenses
Total

(ii) Using a formula and functions find Total, Mean, Maximum and Minimum
(iii) Sort your data using total column in ascending order.

(iv) Add a row at the very top and type the title “WEEKLY
EXPENDITURE”

(v) Using the data above insert the following charts.

 Column chart
 Pie chart
 Line chart
 Bar chart
 Area chart
 Combo chart
 Bubble chart

You might also like