CT1112 OMEWORK#3
DUE DATE: 2023-2-12
Practice the following tasks on your computer.
1. Create a blank Workbook. Type the text ålcome)n the cell A1, apply the font
style as ¯ld!nd font color as 5rple!nd rotate the cell content to ngle
Clockwise¨Hint: You can save this file with the name 2actice/n the desktop.)
and insert a new worksheet and Rename it as ôudent Marks Change the Tab
Color to ¬ue!nd move this sheet before èeet 1Š2. In ôudent Marks heet, enter the data of 5 students under the column headings
D Number ¡me idterm marks and ©nal marks Enter the column
heading /tal marks!nd calculate the total marks for each student. (Hint: You can
use the AutoSum command.) ,
3- In ôudent Marks heet, Insert a Column Chart for the data of ¡me!nd
/tal Marks&ields. Move the chart to a new sheet and name it as ôudents
Marks!nd Protect your workbook with a password.
4.In èeet14ype p0)n cell B8. Apply the Number format õrrency4o cell
B8, change the currency symbol to ÁR!nd increase the decimal places to Ôand
Generate names of the months starting from ¡nuary4o %cember)n the cell
range B10 to B21. (Hint: You can use the AutoFill feature.)
5- In ôudent Marks heet, Calculate the Maximum /tal marks)n cell E10 and
the Minimum /tal marks)n cell E11 and Split your worksheet horizontally.
Note: take a screenshot of the answer steps.
SUBMISSION GUIDELINES:
•
“ubmit your file before deadline. If you send it later you will lose marks.
Cheating lead to ZERO
Submit your files to LMS

Purchase answer to see full
attachment