Excel Important Questions and Answers For BPO Job Interview
What is Excel?
Excel is a spreadsheet application that allows you to record, store and analyse the data (डेटा). These data are stored in cells and each cell has a unique address depending upon it’s row and column value.
What is the File Format of Excel Documents?
What is Ribbon?
Ribbon is the top most area of Excel application, which contains menu (items) and other toolbars available in Excel. The ribbon can be minimized or maximized by pressing Ctrl + F1.
What is Worksheet in a workbook in Excel?
A worksheet is a sheet or a single page in a workbook in Excel. When you start a new workbook in Excel, Excel automatically adds three blank worksheets.
What is Filter in Excel?
Filter is used to filter out a specific/desired data (डेटा) from a larger set of data. It will hide all the unwanted data and only the data specified in the filter will be shown
Process:- Select any cell within the range. Select Data > Filter. And Then Select the column header arrow. Now Select Text Filters or Number Filters, and then select a comparison, Then Enter the filter criteria and then select OK.
What do you know about AutoSum in Excel?
Autosum, automatically add the entire number of cells in a column or row. The shortcut key for AutoSum is “Alt” + “=”
What do you know about SumIf in Excel?
Sumif, automatically sum the entire number of cells in a column or row, with certain conditions. Formula:- =SUMIF(A1:B1, <10)
What do you know about Data Shorting in Excel?
Data Shorting is used to short or arrange the data. If the data is in numbers then we can short it in accessing or descending order. And if the data is in letter then we can short it in alphabetical order. Shortcut Key:- Alt+D+S.
What do you know about If Function in Excel?
The IF function in Excel checks whether a condition is satisfied or not. And returns one value if true and another value if false.
What do you know about Concatenate in Excel?
This function combine the text of two or more cells in a single cells. Formula:- =CONCATENATE(A1, B1)
What is Vlookup in Excel?
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain (specific) value in a column, and returns the corresponding value in a different column.
Formula:- =VLOOKUP(lookup value,table array, column index number,range lookup)
What is Hlookup in Excel?
HLOOKUP in Excel stands for ‘Horizontal Lookup’. It is a function that makes Excel search for a certain value in a row, and returns the corresponding value in a different row.
Formula:- =HLOOKUP(lookup value,table array, row index number,lookup range)
What is Microsoft Outlook?
Microsoft Outlook is a corporate emailing software offered by Microsoft Office. In it we can send, reply and foreword email massages.
What do you understand about the “TO”, “CC” and “BCC” field in Microsoft Outlook?
“TO field” is used for the main recipient or recipients. If we add a recipient in the TO field then the recipient is required to take action of this email.
“CC stands” for carbon copy. It is used to send a copy of the email to other recipient or recipients, but they are not required to take action of this email. Also If we add more than one recipient in CC field, then each and every recipient from TO, CC or BCC girl can see them.
“BCC stands” for blind carbon copy. BCC field is used to send a copy of the email to other recipient or recipients, but they are not required to take action of the email. If we add one or more recipients in the BCC field, then no recipients from TO or CC section can see them.
What is the Subject Line in the email message?
Subject Line is a single line text, which is seen by the recipients without opining the email.
What is the use of Reply and Reply All in an email message?
Reply is used to respond a single recipient on the email while Reply All is used to respond to All recipient on the email.
What is the difference between Reply and Forward in an email message?
If we reply to an email, which contains an attachment, then the attachment will not be sent to the recipient but if we forward the email then the attachment will also be sent.
If you have more Interview Questions then comment below. We will come back to you, with the best Answer, as soon as possible. Thanks.