Computer Shortcut Key

Computer Shortcut Key:-


Ctrl + A - Select All

Ctrl + B - Bold 

Ctrl + C - Copy

Ctrl + D - Fill

Ctrl + F - Find

Ctrl + G - Find next instance of text

Ctrl + H - Replace

Ctrl + I - Italic

Ctrl + K - Insert a hyperlink

Ctrl + N - New workbook

Ctrl + O - Open

Ctrl + P - Print

Ctrl + R - Nothing right

Ctrl + S - Save

Ctrl + U - Underlined

Ctrl + V - Paste

Ctrl W - Close

Ctrl + X - Cut

Ctrl + Y - Repeat

Ctrl + Z - Cancel

F1 - Help

F2 - Edition

F3 - Paste the name

F4 - Repeat the last action

F4 - When entering a formula, switch between absolute / relative references

F5 - Goto

F6 - Next Pane

F7 - Spell Check

F8 - Extension of the mode

F9 - Recalculate all workbooks

F10 - Activate Menubar

F11 - New graph

F12 - Save As

Ctrl +: - Insert the current time

Ctrl +; - Insert the current date

Ctrl + "- Copy the value of the cell above

Ctrl + '- Copy the formula from the cell above

Shift - Offset Adjustment for Additional Functions in the Excel Menu

Shift + F1 - What is it?

Shift + F2 - Edit cell comment

Shift + F3 - Paste the function into the formula

Shift + F4 - Search Next

Shift + F5 - Find

Shift + F6 - Previous Panel

Shift + F8 - Add to the selection

Shift + F9 - Calculate the active worksheet

Shift + F10 - Popup menu display

Shift + F11 - New spreadsheet

Shift + F12 - Save

Ctrl + F3 - Set name

Ctrl + F4 - Close

Ctrl + F5 - XL, size of the restore window

Ctrl + F6 - Next Workbook Window

Shift + Ctrl + F6 - Previous Workbook Window

Ctrl + F7 - Move window

Ctrl + F8 - Resize Window

Ctrl + F9 - Minimize the workbook

Ctrl + F10 - Maximize or Restore Window

Ctrl + F11 - Inset 4.0 Macro sheet

Ctrl + F1 - Open File

Alt + F1 - Insert a graph

Alt + F2 - Save As

Alt + F4 - Output

Alt + F8 - Macro dialog

Alt + F11 - Visual Basic Editor

Ctrl + Shift + F3 - Create a name using the names of row and column labels

Ctrl + Shift + F6 - Previous Window

Ctrl + Shift + F12 - Printing

Alt + Shift + F1 - New spreadsheet

Alt + Shift + F2 - Save

Alt + = - AutoSum

