Excel 2019 Quiz

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

• MAX

• SUM

• AVG

• MIN

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

• Ctrl + N

• Ctrl + Shift + N

• Ctrl + W

• Ctrl + I

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

• Formulas

• PivotTables

• Sparklines

• SmartArt

What does the COUNTIF function in Excel 2019 do?

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

• Home

• Formulas

• Data

• Insert

What is the purpose of the VLOOKUP function in Excel?

• Vertical lookup

• Horizontal lookup

• Logical lookup

• Lookup for text values

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

• Ctrl + P

• Ctrl + V

• Ctrl + Alt + P

• Ctrl + Shift + V

Which chart type is suitable for displaying the percentage contribution of each data point to the whole in Excel?

• Pie Chart

• Bar Chart

• Line Chart

• Scatter Plot

What does the CONCATENATE function do in Excel 2019?

• Adds up values in a range

• Combines multiple text strings into one string

• Calculates the average of a range

• Divides values in a range

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

• Lock specific cells to prevent editing

• Hide selected rows or columns

• Keep selected rows or columns visible while scrolling

• Split the worksheet into multiple panes