Address: - B block 327,328 J.

J Colony Bawana Delhi

Contact No.: - 7428529563

Student’s Details:
Name: -
Contact No.: -
Address: -
Ctrl + A = Select all Ctrl + B = Bold
Ctrl + C = Copy Ctrl + D = Change character formatting
Ctrl + E = Align center Ctrl + F = Find
Ctrl + G = Go to Ctrl + H = Replace
Ctrl + I = Italics Ctrl + J = Justify
Ctrl + K = Insert hyperlink Ctrl + L = Left align
Ctrl + M = Indent Ctrl + N = New document
Ctrl + O = Open document Ctrl + P = Print
Ctrl + Q = Remove paragraph formatting Ctrl + R = Right justify
Ctrl + S = Save Ctrl + T = Create hanging indent (tab)
Ctrl + U = Underline Ctrl + V = Paste
Ctrl + W = Close document Ctrl + X = Cut
Ctrl + Y = Redo previously undone action Ctrl + Z = Undo an action

Ctrl + 1 = Single-space lines Ctrl + 2 = Double-space lines

Ctrl + 5 = 1.5-line spacing Ctrl + Left Bracket [ = decrease font size by 1
point
Ctrl + Right Bracket] = increase font size by 1 Ctrl + Shift + A = selected text to all capital letters
point
Ctrl + Shift + D = double underline to the selected Ctrl + Shift + E = enable or disable revision
text tracking
Ctrl + Shift + F = open font window Ctrl + Shift + L = create a bullet point
Ctrl + Shift + * = view or hide non printing Ctrl + Shift + > = increase font size
characters
Ctrl + Shift + < = decrease font size Ctrl +] = increase font size
Ctrl + [ = decrease font size Ctrl + / + C = insert a cent sign (¢)
Ctrl + Del = delete word right of cursor Ctrl + Backspace = delete word left of cursor
Ctrl + End = move the cursor to the end of the Ctrl + Home = Move the cursor to the beginning
document of the document
Ctrl + Spacebar = Reset highlighted text to the Ctrl + Enter = Insert a page break
default font
Alt + F, A = save the document under a new name Alt + X = show the Unicode code of a highlighted
character
Shift + Enter = Create a soft break instead of a Shift + Insert = Paste Shift + Alt + D = Insert the
new paragraph current date
Shift + Alt + T = Insert the current time Esc =
cancel a command
 FIRST DAY

Moral Stories for Kids

1. The Boy Who Cried Wolf

There once was a boy who grew bored while watching over the village
sheep. He wanted to make things more exciting. So, he yelled out that
he saw a wolf chasing the sheep. All the villagers came running to
drive the wolf away. However, they saw no wolf. The boy was amused,
but the villagers were not. They told him not to do it again. Shortly
after, he repeated this antic. The villagers came running again, only to
find that he was lying. Later that day, the boy really sees a wolf
sneaking amongst the flock. He jumped up and called out for help. But
no one came this time because they thought he was still joking around.
At sunset, the villagers looked for the boy. He had not returned with
their sheep. They found him crying. He told them that there really was
a wolf, and the entire flock was gone. An old man came to comfort him
and told him that nobody would believe a liar even when they are
being honest.

Moral: Lying breaks trust.

2. The Golden Touch

The Greek king Midas did a good deed for a Satyr. This prompted
Dionysus, the god of wine, to grant him a wish. Midas asked for
everything he touched to turn to gold. Dionysus’ warned him not to do
so, but Midas could not be swayed. Midas excitedly started touching
everything and turning them into gold. Soon, he became hungry. But
he couldn’t eat anything because even his food turned to gold. His
beloved daughter saw him in distress and ran to hug him. However,
she, too, turned to gold. He realised then the golden touch was not a
blessing.

Moral: Greed leads one to downfall.

3. The Fox and the Grapes

A hungry fox once looked everywhere for food. He couldn’t find
anything until he stumbled upon a farmer’s wall. He saw big, purple,
juicy grapes. He jumped as high as possible to reach the grapes. No
matter how many times he tried, he failed. Finally, he gave up and
went home, thinking to himself that the grapes must have been sour
anyway.

Moral: Nothing comes easy, do not hate what you can’t have.

4. The Proud Rose

In the desert existed a rose and a cactus. The beautiful rose would take
every opportunity to insult the cactus. The other plants tried to defend
the cactus, but the rose was too obsessed with its own looks. There was
no water during a particularly hot summer. The rose started to wither
away. But the cactus had become a source of water for sparrows. The
rose asked the cactus for water, and the nice cactus readily agreed.

Moral: Never judge someone according to how they look.

5. The Milkmaid and Her Pail

Molly, the milkmaid’s job was to milk the cows and sell the milk at the
market. She started thinking about the things she would spend her
money on. While walking to the market, she spotted a chicken and
thought that she could earn more money by buying a chicken and
selling its eggs. She started to think how jealous she could make the
other milkmaid with all the things she could buy from the milk and
egg money. She started to skip in excitement, and soon the milk
spilled over. She went home with empty pails and no money. Her
mother then reminds her that she shouldn’t count her chicken until
they hatch.

Moral: Do not depend on something until you are sure it will happen.

6. A Wise Old Owl

An old owl would observe incidents happening around his oak tree
every day. The more things he saw, the less he would speak. He heard
people talking and sharing stories as well. The old owl had seen so
much and heard all kinds of stories. All of these experiences helped the
owl to become wiser day by day.

Moral: Talk less and be more observant.

7. The Golden Egg

A farmer had a goose that laid one golden egg a day. He would sell the
golden eggs, and they enjoyed a comfortable life. However, the farmer
became greedy and wanted more than one egg a day. His wife foolishly
agreed to his idea. The next day the farmer cut open the goose after it
laid the golden egg. He could only find blood and guts. He realised his
mistake. He now had no source of income, and the couple became
poorer every day.

Moral: Think before you act.

8. The Farmer and the Well

A farmer bought a well from his neighbour to water his farm. The
neighbour sold him the well but did not allow him to draw water from
it. The farmer went to the emperor for justice. His courtier questioned
the neighbour, who said that he had sold the well but not the water
within it. The neighbour was told to either pay rent for the water to
remove it all immediately. Realising that his trick didn’t work, he
apologised and went home.

Moral: Cheating will get you nowhere.

9. Elephant and Friends

A lonely elephant was looking for friends in the forest. The monkey
declined to be the elephant’s friend because the elephant could not
swing in the trees. The rabbit turned the elephant because it was too
big to fit in the burrow. The frog refused to be the elephant’s friend
because it could not jump. Every other animal said no to the poor
elephant. The next day, all the animals in the forest were running away
in fear. The elephant stopped a bear who said that the tiger was
attacking them all. The elephant nicely asked the tiger to stop, but the
tiger told the elephant to stay out of the way. The elephant proceeded
to kick the tiger and scare it away. The other animals then realised that
the elephant was the perfect size to be their friend.

Moral: Friends can be any shape or size.

10. When Adversity Knocks

There once was a girl who was frustrated with life and asked her father
for advice. He asked her to bring an egg, two tea leaves, and a potato.
He then started boiling water in three separate vessels. He put the egg,
potato, and tea leaves in one vessel each. After a few minutes, he asked
her to peel the egg and potato and strain the leaves. He explained to
his daughter that:

• The soft egg was now hard.

• The hard potato was now soft.
• The tea had changed the water itself.

When adversity is at our door, we can respond to it in different ways.

Moral: We decide how to respond to difficult situations.

 Police Complaint Letter
Your Name]
[Your Address]
[City, State, ZIP]
[Email Address]
[Phone Number]
[Date]

