Excel Functions and Shortcuts Quiz

Which function calculates the average of a range of cells, ignoring any text values?

AVERAGE

What is the keyboard shortcut to create a new worksheet in Excel?

Shift + F11

Which feature allows you to visually inspect the relationships between formulas and cells?

Trace Dependents

In Excel 365, which function can be used to filter data based on a condition and return a specified range?

FILTER Signup and view all the answers

What is the use of the CONCAT function in Excel?

To combine text from multiple cells Signup and view all the answers

Which chart type is best for showing the distribution of data?

Histogram Signup and view all the answers

What is the default file extension for an Excel workbook?

.xlsx Signup and view all the answers

Which Excel function checks if a condition is met and returns one value if true and another value if false?

IF Signup and view all the answers

What is the purpose of the INDEX function in Excel?

To return the value of an element in a table or array Signup and view all the answers

Which function would you use to find the current date in Excel?

TODAY Signup and view all the answers

In Excel 365, which dynamic array function returns a unique list of values from a range?

UNIQUE Signup and view all the answers

Which Excel feature allows you to split the screen into multiple panes?

Split Signup and view all the answers

What is the use of the MATCH function in Excel?

To return the position of a value in a list Signup and view all the answers

Which tool in Excel allows you to summarize large datasets using interactive tables?

PivotTable Signup and view all the answers

What does the VLOOKUP function do in Excel?

Looks up data vertically in a table Signup and view all the answers

In Excel 365, what is the function of the LET function?

To assign names to calculation results Signup and view all the answers

Which of the following options allows you to protect a worksheet from changes?

Protect Sheet Signup and view all the answers

Which Excel function would you use to join several text strings into one text string?

CONCATENATE Signup and view all the answers

What is the purpose of the conditional formatting feature in Excel?

To change the format of cells based on their value Signup and view all the answers

Which Excel feature allows you to apply a predefined style to your data?

Styles Signup and view all the answers