Theeta Electricals Interview Questions, Process, and Tips

Countif formula is used to count the number of cells in a range that meet a specific condition.

• Syntax: =COUNTIF(range, criteria)

• Range can be a single cell or a range of cells

• Criteria can be a number, text, cell reference, or expression

• Examples: =COUNTIF(A1:A10,">50") will count the number of cells in range A1:A10 that are greater than 50

• =COUNTIF(B1:B10,"apples") will count the number of cells in range B1:B10 that conta

Data can be summarised by using statistical measures like mean, median, mode, and range.

• Identify the purpose of the summary

• Choose appropriate statistical measures

• Calculate the measures

• Present the summary in a clear and concise manner

• Use visual aids like charts and graphs if necessary

Vlookup and Hlookup are Excel functions used to search for specific data in a table and return corresponding values.

• Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup searches for a value in the first row of a table and returns a value in the same column from a specified row.

• Both functions require a lookup value, table array, column index numb...read more

Data validation is used to ensure that data entered into a system meets certain criteria.

• Data validation can be used to prevent errors and ensure accuracy.

• It can be used to restrict input to certain values or formats.

• Examples include validating email addresses, phone numbers, and dates.

• Data validation can also be used to ensure that required fields are filled out.

• It can be implemented through programming or through bui

Importrange function is used to import data from one Google sheet to another.

• Open the Google sheet where you want to import data

• In a cell, type =importrange("spreadsheet_url", "Sheet1!A1:B10")

• Replace spreadsheet_url with the URL of the sheet you want to import from

• Replace Sheet1!A1:B10 with the range of cells you want to import

• Click enter and grant access to the sheet you want to import from

• Data from the specified rang...read more