Excel Shortcuts - Ctrl + N, Ctrl + O, Ctrl + S, Ctrl + W, Ctrl + F4, Ctrl + H, Ctrl + K, Ctrl + PageDown, Ctrl + PageUp, Ctrl + P, Ctrl + G, Ctrl + ;, Ctrl + Space, Ctrl + 9, Ctrl + 0, Ctrl + F1, Ctrl + X, Ctrl + End, Ctrl + Home, Ctrl + Delete

Excel Shortcuts

(Image by - Sharma Guides | Subham232330)

Ctrl + N = To create a new workbook

Ctrl + O = To open an existing workbook

Ctrl + S = To save a workbook

Ctrl + W = To close the current workbook

Ctrl + F4 = To close excel

Ctrl + H = To display find and replace

Ctrl + K = To insert a hyperlink

Ctrl + PageDown = To move the next sheet

Ctrl + PageUp = To move the previous sheet

Ctrl + P = Print File

Ctrl + G = Display "Go To" dialog box

Ctrl + ; = Insert the current date

Ctrl + Space = Select the entire column

Ctrl + 9 = Hide selected row

Ctrl + 0 = Hide selected column

Ctrl + F1 = Expand or Collapse ribbon

Ctrl + X = Cut selected cells

Ctrl + End = Move to the last cell in the worksheet

Ctrl + Home = Move to the first cell in the worksheet

Ctrl + Delete = Delete end of line

Comments

SQL Injection

SQL Injection The SQL Injection is a code penetration technique that might cause loss to our database. It is one of the most practiced web hacking techniques to place malicious code in SQL statements, via webpage input. SQL injection can be used to manipulate the application's web server by malicious users. SQL injection generally occurs when we ask a user to input their username/userID. Instead of a name or ID, the user gives us an SQL statement that we will unknowingly run on our database. For Example - we create a SELECT statement by adding a variable "demoUserID" to select a string. The variable will be fetched from user input (getRequestString). demoUserI = getrequestString("UserId"); demoSQL = "SELECT * FROM users WHERE UserId =" +demoUserId; Types of SQL injection attacks SQL injections can do more harm other than passing the login algorithms. Some of the SQL injection attacks include: Updating, deleting, and inserting the data: An attack can mo...

Schedule in DBMS

Schedule A series of operation from one transaction to another transaction is known as schedule. It is used to preserve the order of the operation in each of the individual transaction. 1. Serial Schedule The serial schedule is a type of schedule where one transaction is executed completely before starting another transaction. In the serial schedule, when the first transaction completes its cycle, then the next transaction is executed. For example: Suppose there are two transactions T1 and T2 which have some operations. If it has no interleaving of operations, then there are the following two possible outcomes: Execute all the operations of T1 which was followed by all the operations of T2. Execute all the operations of T1 which was followed by all the operations of T2. In the given (a) figure, Schedule A shows the serial schedule where T1 followed by T2. In the given (b) figure, Schedule B shows the serial schedule where T2 followed by T1. 2. Non-serial Schedule If interle...

Natural Language Processing (NLP)

What is Natural Language Processing (NLP) ? Natural Language Processing (NLP)* is a field of artificial intelligence (AI) that focuses on the interaction between computers and humans using natural language. It involves the development of algorithms and models that enable computers to understand, interpret, and generate human language. Here are key aspects of NLP: 1. *Text Understanding:* NLP systems aim to comprehend the meaning of written or spoken language. This involves tasks such as text classification, sentiment analysis, and named entity recognition. 2. *Speech Recognition:* NLP extends to processing spoken language, converting audio signals into text. This technology is used in voice assistants, transcription services, and more. 3. *Language Generation:* NLP systems can generate human-like text. This is employed in chatbots, language translation services, and content generation. 4. *Machine Translation:* NLP is fundamental to machine translation systems that enable the automatic...

Sharma Guides

Search This Blog