Accenture Excel Interview Questions

2 What is Data Validation? Illustrate with an example.

Data Validation restricts the type of values that a user can enter into a particular cell or a range of cells.

In the Data tab, select the ‘Data Validation’ option present under Data Tools.Â

Select the kind of data validation you want to apply.

In the following example, we have applied data validation to the ‘Name’ column to accept only text values. If you enter something other than a text, it will throw an error.

How do you freeze panes in Excel?

Freeze panes keep the rows and columns visible while scrolling through a worksheet. To freeze panes, select the View tab and go to Freeze Panes.

If you are looking to freeze the first two columns of a dataset, select the 3rd column, and click ‘Freeze Panes’. A thick grey border indicates this.

1 What is a Pivot Table?

A pivot table is like a summary table of the dataset that enables you to create reports and analyze trends. They are useful when you have long rows or columns that hold values you need to track.Â

To create a pivot table, first, go to the Insert tab and select the ‘PivotTable’ option.

Select the table or the range and choose where you want to place the pivot table.

Drag the fields you wish to show in the pivot table. Here we have created a pivot table using the Coronavirus data.

4 How do you find the last row and column in VBA?

To find the last row, use the below lines code in the VBA module:

To find the last column, use the below lines code in the VBA module:

1 What is the use of VLOOKUP and how do we use it?

The function VLOOKUP in Excel is used to look up information in a table and extract the corresponding data.Â

Syntax:Â VLOOKUP (value, table, col_index, [range_lookup])

              value – Indicates the data that you are looking for in the first column of        a table.

              table - Refers to the set of data (table) from which you have to retrieve        the above value.

              col_index – Refers to the column in the table from where you are to           retrieve the value.

              range_lookup – FALSE = exact match [optional] TRUE = approximate          match (default).Â

Shown below is an example of the VLOOKUP function. We are to find the Product related to the Customer Name – “Richard”.

4 How do we check whether a file exists or not in a specified location?

    strFileName = “File locationfile_name.xlsx”

    strFileExists = Dir(strFileName)

   If strFileExists = “” Then

        MsgBox “The selected file doesnt exist”

        MsgBox “The selected file exists”

    End If

3 Using the Coronavirus dataset, create a pivot table to find the total cases in each country belonging to their respective continents.

First, drag the continent and country columns into rows. After that, drag the cases column on to the values section.

Accenture Interview Q&A – Excel (Pivot Table) | Accenture Excel Interview Questions and Answers