P S Joglekar & Co Interview Questions and Answers

I don't have the available data.

SAP, WPS, and last mile can be used together to optimize supply chain management.

• SAP can be used for inventory management and tracking.

• WPS can be used for workforce management and scheduling.

• Last mile can be used for optimizing delivery routes and reducing transportation costs.

• Integrating these tools can lead to more efficient and cost-effective supply chain management.

• For example, SAP can provide real-time inventory data to WPS, allowing for more accurate scheduling of deliv...read more

Utilize filters, search, and sorting to efficiently find specific data in a spreadsheet.

• Apply filters by selecting the filter icon and choosing criteria, e.g., filtering sales data to show only transactions over $1000.

• Use the search function (Ctrl + F) to quickly locate keywords, such as finding all instances of 'urgent' in a project list.

• Sort data by clicking on column headers, e.g., sorting a list of employees by their hire date to see the most recent hires.

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

• Select the cell where you want to display the result

• Type =VLOOKUP(

• Enter the value you want to search for

• Enter the range of cells where you want to search for the value

• Enter the column number of the value you want to return

• Enter FALSE to find an exact match or TRUE to find an approximate match

• Close the parentheses and press Enter

Pivot tables are used to summarize and analyze large datasets in Excel.

• Select the data range you want to analyze

• Go to Insert > PivotTable

• Choose the fields you want to include in the table

• Drag and drop fields to create rows, columns, and values

• Use filters to narrow down the data

• Example: Analyze sales data by region, product, and month to identify trends

• Example: Summarize survey responses by age group and gender to compare results

• Example: Calculate average test scores by class ...read more

Email should be concise, clear, and professional.

• Use a clear and concise subject line

• Keep the email brief and to the point

• Use proper grammar and spelling

• Avoid using all caps or excessive exclamation points

• Include a clear call to action or next steps

• Proofread before sending

• Avoid sensitive or confidential information

• Reply promptly to emails

• Use a professional email signature

RPC stands for Remote Procedure Call, a protocol that allows a computer program to cause a subroutine or procedure to execute in another address space.

• RPC is a communication protocol used in distributed computing.

• It allows a program to execute code on a remote server as if it were local.

• Examples of RPC implementations include gRPC, Apache Thrift, and XML-RPC.