Top 50 Excel Interview Questions and Answers in 2022

0
Share this post with your friends

Top 50 Excel Interview Questions and Answers 

Hello Students,

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 करते रहियेगा !

 

 Top 50 Excel Interview Questions and Answers in 2022  के अलाबा अन्य सभी बिषयों की PDF से संबंधित पोस्ट भी हमारी इस बेबसाइट पर उपलब्ध हैं, तो आप इस बेबसाइट को Regularlly Visit करते रहिये ! कृपया कमेन्ट के माध्यम से जरूर बतायें कि आपको कौन से बिषय पर PDF चाहिये !

      Topic Related Posts

 MS Excel Questions and Answers 

 1.    What function displays row data in a column or column data in a row? | Ms Excel Mcqs

a.   Hyperlink

b.   Index

c.   Transpose

d.   Rows

Answer: c

2.    When you insert an Excel file into a Word document, the data are ______. | Ms Excel Mcqs

a.   Hyperlinked

b.   Placed in a word table

c.   Linked

d.   Embedded

Answer: b

3.    Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result. | Ms Excel Mcqs

a.   IF

b.   AND

c.   OR

d.   NOT

Answer: a

4.    Macros are “run” or executed from the ….. Menu. | Ms Excel Mcqs

a.   Insert

b.   Format

c.   Tools

d.   Data

Answer: c

5.    You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu. | Ms Excel Mcqs

a.   Insert

b.   Format

c.   Tools

d.   Data

Answer: d

6.    Each excel file is called a workbook because | Ms Excel Mcqs

a.   It can contain text and data

b.   It can be modified

c.   It can contain many sheets including worksheets and chart sheets

d.   You have to work hard to create it

Answer: c

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

a.   Line graphs and pie charts only

b.   Only line graphs

c.   Bar charts, line graphs and pie charts

d.   Bar charts and line graphs only

Answer: c

 MS Excel Questions and Answers 

8.    How are data organized in a spreadsheet? | Ms Excel Mcqs

a.   Lines and spaces

b.   Layers and planes

c.   Rows and columns

d.   Height and width

Answer: c

9.    What does the VLOOKUP function do? | Ms Excel Mcqs

a.   Looks up text that contain ‘v’

b.   Checks whether text is the same in one cell as in the next

c.   Finds related records

d.   All of above

Answer: c

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:

  • Workbooks, worksheets, cells, and rows operation make it user-friendly and also make data verification and validation easier.
  • Functions like count, sum, subtotal, date and much more that may be utilized to a large extent.
  • Data visualization and its examination can be achieved with tables, filters, graphs and so on.
  • Visual Basic Application in Excel extends support to programming.

Q #2) What are cells inside Microsoft Excel?

Answer:

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’.

characteristics of a spreadsheet

Q #4) Can we rearrange cells in Excel?

Answer:

Excel provides us the option of rearranging cells by insertion and deletion in the following ways:

  • Shifting cells to the right
  • Shifting cells down
  • Inserting/Deleting entire row
  • Inserting/Deleting entire column
  • Shifting cells to left
  • Shifting cells up

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.

formatting of data

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.

incorporate comments

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?

Answer:

Protection is achieved in three forms:

  • Protection via password on the opening of the workbook.
  • Protection against hide/unhide/add/deletion of worksheets.
  • Window sizes/positions are protected from being modified.

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.

protect cells of a worksheet

Once we protect the sheet, we can unprotect it by the ‘Unprotect Sheet’ option.

Unprotect Sheet

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.

Dropdown List in Excel

Download pdf

Disclaimer: SSCResult.in neither created this pdf file nor scanned, This PDF/eBook was downloaded from internet and we have shared link of this file on SSCResult.in website or we have shared the drive link/any kind of link, which is already available on Internet. Note – We don’t want to violate any privacy policy or copyright law. In short, If anyone has any kind of objection related to this PDF then kindly mail us at sscexamsresult@gmail.com to request removal of the link. We will remove this link/PDF as soon as possible.

Join our Social Media Platforms

Dear friends you can help us by joining and shearing our social media platforms with your friends. Here we are sharing the links of Telegram channelFacebook page and YouTube Channel.

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

Leave A Reply

Your email address will not be published.

error: Content is protected !!