Excel Interview Question & Anwers for Data Analytics Interview✅
[Part-1]
What is Excel and what are its primary uses?
Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Its primary uses include creating spreadsheets, performing calculations, and making charts.
How do you open a new workbook in Excel?
To open a new workbook in Excel, you can either click on "File" in the menu, then select "New" and "Blank Workbook," or you can press "Ctrl + N" on your keyboard.
Explain the difference between a workbook and a worksheet.
A workbook is like a file that contains all your data and is made up of one or more worksheets. Worksheets are the individual pages within a workbook where you enter and manipulate data.
How do you navigate between different worksheets in Excel?
To move between different worksheets in Excel, you can click on the tabs at the bottom of the Excel window. Each tab represents a different worksheet.
Like for more 😄
Join: https://news.1rj.ru/str/excel_analyst
[Part-1]
What is Excel and what are its primary uses?
Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Its primary uses include creating spreadsheets, performing calculations, and making charts.
How do you open a new workbook in Excel?
To open a new workbook in Excel, you can either click on "File" in the menu, then select "New" and "Blank Workbook," or you can press "Ctrl + N" on your keyboard.
Explain the difference between a workbook and a worksheet.
A workbook is like a file that contains all your data and is made up of one or more worksheets. Worksheets are the individual pages within a workbook where you enter and manipulate data.
How do you navigate between different worksheets in Excel?
To move between different worksheets in Excel, you can click on the tabs at the bottom of the Excel window. Each tab represents a different worksheet.
Like for more 😄
Join: https://news.1rj.ru/str/excel_analyst
👍4
1.How to create filters in Power BI?
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
👍4
You can download them from our WhatsApp channel: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
WhatsApp.com
Python Programming
Channel • 2.3M followers • Perfect channel to learn Python Programming 👨💻👩💻
- ✅ Free Courses
- ✅ Coding Projects
- ✅ Important Pdfs
- ✅ Artificial Intelligence Bootcamps
- ✅ Data Science Notes
- ✅ Latest Tech & AI Trends
For promotions, contact theda…
- ✅ Free Courses
- ✅ Coding Projects
- ✅ Important Pdfs
- ✅ Artificial Intelligence Bootcamps
- ✅ Data Science Notes
- ✅ Latest Tech & AI Trends
For promotions, contact theda…
Walmart Data Analyst Interview Questions: Python & SQL ✅
👍2
Data visualization tools
Data visualization tools provide you with an easier way to create visual representations of large data sets. When dealing with data sets that include bunches of data points, automating the process of creating a visualization, at least in part, makes your job significantly easier.
The best data visualization tools on the market should have one important thing in common. It is their ease of use. The best tools can also handle huge sets of data. And the last but not least, they can output an array of different chart, graph, and map types.
There are hundreds, of applications, tools, and noscripts available to create visualizations of large data sets. Many are very basic and have a lot of overlapping features.
- Tableau (and Tableau Public
Hundreds of data import options. Mapping capability. Free public version available. Lots of video tutorials to walk you through how to use Tableau.
- Infogram
Tiered pricing, including a free plan with basic features. Includes 35+ chart types and 550+ map types. Drag and drop editor. API for importing additional data sources.
- ChartBlocks
Free and reasonably priced paid plans are available. Easy to use wizard for importing the necessary data.
- Datawrapper
Specifically designed for newsroom data visualization. Free plan is a good fit for smaller sites. Tool includes a built-in color blindness checker.
- D3.js
A JavaScript library for manipulating documents using data. Very powerful and customizable. Huge number of chart types possible. A focus on web standards. Tools available to let non-programmers create visualizations. Free and open source.
- Looker Studio (Google Data Studio)
Free data visualization tool that is specifically for creating interactive charts for embedding online. Easily access a wide variety of data.
- FusionCharts
A JavaScript-based option for creating web and mobile dashboards. Huge number of chart and map format options. More features than most other visualization tools. Integrates with a number of different frameworks and programming languages.
- Chart.js
A simple but flexible JavaScript charting library. Free and open source. Responsive and cross-browser compatible output.
- Grafana
Open source, with free and paid options available. Large selection of data sources available. Variety of chart types available. Makes creating dynamic dashboards simple. Can work with mixed data feeds.
Data visualization tools provide you with an easier way to create visual representations of large data sets. When dealing with data sets that include bunches of data points, automating the process of creating a visualization, at least in part, makes your job significantly easier.
The best data visualization tools on the market should have one important thing in common. It is their ease of use. The best tools can also handle huge sets of data. And the last but not least, they can output an array of different chart, graph, and map types.
There are hundreds, of applications, tools, and noscripts available to create visualizations of large data sets. Many are very basic and have a lot of overlapping features.
- Tableau (and Tableau Public
Hundreds of data import options. Mapping capability. Free public version available. Lots of video tutorials to walk you through how to use Tableau.
- Infogram
Tiered pricing, including a free plan with basic features. Includes 35+ chart types and 550+ map types. Drag and drop editor. API for importing additional data sources.
- ChartBlocks
Free and reasonably priced paid plans are available. Easy to use wizard for importing the necessary data.
- Datawrapper
Specifically designed for newsroom data visualization. Free plan is a good fit for smaller sites. Tool includes a built-in color blindness checker.
- D3.js
A JavaScript library for manipulating documents using data. Very powerful and customizable. Huge number of chart types possible. A focus on web standards. Tools available to let non-programmers create visualizations. Free and open source.
- Looker Studio (Google Data Studio)
Free data visualization tool that is specifically for creating interactive charts for embedding online. Easily access a wide variety of data.
- FusionCharts
A JavaScript-based option for creating web and mobile dashboards. Huge number of chart and map format options. More features than most other visualization tools. Integrates with a number of different frameworks and programming languages.
- Chart.js
A simple but flexible JavaScript charting library. Free and open source. Responsive and cross-browser compatible output.
- Grafana
Open source, with free and paid options available. Large selection of data sources available. Variety of chart types available. Makes creating dynamic dashboards simple. Can work with mixed data feeds.
👍2