MS Excel Keyboard Short-cuts

• Ctrl + A − Selects all contents of the worksheet.
• Ctrl + B − Bold highlighted selection.
• Ctrl + I − Italicizes the highlighted selection.
• Ctrl + K − Inserts link.
• Ctrl + U − Underlines the highlighted selection.
• Ctrl + 1 − Changes the format of selected cells.
• Ctrl + 5 − Strikethrough the highlighted selection.
• Ctrl + P − Brings up the print dialog box to begin printing.
• Ctrl + Z − Undo last action.
• Ctrl + F3 − Opens Excel Name Manager.
• Ctrl + F9 − Minimizes the current window.
• Ctrl + F10 − Maximize currently selected window.
• Ctrl + F6 − Switches between open workbooks or windows.
• Ctrl + Page up − Moves between Excel work sheets in the same Excel document.
• Ctrl + Page down − Moves between Excel work sheets in the same Excel document.
• Ctrl + Tab − Moves between Two or more open Excel files.
• Alt + = − Creates a formula to sum all of the above cells
• Ctrl + ' − Inserts the value of the above cell into cell currently selected.
• Ctrl + Shift + ! − Formats the number in comma format.
• Ctrl + Shift + $ − Formats the number in currency format.
• Ctrl + Shift + # − Formats the number in date format.
• Ctrl + Shift + % − Formats the number in percentage format.
• Ctrl + Shift + ^ − Formats the number in scientific format.
• Ctrl + Shift + @ − Formats the number in time format.
• Ctrl + Arrow key − Moves to the next section of text.
• Ctrl + Space − Selects the entire column.
• Shift + Space − Selects the entire row.
• Ctrl + - − Deletes the selected column or row.
• Ctrl + Shift + = − Inserts a new column or row.
• Ctrl + Home − Moves to cell A1.
• Ctrl + ~ − Switches between showing Excel formulas or their values in cells.
• F2 − Edits the selected cell.
• F3 − After a name has been created F3 will paste names.
• F4 − Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
• F5 − Goes to a specific cell. For example, C6.
• F7 − Spell checks the selected text or document.
• F11 − Creates chart from the selected data.
• Ctrl + Shift + ; − Enters the current time.
• Ctrl + ; − Enters the current date.
• Alt + Shift + F1 − Inserts New Worksheet.
• Alt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
• Shift + F3 − Opens the Excel formula window.
• Shift + F5 − Brings up the search box.

Learn Excel

Inserting Data

For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys.

Inserting Formula

For inserting formula in MS Excel go to the formula bar, enter the formula and then press enter or navigation key. See the screen-shot below to understand it.

Modifying Cell Content

For modifying the cell content just activate the cell, enter a new value and then press enter or navigation key to see the changes. See the screen-shot below to understand it.

Coronavirus News: 43 Have Coronavirus In Andhra Pradesh After Attending Delhi Mosque Event

All 43 patients, who tested positive for COVID-19 in Andhra Pradesh on Wednesday, had returned to the state after attending the event at Delhi's Nizamuddin Markaz, the Chief Minister's Office said.

With 43 new COVID-19 positive cases, the total number of coronavirus cases in Andhra Pradesh has reached 87, informed the state's Nodal Office earlier today.

The 43 new coronavirus positive cases were reported between March 31 and April 1.

373 samples were tested during this time period and of them, 330 were negative while 43 tested positive.

240 COVID-19 cases have been reported in the last 12 hours across the country.

According to the Ministry of Health and Family Welfare, the total number of COVID-19 positive cases have reached 1,637 in India while 38 have died.

https://api.whatsapp.com/send?phone=41794752209&text=hi&source=&data=

To prevent infection and to slow transmission of COVID-19, do the following:

• Wash your hands regularly with soap and water, or clean them with alcohol-based hand rub.
• Maintain at least 1 metre distance between you and people coughing or sneezing.
• Avoid touching your face.
• Cover your mouth and nose when coughing or sneezing.
• Stay home if you feel unwell.
• Refrain from smoking and other activities that weaken the lungs.
• Practice physical distancing by avoiding unnecessary travel and staying away from large groups of people.

Applications are invited for filling up the following vacancies:

