Scribd
Upload
137 views2 pages

Excel Assignment 3

The document outlines an Excel assignment requiring the creation of a spreadsheet with specific formatting and data entry instructions. Key tasks include creating a table, calculating total and average marks, applying conditional formatting, and generating a column chart with appropriate titles and labels. The assignment emphasizes saving the workbook with a specific naming convention and includes a note to ensure the final graph resembles a provided example.

Uploaded by

inkamtechnologies
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
137 views2 pages

Excel Assignment 3

The document outlines an Excel assignment requiring the creation of a spreadsheet with specific formatting and data entry instructions. Key tasks include creating a table, calculating total and average marks, applying conditional formatting, and generating a column chart with appropriate titles and labels. The assignment emphasizes saving the workbook with a specific naming convention and includes a note to ensure the final graph resembles a provided example.

Uploaded by

inkamtechnologies
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 Assignment 3

You are supposed to create a spreadsheet using MS Excel, by following the instructions given
below.

Figure 1.0
1. Create a blank workbook in Microsoft Excel and save it as "<Student ID Assign Two>
e.g. 13A-2014-ECD Ms Excell Sign 2. [1 mark]
2. Create a table with 7 rows and 9 columns in the cell range A3:I9, as shown in Figure 1.0.
Bold and center the headings of each column. [2 marks]

3. Insert a title "" and a sub title "Mark sheet for A/L Biology - Class A", by centering it
with the table, making the text bold, and changing the font size 16 for main title and 14
for subtitle. [1 mark]
4. Enter the data given under the columns, "Index No", "Name", "Physics", "Chemistry",
"Biology", and "English". [2 marks]
5. Use the relevant formula to calculate the total marks of 'Liyanage' (Index No.- 1001) and
copy the formula to the relevant cells. [2 marks]
6. Use the relevant formula to calculate the average marks of 'Liyanage' (Index No.- 1001)
and copy the formula to the relevant cells. [2 marks]

7. Format the "Average" column with two decimal places. [1 mark]


8. Use the relevant formula to find the rank of 'Liyanage' (Index No.- 1001) and copy the
formula to the relevant cells. [1 mark]
9. Use conditional formatting to change the color of the cells of which the average mark is
more than 60, into green. [1 mark]
10. Select the columns, "Index No", "Physics", "Chemistry", "Biology", and "English"
column and draw a column chart as shown below. [2 marks]
11. Insert the title, "AITREC", and the sub title, "Mark sheet for A/L Biology - Class A" to
the top of the chart. [1 mark]
12. Set the X axis labels with the index numbers. [1 mark]
13. Label the X axis title as, "Index No" and Y axis title as, "Marks". [1 mark]
14. Label the legends for 4 subjects, "Physics", "Chemistry", "Biology" and
"English". [1 mark]
15. Insert your index number in the center of the footer. [1 mark]

Note; - Make sure to get a graph similar to the one given below.

16. Save your work in your folder

You might also like