Google Sheet Advanced

In Google Sheets, what does the "ARRAYFORMULA" function do?

• It calculates the average of an array of cells

• It applies a formula to an entire range of cells at once.

• It converts a range of cells into an array format.

• It generates a random array of numbers within specified limits.

What does the "IMPORTRANGE" function do in Google Sheets?

• It imports data from an external source into the current sheet.

• It exports data from the current sheet to an external source.

• It imports data and sum it

• It imports and merges data from different workbooks into a single workbook.

In Google Sheets, how can you create a drop-down list in a cell to provide predefined options for data entry?

• By using the "Data Validation" feature.

• By applying conditional formatting rules.

• By using the "Filter Views" feature.

• By using the "Data Sorting" feature.

In Google Sheets, what does the "QUERY" function do?

• It calculates the sum of a range of cells.

• It filters and retrieves data based on specified conditions.

• It converts text to uppercase or lowercase.

• It generates random numbers between specified limits

How can you protect specific cells or ranges in Google Sheets to prevent them from being edited?

• By setting a password for the entire spreadsheet.

• By hiding the cells using formatting options.

• By applying data validation rules to the cells.

• By using the "Protect Sheets and Ranges" feature.

What is the purpose of the "Pivot Table" feature in Google Sheets?

• To merge and combine multiple sheets into a single sheet.

• To perform complex mathematical calculations on data.

• To summarize and analyze large datasets.

• To create and apply custom formatting to cells.

What does the "FILTER" function do in Google Sheets?

• It sorts data in ascending or descending order based on specified criteria

• It extracts rows from a range that meet specified conditions

• It calculates the sum of a range of cells based on specified criteria

• It converts text to uppercase or lowercase.

How can you create a named range in Google Sheets?

• By using the "Named Ranges" feature in the Data menu.

• By applying a custom name to a selected range of cells.

• By using the "Data Validation" feature to define a range name.

• By using the "AutoFill" feature to automatically name a range.

How can you vlookup the data from the different workbook?

• Vlookup + Importrange

• Vlookup + Arrayformula

• Vlookup + Query

• Vlookup + Filter

What is the purpose of the "IMPORTXML" function in Google Sheets?

• To import and extract data from XML files.

• To import and merge data from multiple sheets into a single sheet

• To calculate the sum of a range of cells based on specified criteria.

• To convert a range of cells into XML format.