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

What is the purpose of the TRANSPOSE function?

What is the shortcut for pasting values only in Excel?

Which feature is used to create a visual representation of data?

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

How do you use the REPLACE function?

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

Which function calculates the standard deviation of a dataset?

How do you apply conditional formatting to a cell range?

What function is used to calculate the internal rate of return for a series of cash flows?

How do you use the SUBTOTAL function?

What does the COUNTIF function do?

What is the purpose of the OFFSET function?

How do you create a pivot table?

What is the purpose of the MATCH function?

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

How do you create a dynamic named range in Excel?

How do you hide columns in Excel?

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

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

What does VLOOKUP stand for?

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

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

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

How do you create a macro in Excel?

Which function calculates the average of a range excluding zeros?

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

How do you freeze panes in Excel?

What is the use of the PMT function in Excel?

What is the purpose of the SUMIF function?