Anshul Boutique Interview Questions and Answers

Yes, I have experience using ERP software like SAP and Google Sheets for data entry and analysis.

• I have used ERP software like SAP for managing inventory and sales data

• I am proficient in using Google Sheets for data entry and analysis

• I have created and maintained spreadsheets for tracking project progress

Filter or data validation is used to restrict the type of data that can be entered into a cell or range of cells in a spreadsheet.

• Filtering allows you to display only the data that meets certain criteria, hiding the rest.

• Data validation sets rules to control what can be entered in a cell, such as limiting to a specific range of values or requiring a certain format.

• Examples of data validation include setting a dropdown list of options for a cell, restricting input to a certain...read more

Yes, I have knowledge of printing materials.

• Familiar with different types of paper and cardstock

• Understanding of printing techniques such as offset, digital, and screen printing

• Knowledge of various finishes like matte, gloss, and satin

• Awareness of color profiles and printing resolutions

• Experience with handling and maintaining printing equipment

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• Specify the value you want to look up

• Specify the range of cells where the value should be searched

• Specify the column number in the range where the corresponding value should be returned

• Choose whether you want an exact match or an approximate match

Honey combing is a type of concrete surface defect caused by incomplete filling of the formwork resulting in voids or gaps in the concrete.

• Honey combing can weaken the structure and reduce its durability.

• It is important to properly compact the concrete to prevent honey combing.

• Using proper formwork and vibrating equipment can help minimize honey combing.

• Repairing honey combing involves filling the voids with fresh concrete and ensuring proper compaction.

Piles are casted by drilling a hole into the ground and filling it with concrete and reinforcing steel.

• Piles are typically casted by drilling a hole into the ground using specialized equipment.

• Reinforcing steel is then inserted into the hole to provide additional strength.

• Concrete is poured into the hole to fill it up and create the pile.

• Different methods like driven piles, bored piles, and auger-cast piles can be used depending on the soil conditions and project requirements...read more

Yes, I have advanced Excel skills.

• I am proficient in using advanced formulas and functions such as VLOOKUP, INDEX-MATCH, and PivotTables.

• I can create complex charts and graphs to visualize data.

• I have experience in automating tasks using macros and VBA programming.

• I am familiar with data analysis tools such as Solver and Goal Seek.

• I have used Excel for financial modeling and forecasting.

• I am comfortable working with large datasets and can manipulate data using filters and sor...read more