Skip to main content

MS Excel Interview Questions & Answers

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: Currency data store form
  • Data: Datastore as number form
  • Date: In Date Form
  • Text: In Text From
  • Percentage: Store data or numbers as percentage form

Q 3. Explain How to wrap data within a cell?

Answer: Wrapping data within a cell is easy. First of all, select the cell, then click the "Wrap Text" option from the home tab.
Short Cut Key:  alt + H +W
You can unwrap data follow the same procedure as well.

Q 4. What if filter?

Answer: A filter is used to check the data according to our requirements. let's suppose we have 1000 students' names in one row but we want to take data for 10 students. In this case, we can use a filter and select the student's name according to our requirements.
Short Cut Key: Select Column First then press: Ctrl + Shift + L

Q 5. What is Rank in Excel?

Answer: In order to check rank in a database we use the rank function. let's suppose, we have 10 student lists with total marks, here we can use the rank formula to check the student position from top to bottom.


Q 6. Explain the Top useful formulas in MS Excel?

Answer: Excel has thousand plus formulas and functions, but in the daily reporting system we use not more than 5%.
Sum, Average, Count, Subtotal,

  • If, Sumif, Countif
  • CountA, Count Blank
  • Vlookup, Hlookup,
  • If
  • Max, Min
  • Left, Right,
  • Rank.

Q7 . Explain how to discover a shot cut key in MS Excel?

Answer: In order to discover a shot cut key in MS Excel, follow a few steps.

 1 - Press Alt Key from your keyboard 
In your ribbon bar mane one word will be highlighted Like for Home "H" -  Insert "N" - Page Layout "p"

 2 - Now if you want to find something in the Home tab then press "H"
   
3 - Once You press "H" more English letters and numeric values will start showing.

 4- Like if I want to make my text "Bold" I will press 1.

 To make my cell value Bold my shortcut key will be
alt + h + 1 
it will convert my text into bold letters.  

Labels:

Comments

Post a Comment

Popular posts from this blog

How To Use “RANK” & “RANK.AVG” Function in MS Excel.

Use of “ RANK ( ) ” , “ RANK.EG ( ) " and “ RANK.AVG ( ) ” Function Rank formula in MS Excel is very commonly use.It is easy and useful. In this article, we will describe the functionality of the RANK formula for example. We have many Rank formulas in MS Excel and here you will fill in all details about Rank Function. We will learn here:  How to use Rank(). How To Apply Rank() In Excel. What is RANK.EG() Function. Function “ RANK  () ” and “ RANK.EG ( ) " Syntex:       =RANK(number,ref,[order])    &    =RANK.EG(number,ref,[order]) Explanation: Now you can see two different formulas of Rank. One Rank() and Rank.EG() formula. So the question is what is the difference between both of them. We can say both are the same function and the output is also same. The  the difference is RANK.EG() is not supporting with the new version of Microsoft Excel 2010. Let suppose if we have some student data ...
13 comments
Read more

How To Use Microsoft Excel Formula "CONCATENATE"

Use of  "CONCATENATE" Formula Formula :  " CONCATENATE ” In Microsoft Excel, CONCATENATE is a function, by which we can join two or more strings into a single cell. It can be used to combine text strings, numbers, or cell references, and can be useful for creating longer strings of text or for formatting data in a specific way. The syntax for the CONCATENATE function is as follows: =CONCATENATE (TEX1,TEX2, TEX3, TEX4 ................) Explanation: CONCATENATE is a very useful function in Microsoft Excel. We can join up to 30 texts together at a time. We can use CONCATENATE within the sheet, different sheets, and different workbooks. Let's suppose we have huge data with employees' names and we want to add Mr. Ms. Miss etc, before the names. It is not easy and time consuming to add Mr. or Miss. one by one. But there is a formula named CONCATENATE, could help to reduce time taking work do your work easily and very quickly. In order to understand ...
5 comments
Read more

Top 10 Job Oriented Certificate Courses

Hello Friends and students. Life is very fast these days and we want some shortcut to become successful in our life. Maximum students want to get a job as soon as possible after completing their studies. Here we will suggest the top 10 job-oriented certificate courses. 1 - Project Management Professional (PMP) Certification: Globally, industries greatly value project management professional certification. It gives you the ability to manage projects successfully, including team leadership, planning, execution, and monitoring. After this course, you can handle big projects or you can assist the senior also. For All Details Click Here 2 - Certified Data Scientist: Making informed business decisions requires data science. This certification prepares you to analyze and interpret complicated data by covering statistics, machine learning, data visualization, and programming abilities. Data scientist is the most demanding course during this period. If you are good to play with huge databases a...
Post a Comment
Read more