Tuesday, 24 March 2020

VBA Question and Answer 1

Question 01. What are various data type and their size?

Solution:

i) The Boolean data type has only two states, True and False. These types of variables are stored as 16-bit (2 Byte) numbers, and are usually used for flags.

ii) The Byte data type is an 8-bit variable which can store value from 0 to 255.

iii) The Double data type is a 64-bit floating point number used when high accuracy is needed.

iv) The Integer data type is a 16-bit number which can range from -32768 to 32767. Integers should be used when you are working with values that can not contain fractional numbers. In case, you're working over 32767 rows use Long as data type.

v) The Long data type is a 32-bit number which can range from -2,147,483,648 to 2,147,483,647.

vi) The Single data type is a 32-bit number ranging from -3.402823e38 to -1.401298e-45 for negative values and from 1.401298e-45 to 3.402823e38 for positive values. When you need fractional numbers within this range, this is the data type to use.

vii) The String data type is usually used as a variable-length type of variable. A variable-length string can contain up to approximately 2 billion characters. Each character has a value ranging from 0 to 255 based on the ASCII character set.

Monday, 23 March 2020

About Corona

About Corona

Coronavirus disease (COVID-19) is an infectious disease caused by a new virus.
The disease causes respiratory illness (like the flu) with symptoms such as a cough,
fever, and in more severe cases, difficulty breathing. You can protect yourself by
washing your hands frequently, avoiding touching your face, and avoiding close contact
(1 meter or 3 feet) with people who are unwell.

HOW IT SPREADS
Coronavirus disease spreads primarily through contact with an infected person when they cough or sneeze.
It also spreads when a person touches a surface or object that has the virus on it, then touches their eyes, nose, or mouth.

Corona Symptoms

People may be sick with the virus for 1 to 14 days before developing symptoms.
The most common symptoms of coronavirus disease (COVID-19) are fever, tiredness,
and dry cough. Most people (about 80%) recover from the disease without needing special treatment.

More rarely, the disease can be serious and even fatal. Older people, and people with other medical conditions
(such as asthma, diabetes, or heart disease), may be more vulnerable to becoming severely ill.

Wednesday, 18 March 2020

All India Corona Helpline Numbers


S. No Name of the State Helpline Nos.
1 Andhra Pradesh 0866-2410978
2 Arunachal Pradesh 9436055743
3 Assam 6913347770
4 Bihar 104
5 Chhattisgarh 104
6 Goa 104
7 Gujarat 104
8 Haryana 8558893911
9 Himachal Pradesh 104
10 Jharkhand 104
11 Karnataka 104
12 Kerala 0471-2552056
13 Madhya Pradesh 0755-2527177
14 Maharashtra 020-26127394
15 Manipur 3852411668
16 Meghalaya 108
17 Mizoram 102
18 Nagaland 7005539653
19 Odisha 9439994859
20 Punjab 104
21 Rajasthan 0141-2225624
22 Sikkim 104
23 Tamil Nadu 044-29510500
24 Telangana 104
25 Tripura 0381-2315879
26 Uttarakhand 104
27 Uttar Pradesh 18001805145
28 West Bengal 1800313444222, 03323412600,
S. No Name of Union Territory (UT) Helpline .
1 Andaman and Nicobar 03192-232102
2 Chandigarh 9779558282
3 Dadra and Nagar Haveli and Daman & Diu 104
4 Delhi 011-22307145
5 Jammu & Kashmir 01912520982, 0194-2440283
6 Ladakh 01982256462
7 Lakshadweep 104
8 Puducherry 104

JOTHIDAM KARPOM VANGA