Arval Interview Questions and Answers

Google Sheets is a cloud-based spreadsheet program while Excel is a desktop-based spreadsheet program.

• Google Sheets is free to use while Excel requires a license.

• Google Sheets can be accessed from anywhere with an internet connection while Excel is limited to the device it is installed on.

• Google Sheets allows for real-time collaboration while Excel requires files to be shared and merged.

• Excel has more advanced features and functions than Google Sheets.

• Google Sheets has built-...read more

Google Sheets is a web-based spreadsheet program that allows users to create, edit, and collaborate on spreadsheets online.

• Google Sheets is part of the Google Drive suite of productivity tools.

• It offers features like formulas, charts, conditional formatting, and data validation.

• Multiple users can work on the same spreadsheet simultaneously and see real-time changes.

• It can be accessed from any device with an internet connection.

• Google Sheets supports importing and exporting da...read more

Google Forms is a survey administration app that allows users to create and share surveys online.

• Users can customize the design and layout of their surveys

• Responses are automatically collected and can be viewed in real-time

• Google Forms can be used for event registration, feedback collection, and more

Arrayformula is a function in Google Sheets that allows users to apply a formula to an entire column or row.

• Arrayformula is used to save time and effort in applying a formula to multiple cells.

• It can be used to perform calculations, manipulate text, and more.

• The formula used in Arrayformula must be designed to work with arrays of data.

• Example: =Arrayformula(A2:A10*B2:B10) will multiply each cell in column A with the corresponding cell in column B.

• Example: =Arrayformula(LEFT(A...read more

Countifs function is used to count the number of cells that meet multiple criteria.

• It is a built-in function in Microsoft Excel.

• It can count cells based on multiple criteria in the same or different ranges.

• The syntax is COUNTIFS(range1, criteria1, [range2], [criteria2], ...)

• Example: COUNTIFS(A1:A10,">=50",B1:B10,"<=100") will count the number of cells in range A1:A10 that are greater than or equal to 50 and in range B1:B10 that are less than or equal to 100.

INDEX MATCH() function is used to lookup values in a table by matching data in two or more columns.

• INDEX function returns the value of a cell in a table based on the column and row number.

• MATCH function returns the position of a cell in a row or column.

• Combining INDEX and MATCH functions allows for more flexible lookups in a table.

• Example: =INDEX(A1:B10,MATCH("John",A1:A10,0),2) will return the value in column B for the row where column A matches "John".