Data Analytics Quiz -9

What does the "VLOOKUP" function in Excel do?

• Calculates the average of a range

• Searches for a specified value in a range and returns a corresponding value from another column

• Filters data based on conditions

• Inserts a new row in a worksheet

Which Excel feature is commonly used for creating visually appealing charts and graphs?

• AutoSum

• PivotTables

• Data Validation

• Chart Wizard

In Excel, what is the function of the "COUNTIF" formula?

• It calculates the sum of a range of numbers.

• It counts the number of cells that meet a specified condition.

• It performs a text-to-columns operation.

• It converts text to numbers.

What is the purpose of the "Freeze Panes" feature in Excel?

• It prevents unauthorized users from accessing the worksheet.

• It locks a specific range of cells to keep them visible while scrolling.

• It applies a filter to a column.

• It converts data into a table.

Which Excel function is used to calculate the total sum of a range of cells?

• AVERAGE

• MAX

• SUM

• COUNT

What does the "Concatenate" function do in Excel?

• It multiplies numbers in a range.

• It combines text from multiple cells into a single cell.

• It counts the number of characters in a cell.

• It divides a range of numbers.

How can you protect an Excel worksheet from unauthorized changes?

• Apply conditional formatting

• Use the "Find and Replace" tool

• Set a password to protect the sheet

• Apply a custom number format

What is the purpose of the "Transpose" function in Excel?

• It rearranges data to switch rows and columns.

• It applies formatting to cells.

• It filters data based on specified conditions.

• It calculates the average of selected cells.

What does the "IF" function in Excel allow you to do?

• Insert a new row in a worksheet

• Perform conditional calculations based on specified criteria

• Create a hyperlink in a cell

• Count the number of cells in a range

How can you add a comment to a cell in Excel?

• Double-click the cell

• Right-click the cell and select "Insert Comment"

• Use the "AutoSum" function

• Apply a filter to the cell