Interview Questions on Data Analytics

What is a Print Area and how can you set it in Excel?

by

A Print Area in Excel is a range of cells that you designate to print whenever you print that worksheet. For example, if you just want to print the first 20 rows from the entire worksheet, then you can set the first 20 rows as the Print Area. Now, to set the Print Area in … Read more

What are the most common questions you should ask a client before creating a dashboard?

by

Well, the answer to this question varies on a case-to-case basis. But, here are a few common questions that you can ask while creating a dashboard in Excel. Purpose of the Dashboards Different data sources Usage of the Excel Dashboard The frequency at which the dashboard needs to be updated The version of Office the … Read more

How can we select all blank cells in Excel?

by

If you wish to select all the blank cells in Excel, then you can use the Go To Special Dialog Box in Excel. Below are the steps that you can follow to select all the blank cells in Excel. First, select the entire dataset and press F5. This will open a Go To Dialog Box. … Read more

Can you make a Pivot Table from multiple tables?

by

Yes, we can create one Pivot Table from multiple different tables when there is a connection between these tables. Yes, you can create a pivot table from multiple tables by using data modeling techniques such as data blending or data consolidation. Here are a few common methods: Data Blending: This involves combining data from multiple … Read more

What is a Pivot Table, and what are the different sections of a Pivot Table?

by

A Pivot Table is a simple feature in Microsoft Excel which allows you to quickly summarize huge datasets. It is really easy to use as it requires dragging and dropping rows/columns headers to create reports. A Pivot table is made up of four different sections: Values Area: Values are reported in this area Rows Area: … Read more