[Officer-in-Charge's Name]
[Police Station Name]
[Police Station Address]
[City, State, ZIP]

Subject: Complaint Regarding [Briefly Mention Incident]

Dear [Officer-in-Charge's Name],

I am writing to bring a serious matter to your attention that occurred on [Date] at around [Time]. I
am a resident of [Your Address], and the incident took place at/near [Exact Location].

[Here, give a detailed description of the incident. Mention what happened, how it happened, and
who were involved, if known. If there are any witnesses, mention their names and contact
information as well.]

This incident has caused me a great deal of distress and anxiety, and I firmly believe it is in the public
interest that this issue is dealt with appropriately to ensure such an event doesn't recur. Therefore, I
kindly request you to take immediate action against those involved.

Attached to this letter are [mention any supporting documents, photos, or evidence such as medical
reports, pictures, etc., if you have any].

I am willing to cooperate fully in any investigation that may follow and provide any further
information as required. Please let me know the next steps in this process, and if there are any forms
or applications I need to complete in order to move this process forward.

I would greatly appreciate your immediate attention to this matter. Thank you for your service and
your dedication to maintaining peace and order in our community.

Yours sincerely,

[Your Name]
 Complaint letter for snatch-and-run case

G 56,

Vikas Marg,

Laxmi Nagar

Delhi - 120001

21 April 2022

Laxmi Nagar Police Station

Delhi - 120001

Subject: Request for FIR regarding my stolen mobile phone

Sir/Ma’am,

I am Saurav Jha, a resident of Laxmi Nagar, Delhi. I am writing this letter to bring to your notice that
my phone was stolen from the Laxmi Nagar Bus stop on 20th April 2022 in broad daylight at around
12 pm. I was waiting for my bus and talking to someone on my phone when suddenly a black
splendor bike went past me with two masked and hooded boys, who snatched my phone. I tried
chasing them but everything happened so fast. I remember, however, that their bike did not have
any number plate on it.

I earnestly request you to please file my complaint and help me find those thieves. I hope you do the
needful at the earliest.

Thank you

Sincerely,

Saurabh Jha

(Signature)
4/5/24, 8:10 PM ASS-6.webp (696×900)

file:///C:/Users/DELL/Desktop/MAAHI/COURSE CONTAINT/BASIC COMPUTER/ASS-6.webp 1/1

Graphic Designer
 Formulas
Area of Circle Pythagorean theorem

𝐴 = 𝜋𝑟2 𝑎2 + 𝑏2 = 𝑐2

Quadratic Formula Fraction Addition

−𝑏 ± √𝑏2 − 4𝑎𝑐 𝑎 𝑐 𝑎𝑑 + 𝑏𝑐
𝑥= + =
2𝑎 𝑏 𝑑 𝑏𝑑

Fraction Multiplication Taylor Expansion

𝑎 𝑐 𝑎𝑐 𝑥 𝑥2 𝑥3
× = 𝑒𝑥 =1+ + + +⋯ ,
𝑏 𝑑 𝑏𝑑 1! 2! 3!
−∞ < 𝑥 < ∞
Trig Identity Mode Locking Integral

sin(𝑎 + 𝑏) = sin 𝑎 cos 𝑏 + cos 𝑎 sin 𝑏 1 2𝜋 ⅆ𝜃 1

∫ =
2𝜋 0 𝑎 + 𝑏 sin 𝜃 √𝑎2 − 𝑏2

Polynomial Expansion Binomial Theorem

𝑛
(𝑎1𝑥 + 𝑏1)(𝑎2𝑥 + 𝑏2) 𝑛
= 𝑎1𝑎2𝑥2 + (𝑎1𝑏2 + 𝑎2𝑏1)𝑥 (𝑥 + 𝑎)𝑛 = ∑ ( ) 𝑥𝑘𝑎𝑛−𝑘
𝑘
+ 𝑏1𝑏2 𝑘=0
Assignment - 1

MARK SHEET
Roll No. Studen's Name Hindi English Maths Physics Chemistry Total Average Grade
1 Rohan 45 38 34 21 37 175 35 B
2 Ankit 43 33 32 24 27 159 31.8 B
3 Reema 50 42 45 28 49 214 42.8 A
4 Sakshi 32 25 23 24 34 138 27.6 B
5 Anita 29 41 34 43 41 188 37.6 B
6 Ram 45 36 33 47 42 203 40.6 A
7 Mohit 48 45 29 26 48 196 39.2 B
8 Anjali 25 31 20 30 36 142 28.4 B
9 Himesh 30 35 44 43 49 201 40.2 A
10 Ranjeet 20 46 32 20 30 148 29.6 B
11 Anika 40 30 27 49 35 181 36.2 B
12 suraj 38 36 48 45 44 211 42.2 A
13 Rajat 47 22 40 36 35 180 36 B
14 Jyoti 49 38 20 49 27 183 36.6 B
15 Radha 38 49 34 45 49 215 43 A

Practical Problem
Q.1 Find the Total Number & Average in all Subjects in Each Student .
Q.2 Find Grade Using If Function - If Average Greater >40 then "A" Grade otherwise "B" Grade
Q.3 How Many Student "A" and "B" Grade Use of Countif
Q.4 Student Ashok and Manoj Total Number and Average Use of Sumif
Q.5 Count how many Students Use of Counta
Q.6 How Many Student Hindi & English Subject Number Grater Then > 25 and <20 Use of Countif
Assignment -2

Sales Report
S.No Items Qty Rate Amount Grade
1 AC 26 40000 1040000 Expensive
2 Fridge 30 20000 600000 Expensive
3 Cooler 35 10000 350000 Lets Buy it
4 Washing Machine 15 15000 225000 Lets Buy it
5 TV 20 20000 400000 Lets Buy it
6 Fan 30 2000 60000 Lets Buy it
7 Computer 22 25000 550000 Expensive
8 Keyboard 10 250 2500 Lets Buy it
9 Mouse 10 100 1000 Lets Buy it
10 Printer 5 12000 60000 Lets Buy it

Q.1 Using of Product Fomula for Calculate Amount = Qty*Rate

Q.2 How Many Items in a List
Q.3 How Many Items qty Greate Then > 20 and Less Then
Q.4 Calculate Item Computer Qty, Rate and Amount using Sumif Formula
Q.5 If Items Amount is Greater > 500000, Then Items "Expensive" otherwise "Lets Buy it".
Assignment -3

TEST
SUBJECT IST 2ND 3RD TOTAL AVERAGE GRADE
HINDI 17 26 22 65 21.67 B
ENGLISH 30 27 23 80 26.67 A
MATH 29 27 25 81 27.00 A
PHYSICS 23 24 20 67 22.33 B
CHEMISTRY 16 27 15 58 19.33 B
HISTORY 20 30 21 71 23.67 B
GEO 24 26 28 78 26.00 A
BIO 15 22 15 52 17.33 B
BOTANY 20 24 30 74 24.67 B

Q.1 HOW MANY SUBJECT ? Use of Counta

Q.2 HOW MANY SUBJECT 1 PAPER GREATER THAN 20 ? Use of Countif
Q.3 SUBJECT HINDI, MATH & ENGLISH TOTAL NO. & GRADE Use of Vlookup
Q.4 IF AVE. GREATHER THAN 25 THEN "A", IF AVE. GREATEHR THAN 15 AVE. "B" OTHERWISE "C" Use of Vlookup
Q.5 SUBJECT PHYSICS, MATHS & ENGLISH TOTAL /AVERAGE
Assignment - 4
Employee Database
DATE EMP. ID NAME DESIGNATION KRA
11-Jan-20 1001 ASHOK MIS-OPERATION SALES
12-Jan-20 1002 AMIT OPERATION PHP
13-Jan-20 1003 JITENDAR SOFTWARE ENG JAVA
14-Jan-20 1004 RAJESH SME MAILS
15-Jan-20 1005 MOHAN PROGRAMMER C++
16-Jan-20 1006 RAKESH PROGRAMMER DOT NET
17-Jan-20 1007 KRISHNA SOFTWARE ASSOCIATE TESTING
18-Jan-20 1008 RAM SALES EXECUTIVE SERVER
19-Jan-20 1009 ANJALI SALES EXECUTIVE SALES
20-Jan-20 1010 CHAAND SALES EXECUTIVE AMAZON
21-Jan-20 1011 JYOTI SALES EXECUTIVE AMAZON
22-Jan-20 1012 ANKIT SALES EXECUTIVE AMAZON
23-Jan-20 1013 ANJALI SALES EXECUTIVE GROFFERS
24-Jan-20 1014 Kiran SALES EXECUTIVE PAYTM
25-Jan-20 1015 Savita SALES EXECUTIVE PAYTM
26-Jan-20 1016 Priyanka SALES EXECUTIVE MYNTRA
27-Jan-20 1017 Kavita SALES EXECUTIVE AMAZON
28-Jan-20 1018 Kunal BRAND MANAGER MARKETING

Practical Problem
Q.1 How Many Employee? Use of Counta
Q.2 How Many Employee in Sales Executive? Use of Countif
Q.3 How Many Employee Sales Executive in Amazone and Myntra? Use of Countifs
Q.4 Employee Dinesh and Vishal Post and KRA? use of Vlookup
Q.5 Employee Abhishek and Hema Emp id? Use of Index with Match
ASSIGNMENT -6
 INCOME STATEMENT FOR THE MONTH OF DECEMBER-2023
EMP. ID EMPLOYEE NAME DESINATION RANK BASIC SAL HRA DA CCA TA GROSS SA CGHS PF I.TAX NET SALARY
ABC-01 SOHIT CEO A 26500 5000 4505 5035 3500 44540 500 1437.625 4454 38148.375
ABC-02 AKSHAY LDC D 17200 3500 2924 3268 1900 28792 500 933.1 2879.2 24479.7
ABC-03 NITIN UDC C 20400 4000 3468 3876 2500 34244 500 1106.7 3424.4 29212.9
ABC-04 MOHAN MD B 22500 4500 3825 4275 3000 38100 500 1220.625 3810 32569.375
ABC-05 SANJAY CEO A 26500 5000 4505 5035 3500 44540 500 1437.625 4454 38148.375
ABC-06 ADITYA CLERK E 12500 3000 2125 2375 1500 21500 500 678.125 2150 18171.875
ABC-07 SACHIN PEON F 10000 2000 1700 1900 1500 17100 500 542.5 1710 14347.5
ABC-08 RITESH MD B 22500 4500 3825 4275 3000 38100 500 1220.625 3810 32569.375
ABC-09 MOHIT CEO A 26500 5000 4505 5035 3500 44540 500 1437.625 4454 38148.375
ABC-10 KUNAL MD B 22500 4500 3825 4275 3000 38100 500 1220.625 3810 32569.375
ABC-11 AMIT CLERK E 12500 3000 2125 2375 1500 21500 500 678.125 2150 18171.875
ABC-12 RAJESH LDC D 17200 3500 2924 3268 1900 28792 500 933.1 2879.2 24479.7
ABC-13 LAKHAN UDC C 20400 4000 3468 3876 2500 34244 500 1106.7 3424.4 29212.9
ABC-14 RIZWAN MD B 22500 4500 3825 4275 3000 38100 500 1220.625 3810 32569.375
ABC-15 MINAL CLERK E 12500 3000 2125 2375 1500 21500 500 678.125 2150 18171.875
ABC-16 PRAGATI CEO A 26500 5000 4505 5035 3500 44540 500 1437.625 4454 38148.375
ABC-17 BABLU MD B 22500 4500 3825 4275 3000 38100 500 1220.625 3810 32569.375
ABC-18 RITIK PEON F 10000 2000 1700 1900 1500 17100 500 542.5 1710 14347.5
ABC-19 SANDEEP PEON F 10000 2000 1700 1900 1500 17100 500 542.5 1710 14347.5
ABC-20 KOMAL CEO A 26500 5000 4505 5035 3500 44540 500 1437.625 4454 38148.375
TOTAL 387700 77500 65909 73663 50300 655072 10000 21032.73 65507.2 558532.075

FORMULAS
IF(DESIGNATION="CEO","A",IF(DESIGNATION="MD","B",IF(DESIGNATION="UDC","C",IF(DESIGNATION="LDC","D",
RANK = IF(DESIGNATION="CLERK","E","F")))))
IF(DESIGNATION="CEO",26500,IF(DESIGNATION="MD",22500,IF(DESIGNATION="UDC",20400,IF(DESIGNATION="LDC",
BASIC SALARY = 17200,IF(DESIGNATION="CLERK",12500,10000)))))
HRA = IF(RANK="A",5000,IF(RANK="B",4500,IF(RANK="C",4000,IF(RANK="D",3500,IF(RANK="E",3000,2000)))))
DA = BASIC SALARY*17%
CCA = BASIC SALARY*19%
TA = IF(RANK="A",3500,IF(RANK="B",3000,IF(RANK="C",2500,IF(RANK="D",1900,1500))))
GROSS SALARY = SUM(BASIC SALARY TO TA)
CGHS = 500
PF = BASIC SALARY*5%+DA*2.5%
I.TAX = GROSS SALARY*10%
NET SALARY = GROSS SALARY-CGHS-PF-I.TAX
 PAYSLIP FOR THE MONTH OF DECEMBER-203
GROSS SALARY 44540
ID ABC-01
NAME CEO
DESIGNATION A
RANK 26500

EARNING DEDUCTION
BASIC SALARY 26500 CGHS 500
HRA 5000 PF 1437.625
DA 4505 I.TAX 4454
CCA 5035
TA 3500 NET SALARY 38148.375

FORMULAS
EMPLOYEE NAME = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
DESINATION = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
RANK = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
BASIC SALARY = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
HRA = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
DA = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
CCA = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
TA = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
GROSS SALARY = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
CGHS = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
PF = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
I.TAX = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
NET SALARY = VLOOKUP(Select Emp Id Fix by F4,Select Income Statement Sheet Fix by F4,column no.)
ASSIGNMENT- 8

ATTANDANCE SHEET FOR THE MONTH OF JAN 2024

DATE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
STATUS
DAY Sun Mo Tue We Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue

ROLL NO. STUDENT'S NAME PRESENT ABSENT LEAVE

1 MOHIT P P P P P P P P P P P P P P P P P P P P P P P P P A 25 1 0

2 ROHAN P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

3 ROHIT P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

4 NITIN P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

5 MONIKA P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

6 AMIT P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

7 RAJNI
S P P P P P P
S P P P P P P
S P P P P P P
S P P P P P P
S P P 26 0 0

8 RIYA
U P P P P P P
U P P P P P P
U P P P P P P
U P P P P P P
U P P 26 0 0

9 ANIKET N P P P P P P N P P P P P P N P P P P P P N P P P P P P N P P 26 0 0

10 SANDHYA D P P P P P P D P P P P P P D P P P P P P D P P P P P P D P P 26 0 0

11 RIDHI A P P P P P P A P P P P P P A P P P P P P A P P P P P P A P P 26 0 0

12 ANKIT
Y P P P P P P
Y P P P P P P
Y P P P P P P
Y P P P P P P
Y P P 26 0 0

13 NEHA P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

14 VISHNU P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

15 SUMIT P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

16 HEENA P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

17 DIVYA P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

18 YASH P P P P P P P P P P P P P P P P P P P P P P P P P P 26 0 0

FORMULAS
PRESNT = COUNTIF(D5:AG5,"P")
ABSENT = COUNTIF(D5:AG5,"A")
LEAVE = COUNTIF(D5:AG5,"L")