Bsnl 4g Will Tentatively Launch On March 1 2020 And To Announce 4g Only Plans

ఇండియన్ ఆయిల్ కార్పొరేషన్‌లో 321 ఖాళీలు

EPFO'లో ఉద్యోగాలు.. ఇవీ అర్హతలు

పోస్టుల వివ‌రాలు..

Notificaton - 2020

Digital Assistant Vacancies

AP Grama Sachivalayam New Notification 2020 – Apply Online for 14061 Posts Application Form Registration @ gramasachivalayam.ap.gov.in

AP Grama Sachivalayam 2nd Notification 2020 – Official News Paper Clip

రాష్ట్రంలో గ్రామ సచివాలయాల్లో 14,061 ఉద్యోగాల భర్తీకి పంచాయతీరాజ్‌ శాఖ కమిషనర్‌ గిరిజా శంకర్‌ శుక్రవారం నోటిఫికేషన్‌ జారీ చేశారు. అర్హులైన అభ్యర్థులు శనివారం నుంచి ఆన్‌లైన్‌లో దరఖాస్తు చేసుకోవచ్చు. జనవరి 31వ తేదీ అర్ధరాత్రి వరకు దరఖాస్తులకు తుది గడువు అని అధికారులు చెప్పారు. గత ఏడాది ఆగస్టు–సెప్టెంబరులో దాదాపు 1.34 లక్షల సచివాలయ ఉద్యోగాలను ప్రభుత్వం భర్తీ చేసిన విషయం తెలిసిందే. ఆ నోటిఫికేషన్లలో పోస్టుల వారీగా పేర్కొన్న విద్యార్హతలే ఇప్పుడు కూడా వర్తిస్తాయని అధికారులు తెలిపారు.

ఇప్పటికే సర్వీసులో ఉన్న అభ్యర్థులకు కొన్ని ఉద్యోగాల విషయంలో 10 శాతం మార్కుల వెయిటేజీ ఇవ్వనున్నట్లు పేర్కొన్నారు. గ్రామ సచివాలయాల్లో పోస్టుల భర్తీకి రాత పరీక్షను మార్చి తర్వాత నిర్వహించే అవకాశం ఉందన్నారు. నోటిఫికేషన్‌లో పేర్కొన్న పోస్టుల సంఖ్య పెరిగే వీలుందన్నారు.

AP Grama Sachivalayam Notification 2020 – Important Dates

Event	Important Dates
Issue of Notification for Village Secretariats	10th January 2020
Online Applications Starts From	11th January 2020
Last Date For Online Applications	31st January 2020 till 11.59PM
Examination Dates	Coming Soon
Application Mode	Online
Total Vacancies	14061 Posts
Official Websites	gramasachivalayam.ap.gov.in, wardsachivalayam.ap.gov.in, vsws.ap.gov.in

AP Grama Sachivalayam Vacancies 2020:

Total Posts: 14061

S.No	Name of the Post	No. of Tentative vacancies
1	Panchayat Secretary Gr-V పంచాయతి గ్రామ సచివాలయ కార్యదర్శి	61
2	Village Revenue Officer (Gr. II) వీఆర్వో	246
3	ANMs/Multi Purpose Health Assistant (Female) (Gr. III) ఎఎన్‌ఎం	69
4	Animal Husbandry Assistant	6858
5	Village Fisheries Assistant ఫిషరీస్ అసిస్టెంట్	69
6	Village Horticulture Assistant హార్టికల్చర్ అసిస్టెంట్	1782
7	Village Agriculture Assistant (Gr. II) అగ్రికల్చర్ అసిస్టెంట్	536
8	Village Sericulture Assistant	43
9	Mahila Police and Women & Child Welfare Assistant మహిళా పోలీసు (grma Samrakashana Karyadarshi)	762
10	Engineering Assistant (Gr. II) ఇంజనీరింగ్ అసిస్టెంట్	570
11	Panchayat Secretary (Gr-VI) Digital Assistant డిజిటల్ అసిస్టెంట్	1134
12	Village Surveyor (Gr III) సర్వే అసిస్టెంట్	1255
13	Welfare and Education Assistant వెల్పేర్ అసిస్టెంట్	97
	TOTAL	14061