Font size
WorksheetsExcel 2019 Quiz
Total questions: 10
Worksheet time: 8mins
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
