Podcast
Questions and Answers
Which function calculates the average of a range of cells, ignoring any text values?
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?
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?
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?
In Excel 365, which function can be used to filter data based on a condition and return a specified range?
What is the use of the CONCAT function in Excel?
What is the use of the CONCAT function in Excel?
Which chart type is best for showing the distribution of data?
Which chart type is best for showing the distribution of data?
What is the default file extension for an Excel workbook?
What is the default file extension for an Excel workbook?
Which Excel function checks if a condition is met and returns one value if true and another value if false?
Which Excel function checks if a condition is met and returns one value if true and another value if false?
What is the purpose of the INDEX function in Excel?
What is the purpose of the INDEX function in Excel?
Which function would you use to find the current date in Excel?
Which function would you use to find the current date in Excel?
In Excel 365, which dynamic array function returns a unique list of values from a range?
In Excel 365, which dynamic array function returns a unique list of values from a range?
Which Excel feature allows you to split the screen into multiple panes?
Which Excel feature allows you to split the screen into multiple panes?
What is the use of the MATCH function in Excel?
What is the use of the MATCH function in Excel?
Which tool in Excel allows you to summarize large datasets using interactive tables?
Which tool in Excel allows you to summarize large datasets using interactive tables?
What does the VLOOKUP function do in Excel?
What does the VLOOKUP function do in Excel?
In Excel 365, what is the function of the LET function?
In Excel 365, what is the function of the LET function?
Which of the following options allows you to protect a worksheet from changes?
Which of the following options allows you to protect a worksheet from changes?
Which Excel function would you use to join several text strings into one text string?
Which Excel function would you use to join several text strings into one text string?
What is the purpose of the conditional formatting feature in Excel?
What is the purpose of the conditional formatting feature in Excel?
Which Excel feature allows you to apply a predefined style to your data?
Which Excel feature allows you to apply a predefined style to your data?
Flashcards are hidden until you start studying