How do you apply conditional formatting to a cell range?

Which function is used to calculate the future value of an investment?

Which Excel function returns the next highest integer?

What is the shortcut key for creating a new worksheet in Excel?

Which function calculates the average of a range excluding zeros?

What does VLOOKUP stand for?

How do you use the REPLACE function?

How do you create a dynamic named range in Excel?

What does the COUNTIF function do?

Which function is used to find the median value of a set of numbers?

Which function can be used to check if a cell contains an error?

What function would you use to return a value from a specific row and column in a table?

How do you create a macro in Excel?

Which function is used to return the largest value in a range?

Which function is used to return the current date and time?

Which function is used to return the number of characters in a text string?

Which function can be used to calculate the present value of an investment?

What is the purpose of the SUMIF function?

Which function is used to find the smallest number in a range?

Which function is used to look up a value in a table and return a corresponding value from another column?

How do you protect a worksheet from being edited?

What is the purpose of the INDEX function?

How can you remove duplicate values from a dataset?

How can you use the IF function to test multiple conditions?

Which Excel function can be used to count the number of cells that contain numbers?

What is the purpose of the TEXT function?

How do you freeze panes in Excel?

How do you use the HYPERLINK function in Excel?

Which function is used to find the mode of a dataset?

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