Guardian India Interview Questions and Answers

Alt + D + P is the shortcut key for creating a pivot table in Excel.

• Press Alt key

• Press D key

• Press P key

• Release all keys

Ctrl + D is the shortcut key for duplicating values.

• Press Ctrl + D to duplicate values in Excel or Google Sheets.

• This shortcut can be used to quickly copy and paste values within a spreadsheet.

• Ctrl + D can also be used to duplicate objects in design software like Adobe Illustrator.

Yes, I have basic knowledge of computers including proficiency in Microsoft Office Suite and internet browsing.

• Proficient in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

• Familiar with internet browsing and search engines

• Basic troubleshooting skills for common computer issues

Hloocup formula is used in chemistry to calculate the number of moles of a substance.

• Hloocup formula is used to convert mass of a substance to moles.

• The formula is: Moles = Mass / Molar mass

• For example, to find the number of moles in 10 grams of carbon (C), with a molar mass of 12 g/mol, the calculation would be: Moles = 10g / 12g/mol = 0.83 moles

Yes, pivot tables are used in Excel to summarize and analyze data.

• Pivot tables are used in Excel to organize and summarize data from a larger table.

• They allow users to rearrange and manipulate data to gain insights and make data-driven decisions.

• Pivot tables can be used to calculate sums, averages, counts, and other functions on data.

• For example, you can use a pivot table to analyze sales data by product category or region.

A supervisor is a person responsible for overseeing and directing the work of a group of employees.

• Supervisors provide guidance, support, and feedback to employees

• They ensure that work is completed efficiently and according to company standards

• Supervisors may also handle disciplinary actions and performance evaluations

• Examples: Team leader, manager, foreman

MIS stands for Management Information System, which is a computerized database that collects, processes, and presents information to support decision-making within an organization.

• MIS helps in organizing and analyzing data to provide managers with information needed for decision-making.

• It includes software systems, hardware, people, procedures, and data.

• Examples of MIS include customer relationship management (CRM) systems, inventory management systems, and financial systems.