Top 50 Excel Interview Questions and Answers in 2022
Top 50 Excel Interview Questions and Answers
Today we are sharing an important pdf in hindi Top 50 Excel Interview Questions and Answers in 2022 आज की हमारी यह पोस्ट Computer बिषय से सन्बन्धित है , इस पोस्ट में हम आपको Computer बिषय से संबंधित सभी प्रकार की PDF ( Computer Notes in Hindi PDF and Computer Notes in English PDF ) को Download करने की Link उपलब्ध कराऐंगे ! जिन पर क्लिक करके आप इनको Download कर पाएँगे ! जो कि आपको आने बाले सभी प्रकार के Competitive Exams में काम आयेंगी !
अभी हमारे पास Top 50 Excel Interview Questions and Answers in 2022 बिषय से सन्बन्धित जितनी PDF हैं वो इस पोस्ट मे हम आपको उपलब्ध करा रहे है ! और आगे जितनी भी Computer बिषय से सन्बन्धित PDF हमारे पास आयेंगी उनकी लिन्क भी इसी पोस्ट में Add की जायेगी , सो आप सभी से Request है कि आप इस पोस्ट को अपने Browser के BOOKMARK में Save कर लीजिये , और Check करते रहियेगा !
Topic Related Posts
- 100 Basic Computer Related G.K. Questions
- 555+ Computer Questions And Answers MCQ – Sawaal
- Computer General Knowledge Questions And Answers
- Top 100 Basic Computer Question and Answer
- Computer Questions and Answers
- 5000+ Computer Question And Answers PDF For All Exams
- Top 100 Basic Computer Questions and Answers
MS Excel Questions and Answers
1. What function displays row data in a column or column data in a row? | Ms Excel Mcqs
2. When you insert an Excel file into a Word document, the data are ______. | Ms Excel Mcqs
3. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result. | Ms Excel Mcqs
4. Macros are “run” or executed from the ….. Menu. | Ms Excel Mcqs
5. You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu. | Ms Excel Mcqs
6. Each excel file is called a workbook because | Ms Excel Mcqs
More Related PDF Download
|SSC Exams Latest News and Updates||Quantitative Aptitude (Maths)|
|Current Affairs||Reasoning and General Intelligence|
|English Grammar and Comprehension||General Knowledge (GK)|
|SSC CGL Exam||CPO SI Exam|
|SSC CHSL (10+2) Exam||Stenographer Group C and D Exam|
7. Which types of charts can excel produce? | Ms Excel Mcqs
MS Excel Questions and Answers
8. How are data organized in a spreadsheet? | Ms Excel Mcqs
9. What does the VLOOKUP function do? | Ms Excel Mcqs
Q #1) How can Microsoft Excel be described in short?
Answer: Microsoft Excel is a software or a computer application that can be used as a repository of information in the form of rows and columns. It is available in most operating systems like Mac, Windows, Androids and so on.
Microsoft Excel has the following characteristics:
Q #2) What are cells inside Microsoft Excel?
As shown above, a cell can be defined as a portion that comes at the junction of horizontal rows and vertical columns in Excel. The address of each cell can be seen at the top left corner of the application.
In the image posted above, we can see ‘A1’, by default, the first address of the cell is always shown while we open an Excel workbook. It is basically the fusion of the column letter and the row number and is distinctive in nature.
Q #3) Explain the characteristics of a spreadsheet.
Answer: A group of cells is called a spreadsheet or worksheet. Its purpose is to arrange formulas, functions and sort numbers and data in rows and columns. They can be operated mathematically. The number of worksheets in a workbook can be more than one.
As shown below, there are two worksheets (‘Sheet1’ and ‘Added’) at the bottom. We can add, delete, rename, hide, unhide and perform other operations on sheets. By default, the sheets get added as Sheet1, Sheet2. Here, we have renamed Sheet2 as ‘Added’.
Q #4) Can we rearrange cells in Excel?
Excel provides us the option of rearranging cells by insertion and deletion in the following ways:
While we are inserting a row or a column in Excel, we end up shifting the cells, thereby resulting in a rearrangement of cells.
Q #5) How is the formatting of data achieved in MS Excel cells?
Answer: Some of the data formatting ways for cells are in terms of Number, Alignment, Font, Border, Fill and Protection.
Q #6) How to incorporate comments in MS Excel cells?
Answer: Comments can be added to a specific cell by doing a right-click and selecting insert the comment option. The cell which has a comment shall have a red/purple mark on the right upper corner for identification purpose. We can also edit, delete and reply to a comment.
Please note the cell under column L, having a comment added and how it’s different from a cell without a comment.
Q #7) Explain the features of the ribbon in MS Excel.
Answer: The ribbon appears at the top of the application. Users can access most of the common functionalities of Excel using the toolbars and menus that form a part of the ribbon.
The user also has the option of customizing the ribbon. For example, we often add the ‘Developer’ tab on the ribbon. On a need basis, we can also remove or add an option with the help of CTRL+F1.
Q #8) Explain the significance of Freezing Panes in Microsoft Excel.
Answer: Sometimes we need to have the view of headers of the columns and rows even if we scroll to a large extent up or down. In other words, in freeze panes, we are fastening up a row or a column.
Freeze pane is first achieved by selecting the cell than from View and we need to select one of the freeze options.
Q #9) How to enable Protection in MS Excel?
Protection is achieved in three forms:
Q #10) What is Relative Cell Address?
Answer: The Relative Cell Address is a type of cell reference in Microsoft Excel that is modified and replaced while the Autofill feature is used or while copied.
Q #11) What is the Absolute Cell Address?
Answer: Sometimes there are scenarios when the cell address must remain unchanged while the Autofill feature is used or while copied. This is called an absolute cell address. The ’$’ sign is used to keep the column and row address constant.
Q #12) How to protect cells of a worksheet from being copied?
Answer: We can protect the cells of a worksheet from being copied by navigating the ‘Review’ menu bar => Protect Sheet and then provide the password.
Once we protect the sheet, we can unprotect it by the ‘Unprotect Sheet’ option.
Thus once a cell is protected, the formula behind the cell is hidden.
Q #13) How do we have Named Ranges in Microsoft Excel?
Answer: We can have a named range by selecting a range that we want to name. Then select Formulas from Ribbon => Define Names => Provide the Name.
Q #14) What are Macros?
Answer: A macro is a step or a group of steps that we perform more than once. We can develop a macro for these tedious tasks. Macros are generally coded or recorded by the users
Learn more =>> What are Macros in Excel?
Q #15) Name the types of Report Formats available.
Answer: There are three types of formats available for reports i.e. Tabular, Compact, and Report.
Q #16) What is a Dropdown List in Excel?
Answer: Dropdown list in Excel is created by following the below steps:
Go to Data in the Ribbon => Select Data Validation => Select List from the Allow Dropdown => Add the values you want to add to the list under the Source field.
Join our Social Media Platforms
Tags:-advanced excel interview questions and answers pdf,advanced excel interview questions and answers for data analyst,ms excel interview questions and answers,excel interview questions vlookup,basic excel interview questions and answers for freshers,vlookup interview questions and answers pdf,excel questions and answers pdf,excel interview questions for accountants