Skip to main content

Posts

Showing posts from June, 2023

MS Excel Shortcut Keys MCQs | For All Competitive Exams and Interviews

41 MS Excel Shortcut Keys MCQs | For All Competitive Exams and Interviews. In today's fast-paced world, time is of the essence, especially when dealing with spreadsheets and data management. Microsoft Excel, the widely used spreadsheet software, offers a plethora of powerful functions and features to streamline your work. However, knowing the right shortcuts can significantly enhance your productivity. In this article, we will explore some of the most essential and time-saving MS Excel shortcuts that every user should know.  MS Excel Shortcut Keys MCQs  List of Shortcut Keys of MS Excel: Q.1: Which shortcut key is used to apply outline borders? Ctrl + Shift + 7 Q.2: Which shortcut key is used to remove all borders? Ctrl + Shift + _ (Underline) Q.3: Which key is used for strikethrough selection? Ctrl + 5 Q.4: Which shortcut key is used to add new worksheet? Shift + F11 Q.5: Which shortcut key is used to change the font size? Ctrl + Shift + P Q.6: In Excel which shortcut key is us

How to Make Ticket booking Sheet tutorial in excel

how to make ticket booking sheet in excel, step by step tutorial to make ticket booking program in ms excel, excel tips and tricks, excel, Microsoft excel, excel formula, excel project. Step by step tutorial to make Program in Excel for show booking, how to make concert booking software in Ms Excel without using Visual Basic?. Ms excel is very powerful and useful application in which we can do different types of office work easily. In todays tutorial we will know how to make booking window for show.  How to Make Ticket booking Sheet tutorial in excel In this we will use the following formulas: Conditional formatting Data Validation Countif formula in excel Addition formula in ms excel Date Converting date into Day by using TEXT formula. We will use the following Abbreviation: B For Booked R for Reserved Suppose we want to make a program in which we can book the seats for Comedy Show.  Total Seats available are 200 in hall and and in every row there are 10 seats available.  We will p