Excel 2019 Flashcard

Front

Which function in Excel 2019 is used to find the highest value in a range of cells?

Back

MAX

Front

In Excel 2019, what keyboard shortcut is used to insert a new worksheet?

Back

Ctrl + Shift + N

Front

Which Excel feature allows you to visually represent data through charts and graphs?

Back

Sparklines

Front

Which ribbon tab in Excel 2019 is specifically dedicated to dealing with formulas and functions?

Back

Formulas

Front

What is the purpose of the VLOOKUP function in Excel?

Back

Vertical lookup

Front

In Excel 2019, what is the shortcut for "Paste Special"?

Back

Ctrl + Shift + V

Front

Which chart type is suitable for displaying the percentage contribution of each data point to the whole in Excel? Options: Pie Chart, Bar Chart, Line Chart, Scatter Plot

Back

Pie Chart

Front

What does the CONCATENATE function do in Excel 2019?

Back

Combines multiple text strings into one string

Front

In Excel 2019, what does the Freeze Panes feature allow you to do?

Back

Keep selected rows or columns visible while scrolling