Ctrl + `- Toggle value / display of the formula

Ctrl + Shift + A - Insert the argument names in the formula

Alt + down arrow - automatic view list

Alt + '- Format Style Dialog

Ctrl + Shift + ~ - General Format

Comments

Post a Comment

Popular posts from this blog

UNESCO World Heritage Sites In India

Image
For all upcoming Banking & SSC exams static GK will play very crucial role.Hence here we are discussing one of the important part of static GK i.e. UNESCO World Heritage Sites In India. Background of UNESCO The  United Nations Educational, Scientific and Cultural Organization (UNESCO)  is a specialized agency of the United Nations (UN) which is based in Paris, France.UNESCO pursues its objectives through five major programs education, natural sciences, social/human sciences,culture, and communication/information. UNESCO has 195 member states and nine associate members. As of now there are 38 world Heritage sites in India. 30 cultural sites and 8 natural sites. Cultural Sites Sr. No. Name Of The Site State 01 Ajanta Caves (1983) Maharashtra 02 Ellora Caves (1983) Maharashtra 03 Agra Fort (1983) Uttar Pradesh 04 Taj Mahal (1983) Uttar Pradesh 05 Sun Temple, Konarak (1984) Odisha 06 Group of Monuments at Mahabalipuram (1984) Tamil Nadu 07 Churches and Convents of Goa (...
Read more

Scheme

Pradhan Mantri Mudra Yojna :- Launched - 8 April 2015 Launched - Modi ji Under - Ministry of Finance Aim - To provide loan 10lakh to non corporate or MSME Paid up capital - 750cr Authorised capital - 1000cr Minimum - 50k Maximum - 10k Shishu - 50k Kishore - 50k-5lakh Tarun - 5lakh - 10lakh PMMJ Monitoring State Level Department National Level Department MUDRA - Micro 7nit development Refinance Agency Borrower can apply through Udyamimitra portal Recently Completed 8 years. Pradhan Mantri Fasal Bima Yojana:- Launched - 18 Feb 2016 From - Sehore MP By - Modi Ji Under - Ministry of agriculture and Farmer Welfare Aim - to reduce premium burden Budget outlay 2023-24 - 13,625cr Rabi - 1.5% Kharif - 2% Horticulture - 5% Pradhan Mantri Jan Dhan Yojna :- Announced - 15 August 2014 Launched - 28 August 2014 Launched By - Modi Ji Under - Department of Financial and ministry of Finance Age - 18-65 years Slogan - Mera khata Bhagya Vidhata 15m account opened Accidential Insurance 2 lakh Overdraft 2k...
Read more

List of Waterfalls in India

Name of the Waterfall Height District State Nohkalikai Falls 340 metres (1,120 ft) East Khasi Hills Meghalaya Nohsngithiang Falls   315 metres (1,033 ft) East Khasi Hills Meghalaya Dudhsagar Falls   310 metres (1,020 ft) Sanguem Goa Kynrem Falls   305 metres (1,001 ft) East Khasi Hills Meghalaya Meenmutty Falls   300 metres (980 ft) Wayanad Kerala Thalaiyar Falls   297 metres (974 ft) Dindigul Tamil Nadu Barkana Falls   259 metres (850 ft) Shimoga Karnataka Jog Falls   253 metres (830 ft) Shimoga Karnataka Khandadhar Falls   244 metres (801 ft) Sundargarh Odisha Vantawng Falls   229 metres (751 ft) Serchhip Mizoram Barehipani Falls   217 metres (712 ft) Mayurbhanj Odisha Kune Falls   200 metres (660 ft) Pune Maharashtra Soochipara Falls   200 metres (660 ft) Wayanad Kerala Magod Falls   198 metres (650 ft) Uttara Kannada Karnataka Kunchikal Falls   ...
Read more

17 Sustainable Development Goals

The 17 Sustainable Development Goals [SDGs] To Transform Our World   GOAL 1 : No Poverty.  GOAL 2 : Zero Hunger.  GOAL 3 : Good Health and Well-being.  GOAL 4 : Quality Education.  GOAL 5 : Gender Equality.  GOAL 6 : Clean Water & Sanitation.  GOAL 7 : Affordable & Clean Energy.  GOAL 8 : Decent Work & Economic Growth.  GOAL 9 : Industry, Innovation & Infrastructure.  GOAL 10 : Reduced Inequality.  GOAL 11 : Sustainable Cities & Communities.  GOAL 12 : Responsible Consumption & Production.  GOAL 13 : Climate Action.  GOAL 14 : Life Below Water.  GOAL 15 : Life on Land.  GOAL 16 : Peace & Justice Strong Institutions. GOAL 17: Partnerships to Achieve the Goal.
Read more

IBPS PO MAINS CA EXACT QUESTION2021-22

IBPS PO MAINS CA EXACT QUESTION  : Q1.Nse prime company needs to have atleast ---------- public share holding as against 25 % under sebi rules.  a) 75 b)40 C) 55 d) 50 e) 60 Q2.-------- appointed as chairperson of In space  Q3.ASI --> 84 acre land located in --------- historic moment,bibi-ka-maqbara considered as replica of taj mahal Q4.Sbi, ubi decided to adopt -------- Method for auction of loan accounts ksk mahanadi power co Ltd  a) reverse auction b) swiss challenge c) dutch d) vickery e) english Q5.Da Vinci code is wriiten by  a) John grisham b) dan Brown C) james rollins d) David baldacci e) jan Caldwell Q6.......... Chairperson of delimitation commission a draft paper proposing ------- additional assembly seats for j&k Q7.dept of atomic energy, Goi India's present nuclear capacity of -------- is planned to be increased to 22,480MW by 2031 Q8.paytm partnered with --------- companies to enable international fund transfer directly to any full kyc comp...
Read more

History of Banking in India (Before & After Independence)

Image
History of Banking in India (Before & After Independence):  The banking system is considered as the  backbone of a nation's economy . Modern banking in India originated in the last decade of the 18th century. We have come up with the history of banking, before and after independence. The history of banking began when empires needed a way to pay for foreign goods and services with something that could be exchanged or facilitated easily. Prior to this, banking procedures were carried by informal methods in the ancient World. However, formal banking has been developed around the 20th century. In India, banking has developed from the primitive to the modern stage of banking in a fashion that has no parallel in world history.  Today, the Indian banking system is divided into commercial banks (Both Public, Private Banks, schedules and non-scheduled), Regional Rural Banks, Cooperative Banks, etc. In this article, we will dig deeper to make you understand different phase...
Read more

Appointed Brand Ambassadors List

Recently Appointed Brand Ambassadors List Persons Name of the Brands and Campaigns Deepika Padukone Addidas , Llyod, Levi’s, Plant-based nutrition brand OZiva Manoj Bajpayee FloBiz flagship product named myBillBook Salman Khan Covid-Vaccine Ambassador of Maharashtra, Pepsi, Navratna Oil MC Mary Kom TRIFED Aadi Mahotsav Smriti Mandhana (India’s  Women Cricketer) GUVI , Playerzpot, Equitas Small Finance Bank (ESFB), Equitas  Small Finance Bank (ESFB) Jasprit Bumrah Unix Ranveer Singh National Basketball Association (NBA) , Manyavar, Oyakaya Power  Group, JBL, Flite, Bingo, Llyod, Xiaomi India, Kajaria Ply, Dish TV,  Siyaram, Big Muscle, Nutrition, Kansai Narolac, Kotak Mahindra  Bank, Thumps Up, Make My Trip, Set Wet, Adidas, Carrera FW,  Jack And Jones, Colgate, Nexa, Vivo, Ching’s, Kellogg’s, Royal  Stag, CoinSwitch Kuber onboards Ranveer Brar Asahi Kasei Kriti Sanon FOSSIL ,Skincare Brand JOY, Magic bricks, Dabur(for its skincare  brand Fem), Whi...
Read more

list of Important Revolutions in India

Revolution Field / Product Father of Revolutions Period Green Revolution Agriculture M.S.Swaminathan 1966 - 1967 White Revolution or Operation flood Milk/Dairy products Verghese Kurien 1970-1996 Blue Revolution Fish & Aqua Dr.Arun Krishnan 1973-2002 Golden Revolution Fruits, Honey, Horticulture Nirpakh Tutej 1991- 2003 Silver Revolution Eggs Indira Gandhi 2000's Yellow Revolution Oil Seeds Sam Pitroda 1986 - 1990 Pink Revolution Pharmaceuticals, Prawns, Onion Durgesh Patel 1970's Brown Revolution Leather, Coco Hirlal Chaudri ---------- Red Revolution Meat, Tomato Vishal Tewari 1980's Golden Fibre Revolution Jute         _________ 1990's Evergreen Revolution Overall Production of Agriculture. M.S.Swaminathan 2017-2022 Black Revolution Petroleum       _________   ____ Silver Fiber Revolution Cotton        _________ 2000's Round Revolution Potato         _________ 1965- 2005 Protein Revolution Agriculture (...
Read more

GST COLLECTION OF PREVIOUS MONTHS IN 2022

GST COLLECTION OF PREVIOUS MONTHS IN 2022 :- 🏛JANUARY :  1,40,986CR. 🏛FEBRUARY : 1,33,026CR. 🏛MARCH.      : 1,42,095 CR. 🏛APRIL.         : 1,67,540CR. 🏛MAY.            : 1,40,885CR. 🏛JUNE.           : 1,44,616CR. 🏛JULY.            : 1,48,995CR. 🏛AUGUST.      : 1,43,612CR. 🏛SEPTEMBER : 1,47,686CR. 🏛OCTOBER.      : 1,51,718CR. 🏛NOVEMBER   : 1,45,867CR. 🏛DECEMBER :  1,49,507CR 😱 December Month GST revenues more than Rs 1.4 lakh crore for 10 straight months in a row. 😍Data Released By - Finance Ministry.
Read more

Human Brain and Its Function

Image
Human Brain The human brain controls nearly every aspect of the human body ranging from physiological functions to cognitive abilities. It functions by receiving and sending signals via neurons to different parts of the body. The human brain, just like most other mammals, has the same basic structure, but it is better developed than any other mammalian brain.  Table of Contents Human Brain Brain Diagram Location Human Brain Parts Read on to explore the human brain structure, diagram, parts of the human brain and the body functions controlled by the human brain. The Human Brain On average, an adult brain weighs between 1.0 kg – 1.5 kg. It is mainly composed of neurons – the fundamental unit of the brain and nervous system. Recent estimates have suggested that the brain contains anywhere between 86 billion to 100 billion neurons. The brain, along with the spinal cord, constitutes the central nervous system. It is responsible for thoughts, interpretation and origin of control for bo...
Read more