Font size
WorksheetsExcel en ingles
Total questions: 17
Worksheet time: 14mins
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) .
What is the formula to look up a value in a table and return a corresponding value from another column using the XLOOKUP function?
=XLOOKUP(A2, B:B, C:C, FALSE)
=VLOOKUP(A2, B:C, 2, FALSE)
=INDEX(C:C, MATCH(A2, B:B, 0))
=HLOOKUP(A2, B:C, 2, FALSE)
What is the formula to calculate the sum of a range of cells that meet a specific condition using the SUMIF function?
=SUMIF(A:A, ">10", B:B)
=SUMIF(A:A, ">10")
=SUMIFS(A:A, B:B, ">10")
=SUMIFS(A:A, B:B, ">10", C:C, "<20")
What is the formula to perform a conditional calculation using the IF function?
=IF(value_if_true, condition, value_if_false)
=IF(condition, value_if_true, value_if_false)
=IF(condition, value_if_false, value_if_true)
=IF(value_if_false, value_if_true, condition)
What is the formula to perform a lookup operation using the INDEX and MATCH functions?
=LOOKUP(A2, B:C)
=VLOOKUP(A2, B:C, 2, FALSE)
=HLOOKUP(A2, B:C, 2, FALSE)
=INDEX(C:C, MATCH(A2, B:B, 0))
What is the formula to calculate the sum of a range of cells that meet multiple conditions using the SUMIFS function?
=SUMIFS(A:A, B:B, ">10", C:C, "<20")
=SUMIF(A:A, ">10")
=SUMIF(A:A, "<20")
=SUM(A:A)
How do you use the "IF" function in Excel to make decisions based on a condition?
By applying conditional formatting to the cells
By using the formula =IF(condition, value_if_true, value_if_false)
By creating a pivot table to summarize data
By using the VLOOKUP function to find values
Which of the following is the correct IF formula to display "Greater than 10" if the value in cell A1 is greater than 10, and "Less than or equal to 10" otherwise?
=IF(A1=10, "Equal to 10", "Not equal to 10")
=IF(A1<10, "Less than 10", "Greater than or equal to 10")
=IF(A1>10, "Greater than 10", "Less than or equal to 10")
=IF(A1>=10, "Greater than or equal to 10", "Less than 10")
