StudyBaba

MS Excel uses all over the world, maximum all workplaces using MS Excel for many decades. Maximum employees use MS Excel in his career. If you are a beginner then you must understand these ten functions in  MS Excel to complete your work easily. Here we are going to explain top 5 Microsoft Excel formulas with examples.  1 - Paste Special  If we copy something we can easily paste it somewhere to pre ss  Ctrl + V  (Short Cut Key), if we paste like that all formatting, formula and values everything will paste. But sometimes we want to paste only values or formula or formatting, in this case, we need to know about Paste Special function. We have multiple options to paste our value from one place to other places. By paste special function we can paste only value, formula, formatting as per our choice. Follow the instructions Copy Any Value : Ctrl + C Paste Special : Alt + H + V  Now you will find many option. All - All values, formula, formatting will past as it is. Formulas -

If you are good and ready for MS Excel interview, you must do some practice before you go ahead. Here we have a few questions and answers, if you can answer these questions you can break almost half of your interview. Every person has different skills and different knowledge about MS Excel because MS Excel has lots of things to learn. No one can be perfect, but if we know more than basic, we can survive in MS Excel jobs easily. let's start. Q 1.  What is a cell? A cell is a rectangular box in MS excel sheet. We can write anything in a cell, whatever we write it store in cells. Every cell has a name, if you select a cell from the first row and first column the the row name will be A1. Because our columns start from A, B, C .... etc, and out rows start from 1, 2, 3 .... etc. That is the reason the first cell name will be A1,  Q 2. How many data formats in MS Excel? Answer: For data storage purposes eleven data formats available in  MS Excel. Few Example:  Currency