Excel en ingles

How do you filter data in Excel?

• By using the "Sort" button in the "Data" tab

• By using the "Conditional Formatting" feature

• By using the "PivotTable" feature

• By using the "Filter" button in the "Data" tab

What is a pivot table in Excel?

• A table that displays data in a chart format

• A table that summarizes and analyzes large amounts of data

• A table that filters data based on specific conditions

• A table that sorts data in ascending or descending order

What is the purpose of the "Conditional Formatting" feature in Excel?

• To highlight cells that meet specific conditions

• To hide cells that meet specific conditions

• To delete cells that meet specific conditions

• To insert cells that meet specific conditions

The purpose of the "Data Validation" feature in Excel is to:

• Restrict the type of data or values that can be entered into a cell

• Automatically format cells based on their values

• Sort data in ascending or descending order

• Create charts and graphs from data

What is the purpose of the "AutoSum" feature in Excel?

• To automatically count a range of cells

• To automatically average a range of cells

• To automatically count a range of cellsTo automatically sum a range of cells

• To automatically format a range of cells

How do you create a drop-down list in Excel?

• By using the "Data Validation" feature

• By using the "Conditional Formatting" feature

• By using the "PivotTable" feature

• By using the "Chart" feature

The formula to calculate the sum of a range of cells that meet a specific condition is:

• COUNTIF

• SUMIF

• AVERAGEIF

• SUM

What is the formula to look up a value in a table and return a corresponding value from another column?

• =VLOOKUP(A2, B:C, 2, FALSE)

• =INDEX(C:C, MATCH(A2, B:B, 0))

• =HLOOKUP(A2, B:C, 2, FALSE)

• =LOOKUP(A2, B:C)

What is the formula to calculate the average of a range of cells that meet multiple conditions?

• =MAXIFS(A:A, B:B, ">10", C:C, "<20")

• =SUMIFS(A:A, B:B, ">10", C:C, "<20")

• =COUNTIFS(A:A, B:B, ">10", C:C, "<20")

• =AVERAGEIFS(A:A, B:B, ">10", C:C, "<20")

What is the formula to perform an array operation on a range of cells? The formula is (a)   .

• =SUM(A:A_B:B)
• =AVERAGE(A:A_B:B)
• =COUNT(A:A_B:B)
• =MAX(A:A_B:B)