top of page

If you rename a column in an Excel Table, what happens to formulas referencing that column?

They break
They automatically update
They show errors
Nothing happens

How do you remove duplicate values from an Excel Table?

Use the Remove Duplicates
Sort the data and manually delete
Apply a filter
Use a Pivot Table

Which function would you use to find the average of a range of cells that meet a condition?

SUMIF
AVERAGE
AVERAGEIF
COUNTIF

How do you correctly write a VLOOKUP formula?

=VLOOKUP(lookup_value, table_array, col_index_num)
=VLOOKUP(table_array, lookup_value, col_index_num)
=VLOOKUP(lookup_value, col_index_num, table_array)
=VLOOKUP(col_index_num, lookup_value, table_array)

What does the formula =IF(A1 > 10, "Yes", "No") do?

Returns "Yes" if A1 > 10
Adds 10 to A1 if A1 > 10
Compares A1 with 10
Returns "No" if A1 > 10

What will =SUM(A1:A10) / COUNT(A1:A10) calculate?

Total sum of values
Average of values
Sum of values divided by count
Count of non-empty cells

Which formula is used to join text from multiple cells?

CONCATENATE
JOIN
MERGE
TEXTJOIN

What is the correct syntax for the IF function?

=IF(condition, value_if_true, value_if_false)
=IF(condition, value_if_true)
=IF(value_if_true, condition, value_if_false)
=IF(condition, value_if_false, value_if_true)

Which function can be used to find the current date in Excel?

=TODAY()
=DATE()
=NOW()
=CURRENTDATE()

In Excel, how do you calculate the number of days between two dates in cells A1 and A2?

=DATEDIF(A1, A2, "d")
=DATEDAYS(A1, A2)
=A2 - A1
=DAYS(A1, A2)

Which function would you use to find the last matching value in a range of data?

VLOOKUP
INDEX
MATCH
LOOKUP

If you want to find the sum of values in column B where column A equals "Sales", what formula?

=SUMIF(A
, "Sales", B
)
=SUMIFS(B
, A
, "Sales")
=IF(A
="Sales", SUM(B
))
=SUM(B
) WHERE A
= "Sales"
bottom of page